Re: complex referential integrity constraints

>-----Original Message-----
>From: pgsql-general-owner(at)postgresql(dot)org
>[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of
>Martijn van Oosterhout
>Sent: donderdag 22 februari 2007 18:17
>To: Joris Dobbelsteen
>Cc: Robert Haas; pgsql-general(at)postgresql(dot)org
>Subject: Re: [GENERAL] complex referential integrity constraints
>
>On Thu, Feb 22, 2007 at 05:28:35PM +0100, Joris Dobbelsteen wrote:
>> Even worse, I don't you can guarentee that this constraint
>is enforced
>> at all times. That means, not if you are using triggers.
>> The only option seems using foreign keys and put in a lot of
>redundant
>> data.
>
>Err, foreign keys are implemented using triggers, so this
>statement is self-contradictary.

Are you really sure they are executed under the same visibility rules?

- Joris