Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_constraint and constraint triggers - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_constraint and constraint triggers
Date
Msg-id 29916.1051303860@sss.pgh.pa.us
Whole thread Raw
In response to pg_constraint and constraint triggers  ("Dave Page" <dpage@vale-housing.co.uk>)
Responses Re: pg_constraint and constraint triggers  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgsql-hackers
Tree view 
"Dave Page" <dpage@vale-housing.co.uk> writes:
> 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.

contrib/adddepend/ is supposed to help out with upgrading definitions
loaded from old databases.  Possibly you could adapt its logic into
a "fix things" operation in pgAdmin.
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Dave Page"
Date:
Subject: pg_constraint and constraint triggers
Next
From: Sean Chittenden
Date:
Subject: pg_namespace -> pg_schema?