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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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 [at] postgresql.org [mailto:pgsql-admin-owner [at] postgresql=
..org] On Behalf Of k_b0000 [at] yahoo.se
Sent: Tuesday, October 20, 2009 12:21 PM
To: pgsql-admin [at] postgresql.org
Subject: [ADMIN] PostgreSQL 8.4.1 - ERROR: column "reltriggers" does not ex=
ist

Hi.

We use PostgreSQL 8.4.1 on linux.
In one of the databases we use we see the following problem.


database=3D# \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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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

k_b0000 [at] 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

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

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


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