Re: PostgreSQL 8.4.1 - ERROR: column "reltriggers" does not exist

k_b0000@yahoo.se writes:
> We use PostgreSQL 8.4.1 on linux.
> In one of the databases we use we see the following problem.

> database=# \d table001
> ERROR:  column "reltriggers" does not exist
> LINE 1: SELECT relhasindex, relkind, relchecks, reltriggers, relhasr...
>                                                  ^


You are apparently trying to use a pre-8.4 version of psql against an
8.4 server.  Please pay attention to the warning message it generates:

Welcome to psql 8.3.8 (server 8.4.1), the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

WARNING:  You are connected to a server with major version 8.4,
but your psql client is major version 8.3.  Some backslash commands,
such as \d, might not work properly.

regression=# \d foo
ERROR:  column "reltriggers" does not exist
LINE 1: SELECT relhasindex, relkind, relchecks, reltriggers, relhasr...
                                                ^
regression=#


            regards, tom lane