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