Lists: | pgsql-general |
---|
From: | Diogo Biazus <diogo(at)ikono(dot)com(dot)br> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Strange problem with PL/PgSQL stored procedures |
Date: | 2003-08-22 08:57:06 |
Message-ID: | 3F45DAE2.5090403@ikono.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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(at)ikono(dot)com(dot)br
http://www.ikono.com.br
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Diogo Biazus <diogo(at)ikono(dot)com(dot)br> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Strange problem with PL/PgSQL stored procedures |
Date: | 2003-08-24 22:25:37 |
Message-ID: | 12998.1061763937@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Diogo Biazus <diogo(at)ikono(dot)com(dot)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