Thread

Re: [HACKERS] Re: Referential Integrity In PostgreSQL

Zeugswetter Andreas <andreas.zeugswetter@telecom.at> — 1999-09-21T09:24:09Z

> Oh - well - vacuum shouldn't touch  relations  where
> deferred   triggers  are  outstanding.   Might  require  some
> special lock entry - Vadim?

All modified data will be in this same still open transaction.
Therefore no relevant data can be removed by vacuum anyway.

It is my understanding, that the RI check is performed on the newest 
available (committed) data (+ modified data from my own tx). 
E.g. a primary key that has been removed by another transaction after
my begin work will lead to an RI violation if referenced as foreign key.

Andreas