Horton

Re: Referencial integrity when there are timestamp primary keys

Bruce Momjian <pgman@candle.pha.pa.us>

View thread
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: Vilson farias <vilson.farias@digitro.com.br>, pgsql-bugs@postgresql.org
Date: 2000-10-10T17:13:25Z
Lists: pgsql-bugs 
Applied.  Thanks.

> 
> This is a stupid garden variety bug and I'm not sure why I didn't catch
> it previously.  The patch included is against fairly current sources, but
> it may apply cleanly against 7.0.2 as well.
> 
> On Fri, 6 Oct 2000, Vilson farias wrote:
> 
> > I found a irregular behavior with constraints.
> > 
> > I can only set a referencial integrity between these tables when there are
> > no data, even if there are no change to referential integrity violation.
Content-Description: 

[ Attachment, skipping... ]


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026