Re: TODO list comments - Mailing list pgsql-hackers

From Michael Glaesemann
Subject Re: TODO list comments
Date
Msg-id DA46551D-76CC-4B87-BE97-2D463CA505AD@myrealbox.com
Whole thread Raw
In response to TODO list comments  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: TODO list comments  (Matt Miller <mattm@epx.com>)
List pgsql-hackers
On Aug 25, 2005, at 10:58 AM, Tom Lane wrote:

>> * %Remove CREATE CONSTRAINT TRIGGER
>>
>>   This was used in older releases to dump referential integrity
>>   constraints.
>>
>
> Do we really want to remove it, and thereby guarantee we can't load
> dumps from those old releases?

Also, I believe CONSTRAINT TRIGGERS are the only way to provide  
transaction level (rather than statement level) referential  
integrity. I've used this in the past. The SQL command reference page  
mentions that it's not for general use, but it'd be a shame to remove  
it before there's an alternative way to provide transaction level  
referential integrity.

Michael Glaesemann
grzm myrealbox com




pgsql-hackers by date:

Previous
From: Andrew - Supernews
Date:
Subject: Re: Win32 Thread safetyness
Next
From: Hannu Krosing
Date:
Subject: Re: TODO list comments