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

[Ayan G. <ay...@ay...>]

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 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?
>

What version of PostgreSQL are you running and which version of libpq is
your nspostgres linked against?

When you moved servers, did you also change the version of postgres
you're using?

-ayan