Re: pl/pgsql & fk constraint - Mailing list pgsql-general

From Sindunata Sudarmaji
Subject Re: pl/pgsql & fk constraint
Date
Msg-id 20030120131130.A20783@top4
Whole thread Raw
In response to Re: pl/pgsql & fk constraint  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
Hi Stephan,

Thanks for the info, just downloaded and tested it on 7.3.1 and it's fixed
already. You guys are doing great job!

regrads,
Sindu

On Tue, Jan 14, 2003 at 08:24:08AM -0800, Stephan Szabo wrote:
> On Tue, 14 Jan 2003, Sindunata Sudarmaji wrote:
>
> > Hi all,
> >
> > I think I found a bug in the combination of PL/PGSQL and Foreign Key
> > constraint. Please find below a sample case problem:
>
> Try upgrading to 7.3 and seeing if you still see errors, various
> intermediate state bugs were fixed between 7.2 and 7.3.  I believe
> this is fixed by the check to see if a pk table row was inserted
> that matches the row being modified in the no action triggers.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: passwords and 7.3
Next
From: jerome
Date:
Subject: URGENT: dropping constraints and references from a table