Re: Foreign key not working in some cases when using triggers - Mailing list pgsql-bugs

From Martin Edlman
Subject Re: Foreign key not working in some cases when using triggers
Date
Msg-id Pine.LNX.4.44.0309050855250.8418-100000@worm.fortech.cz
Whole thread Raw
In response to Re: Foreign key not working in some cases when using triggers  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-bugs
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> 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.

The functions replacement should be ok.

> 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?

When I have some spare time I'll try to do it, but now I'm very busy.
The whole database is much bigger with more complex RI/FK, so it would be
interresting if the same problematic data I have in the tables zone and
qmail_account will work on the stripped database.

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

I reindexed it several times. I didn't help.

Regards, Martin

- --

Martin Edlman
Fortech s.r.o, Litomysl
Public PGP key: http://edas.visaci.cz/#keys
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE/WDSUoFlEKJy9loQRAsl/AJ4gYQtQrNNMG8PxjKJAr0DYHUZbHwCdGgks
ljxSijx6g2NOeA90N3MN/m8=
=CBtj
-----END PGP SIGNATURE-----

pgsql-bugs by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Foreign key not working in some cases when using triggers
Next
From: Andreas Pflug
Date:
Subject: Re: pgadmin 3 bug - crash on start, win95b