Re: Strange problem with PL/PgSQL stored procedures

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Strange problem with PL/PgSQL stored procedures
Дата
Msg-id 12998.1061763937@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Strange problem with PL/PgSQL stored procedures  (Diogo Biazus <diogo@ikono.com.br>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: merge multiple records into 1
Следующее
От: "Jenny -"
Дата:
Сообщение: LOCK.tag(figuring out granularity of lock)--