Strange problem with PL/PgSQL stored procedures

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