-----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----- ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
