Re: [HACKERS] FOREIGN KEY revisited

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

In response to

Browse pgsql-hackers by date

  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