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

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