2009/9/9 Martin Edlman <[email protected]>: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hello, > >> please send function xfunc. Your code looks well. >> please try sql function >> ... >> has it same behave like plpgsql function? > > Yes, result is the same - it returns 2008-11-01 > > I made further investigation - it seems the problem is here between the > keyboard and the chair :-) > > As I wrote an answer for you I realized the problem. The xfunc() and > therefore get_schemebind_date() is called from a trigger AFTER DELETE ON > schemebind. So the trigger deletes the '2009-09-01' record, > get_schemebind_date() then returns correct result '2008-11-01'. But > xfunc() then fails and the trigger operation is rolled back and I see > the '2009-09-01' record again... > Sorry guys for bothering you and taking your time.
v pohode :) Pavel > > Regards, > - -- > Martin Edlman > Fortech, spol. s r.o, > Ropkova 51, 57001 Litomyšl > Public GPG key: http://edas.visaci.cz/#gpgkeys > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.9 (GNU/Linux) > Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ > > iEYEARECAAYFAkqnfE4ACgkQqmMakYm+VJ8iswCggwTcu9pZQOaAjAIjW0D22kTs > HYIAni3mLdNilwgxNeQsGFxNogBg6OCL > =ZVLv > -----END PGP SIGNATURE----- > -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
