> > FOREIGN KEY INSERT & UPDATE/DELETE in transaction "change violation"
> A well known issue, and I've asked multiple times how exactly
> we want to define the behaviour for deferred constraints. Do
> foreign keys reference just to a key value and are happy with
> it's existance, or do they refer to a particular row?
Sorry, to answer late. I didn't know this needed clarification.
The answer is simple, foreign keys only reference a key value,
not a particular row.
pgsql-hackers by date
|Next:||From: Mikheev, Vadim||Date: 2001-01-26 18:02:59|
|Subject: RE: Open 7.1 items|
|Previous:||From: Tom Lane||Date: 2001-01-26 17:47:42|
|Subject: Re: Hardwired MAXBACKENDS limit could be history |