Skip site navigation (1) Skip section navigation (2)

Re: Foreign key not working in some cases when using triggers

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Martin Edlman <edlman(at)fortech(dot)cz>
Cc: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Foreign key not working in some cases when using triggers
Date: 2003-09-05 06:13:42
Message-ID: 20030904230659.K61042-100000@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Fri, 5 Sep 2003, Martin Edlman wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> > If possible, can you give a complete example script that shows the
> > problem?
>
> Here it is.
>

Unfortunately the trigger depends on some other functions that I dind't
have so I replaced those with string constants.  I couldn't get it to fail
with a little bit of playing around on my 7.3.4 box, however.

If you set up a new database with the tables and triggers involved, can
you get it to fail with some test data, and if so, can you send a dump of
the new database along with the command you ran to get it to fail?

If you don't get it to fail, it might be worth trying to reindex the index
on zone(name).



In response to

Responses

pgsql-bugs by date

Next:From: Martin EdlmanDate: 2003-09-05 07:00:30
Subject: Re: Foreign key not working in some cases when using triggers
Previous:From: Martin EdlmanDate: 2003-09-05 05:36:29
Subject: Re: Foreign key not working in some cases when using triggers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group