| From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
|---|---|
| To: | <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pg_constraint and constraint triggers |
| Date: | 2003-04-26 08:53:17 |
| Message-ID: | 50116.80.177.99.193.1051347197.squirrel@ssl.vale-housing.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-hackers pgsql-hackers |
It's rumoured that Tom Lane once said:
> "Dave Page" <dpage(at)vale-housing(dot)co(dot)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.
Ahh thanks. I had a browse through /contrib but obviously missed that.
Regards, Dave.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Pflug | 2003-04-26 11:27:02 | pgadmin3 wizard snapin technology |
| Previous Message | Tom Lane | 2003-04-25 22:20:54 | Re: pg_namespace -> pg_schema? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Pflug | 2003-04-26 11:27:02 | pgadmin3 wizard snapin technology |
| Previous Message | Sumaira Ali - | 2003-04-26 01:37:44 | Re: Putting code in main of src/backend/main/main.c |