Re: [AOLSERVER] Aolserver - Postgresql - not recognizing columns added to tables

[Sep <the...@gm...>]

I don't quite remember my postgresql, but I'm presuming that maybe
postgresql has something like a data dictionary like in Oracle that needs
syncing perhaps?

Regards.

2015-08-10 8:44 GMT+08:00 Peter Sadlon <f_p...@ho...>:

> Just to better understand your problem, this was the order of events?
>
> old server: create table
> old server: alter table add column
> old server: select any/all columns work
>
> copy to new server
>
> new server: select from original columns work with postgresdql
> new server: select from an added column works with postgresdql
> new server: select from original columns work with tcl
> new server: select from an added column FAILS with tcl
>
> My first guess would be to make sure your config script is connecting to
> the correct database/server now that you have multiple db servers.  Same
> thing for postgresdql.
>
> Are you connecting with the same username via postgresdql and tcl?
>
> Next check your pg_dump file, do a grep for the new column name, make sure
> that it is included in the dump.
>
>
> ------------------------------
> From: tm...@ec...
> Date: Sun, 9 Aug 2015 14:03:28 -0500
> To: aol...@li...
> Subject: [AOLSERVER] Aolserver - Postgresql - not recognizing columns
> added to tables
>
>
> Hi,
>
> I have moved postgresql databases from one server to another. This was
> done by dumping the database, moving the resulting file to the new server,
> and then restoring the dumped file on the new server.
>
> When I directly select rows via postgresdql (on the new server) from a
> table that had a column added after the table was created and before the
> table was moved to the new server there are not any problems.
>
> However, when I try to do the same select from within a tcl script an
> error is thrown - the column does not exist. When I run the sql statement
> without the offending column, there is not a problem.
>
> So, it appears to me that the problem is with columns that have been added
> to tables via alter table…
>
> Can anyone shed some light on this problem?
>
> Thank you,
>
> Thorpe
>
> Thorpe Mayes
> eCognizant LLC
> 2313 Lockhill-Selma Road, Ste 164
> San Antonio, TX 78230
> Phone: (405) 445-7877
> Cell: (405) 514-9753
>
>
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> _______________________________________________ aolserver-talk mailing
> list aol...@li...
> https://lists.sourceforge.net/lists/listinfo/aolserver-talk
>
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> aolserver-talk mailing list
> aol...@li...
> https://lists.sourceforge.net/lists/listinfo/aolserver-talk
>
>


-- 
"A scrum a day keeps the pigs at bay"