Re: Strange problem with PL/PgSQL stored procedures - Mailing list pgsql-general

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