pg_constraint and constraint triggers

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_constraint and constraint triggers
Date: 2003-04-25 20:19:01
Message-ID: 03AF4E498C591348A42FC93DEA9661B83AF05A@mail.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgsql-hackers

Hi all,

I couldn't find anything obvious in the archives, but if I dump a
database created in 7.2, then foreign keys are created using CREATE
CONSTRAINT TRIGGER statement. These do not appear to create entries in
pg_constraint in 7.3.x, so as the database is developed further, we end
up with 2 'styles' of fkeys in the catalogues.

This is a pain in pgAdmin III as we we're hoping to use pg_constraint
for simplicity (figuring out the fkeys in 7.2 was always fun :-) ). Is
there any way to get the required entries in the catalog easily, or
should I look at writing some code to generate them (or alternatively,
is there a reason why I shouldn't)?

Regards, Dave.

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Tom Lane 2003-04-25 20:51:00 Re: pg_constraint and constraint triggers
Previous Message Dave Page 2003-04-25 07:00:24 Re: pgadmin gods

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-04-25 20:51:00 Re: pg_constraint and constraint triggers
Previous Message Jan Wieck 2003-04-25 19:52:16 Re: [PERFORM] Foreign key performance