Re: BUG #5798: Some weird error with pl/pgsql procedure

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #5798: Some weird error with pl/pgsql procedure
Дата
Msg-id 28329.1298131693@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #5798: Some weird error with pl/pgsql procedure  (Maxim Boguk <maxim.boguk@gmail.com>)
Ответы Re: BUG #5798: Some weird error with pl/pgsql procedure
Список pgsql-bugs
Maxim Boguk <maxim.boguk@gmail.com> writes:
> I finally managed create working slave server with non-stripped Postgresql
> 8.4.7 and working gdb.
> (sorry for such long delay).
> And i can reproduce situation quite easy now, so i managed get stack
> backtrace with that error.
> What i need to do now? I have some expirience with gbd now but i have no
> idea where to look next.

Now that you know what query is causing the problem:

> #9  0x0000000000673d43 in ProcessQuery (plan=0xdd0998890,
>     sourceText=0xdd09c5830 "UPDATE ONLY bill.ctrl_servers SET opt = opt
> WHERE ctid=ANY($1) RETURNING ctid", params=0xdd09c58c0,
>     dest=0xdd09de5c8, completionTag=0x7fffffffd4e0 "") at pquery.c:196

it shouldn't be too hard to prepare a self-contained test case so that
others can look at this.

            regards, tom lane

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

Предыдущее
От: Maxim Boguk
Дата:
Сообщение: Re: BUG #5798: Some weird error with pl/pgsql procedure
Следующее
От: Maxim Boguk
Дата:
Сообщение: Re: BUG #5798: Some weird error with pl/pgsql procedure