Thread: Strange problem with PL/PgSQL stored procedures

Strange problem with PL/PgSQL stored procedures

From
Diogo Biazus
Date:
 From time to time I'm getting this error message:
WARNING:  Error occurred while executing PL/pgSQL function atualizabusca
WARNING:  line 25 at for over select rows
ERROR:  unknown cmdtype 136748160 in exec_stmt

It's a 7.3.3 running on a FreeBSD 4.8
When I recreate the function it works well for some time, but after
using the database for some hours this error shows up again.
Very strange, does anyone has a clue?

Thanks in advance,

--
Diogo Biazus
diogo@ikono.com.br
http://www.ikono.com.br



Re: Strange problem with PL/PgSQL stored procedures

From
Tom Lane
Date:
Diogo Biazus <diogo@ikono.com.br> writes:
>  From time to time I'm getting this error message:
> WARNING:  Error occurred while executing PL/pgSQL function atualizabusca
> WARNING:  line 25 at for over select rows
> ERROR:  unknown cmdtype 136748160 in exec_stmt

> It's a 7.3.3 running on a FreeBSD 4.8
> When I recreate the function it works well for some time, but after
> using the database for some hours this error shows up again.

Hm.  By "for some hours" do you mean a single open session that's been
using the database for that long?  If so, does exiting that session and
starting a new one make the problem disappear?

            regards, tom lane