Thanks for the reply, well that would be nice I'll try that when I
update a database to 8.1
I still have some databases that I can't update at this moment so if
anyone has a way I can fix it on a 8.0 database that would be nice

I agree it's an ugly and fragile thing messing with the system tables
but well I only did it because I had no clue how to do it without it.


-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Friday, May 12, 2006 17:10
To: Robert Landsmeer
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Wondering if anyone could help me

"Robert Landsmeer" <r.landsmeer@wis.nl> writes:
> http://archives.postgresql.org/pgsql...5/msg00045.php

If you're using PG 8.1, get rid of that ugly and fragile messing with
the system catalogs, and use ALTER TABLE ENABLE/DISABLE TRIGGER instead.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster