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@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of k_b0000@xxxxxxxx Sent: Tuesday, October 20, 2009 12:21 PM To: pgsql-admin@xxxxxxxxxxxxxx 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
