>-----Original Message----- >From: pgsql-general-owner@xxxxxxxxxxxxxx >[mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of >Martijn van Oosterhout >Sent: donderdag 22 februari 2007 18:17 >To: Joris Dobbelsteen >Cc: Robert Haas; pgsql-general@xxxxxxxxxxxxxx >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
