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). ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly