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