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

2015-08-10 Thread Thorpe Mayes
Hi, Here is where postgres is located on the server: ps auxw | grep postgres | grep -- -D postgres 1740 0.0 0.0 160284 7616 ?S02:49 0:00 /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data Here is how I installed nspostgres-4.1: make install

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

2015-08-10 Thread Tony Bennett (Brown Paper Tickets)
Also I'm curious to know if there's anything special about the new columns. Are they encrypted or a strange datatype? If it's a newish type of field then the tcl might need updating to use it. On 8/10/15 5:05 AM, Tony Bennett (Brown Paper Tickets) wrote: The same select should work in tcl

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

2015-08-09 Thread Ayan George
Also, can you see the new columns by searching the information schema in both psql and aolserver? -- ___ aolserver-talk mailing list aolserver-talk@lists.sourceforge.net

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

2015-08-09 Thread Ayan George
On 08/09/2015 03:03 PM, Thorpe Mayes wrote: 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

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

2015-08-09 Thread Sep
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