Обсуждение: PostgreSQL 8.4.1 - ERROR: column "reltriggers" does not exist

Hi.

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...
                                                 ^


As i understand from from seaching the archives reltriggers was changed in
8.4, what i do not understand is what to do about it.

Is there a fix or SQL i can apply or run to fix this issue, or would it be
possible to dump all data and re-import it?

Any suggestion on what can be done?


Thanks!

Could you perhaps be using an old version of psql (prior to 8.4.0)?  8.4.0 dropped using that and now uses
relhastriggers.

-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of k_b0000@yahoo.se
Sent: Tuesday, October 20, 2009 12:21 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] PostgreSQL 8.4.1 - ERROR: column "reltriggers" does not exist

Hi.

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...
                                                 ^


As i understand from from seaching the archives reltriggers was changed in
8.4, what i do not understand is what to do about it.

Is there a fix or SQL i can apply or run to fix this issue, or would it be
possible to dump all data and re-import it?

Any suggestion on what can be done?


Thanks!

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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

Of course you are right.
It turns out that the machine i connected from did not have an upgrade of
postgresql. After upgrading it all works!

Thank you!




2009-10-20 13:16 Plugge, Joe R. wrote:

> Could you perhaps be using an old version of psql (prior to 8.4.0)?  8.4.0 dropped using that and now uses
relhastriggers.
>
> -----Original Message-----
> From:
> Sent: Tuesday, October 20, 2009 12:21 PM
> To:
> Subject: [ADMIN] PostgreSQL 8.4.1 - ERROR: column "reltriggers" does not exist
>
> Hi.
>
> 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...
>                                                 ^
>
>
> As i understand from from seaching the archives reltriggers was changed in
> 8.4, what i do not understand is what to do about it.
>
> Is there a fix or SQL i can apply or run to fix this issue, or would it be
> possible to dump all data and re-import it?
>
> Any suggestion on what can be done?
>
>
> Thanks!
>