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_petra...@hotmail.com>: > 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: tma...@ecognizant.com > Date: Sun, 9 Aug 2015 14:03:28 -0500 > To: aolserver-talk@lists.sourceforge.net > 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 aolserver-talk@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/aolserver-talk > > > ------------------------------------------------------------------------------ > > _______________________________________________ > aolserver-talk mailing list > aolserver-talk@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/aolserver-talk > > -- "A scrum a day keeps the pigs at bay"
------------------------------------------------------------------------------
_______________________________________________ aolserver-talk mailing list aolserver-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/aolserver-talk
