From: | Martin Edlman <edlman(at)fortech(dot)cz> |
---|---|
To: | PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: Foreign key not working in some cases when using triggers |
Date: | 2003-09-05 07:00:30 |
Message-ID: | Pine.LNX.4.44.0309050855250.8418-100000@worm.fortech.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2003-09-05 08:20:47 | Re: pgadmin 3 bug - crash on start, win95b |
Previous Message | Stephan Szabo | 2003-09-05 06:13:42 | Re: Foreign key not working in some cases when using triggers |