From: Sep <the...@gm...> - 2015-08-10 00:47:05
|
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" |