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

[Tony B. (B. P. Tickets) <to...@br...>]

The same select should work in tcl for the added column.  Try updating a 
record in postgresql and selecting the same record from tcl. If there's 
a mismatch then they're not connecting to the same place.

-Tony

On 8/9/15 5:44 PM, Peter Sadlon wrote:
> 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