| 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: | Whole Thread | Raw Message | 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 |