From: | Vadim Mikheev <vadim(at)krs(dot)ru> |
---|---|
To: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
Cc: | "Matthew N(dot) Dodd" <winter(at)jurai(dot)net>, pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] FOREIGN KEY revisited |
Date: | 1998-08-28 07:31:55 |
Message-ID: | 35E65CEB.EDB995F4@krs.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Thomas G. Lockhart wrote:
>
> Back to your question: Postgres probably does not remove trigger
> functions if a table is destroyed, but that isn't a problem if the
> trigger function is generic code which will be reused anyway.
Both functions in spi/refint.c are generic ones. They should be
part of core system, not of contrib, to be used for FOREIGN KEY
in CREATE TABLE...
No problems with using them.
>
> Vadim has been thinking about how to do foreign keys, but I can't
> remember if it was via triggers or some other means.
^^^^^^^^^^^^
No. Via indices.
Vadim
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Ivar Helbekkmo | 1998-08-28 07:38:05 | Re: [HACKERS] vacuum problem |
Previous Message | Michael Meskes | 1998-08-28 07:06:29 | New problem |