From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Martin Edlman <edlman(at)fortech(dot)cz> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #5043: Stored procedure returning different results for same arguments |
Date: | 2009-09-09 10:19:15 |
Message-ID: | 162867790909090319t2843aa3dw2f24943282743e8a@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
2009/9/9 Martin Edlman <edlman(at)fortech(dot)cz>:
> -----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-----
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2009-09-09 11:49:49 | Re: BUG #5044: error: message type 0x5a arrived from server while idle |
Previous Message | Martin Edlman | 2009-09-09 09:58:39 | Re: BUG #5043: Stored procedure returning different results for same arguments |