Re: updating a view

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: updating a view
Дата
Msg-id 583.1166149420@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: updating a view  (m.c.wilkins@massey.ac.nz)
Ответы Re: updating a view  (m.c.wilkins@massey.ac.nz)
Список pgsql-general
m.c.wilkins@massey.ac.nz writes:
> so maybe i'm using the word crash too liberally.  this is the error
> message i get:

> server closed the connection unexpectedly

Looks like a crash to me.

> version is 8.2.0, just downloaded a few days ago.

There's a known bug in 8.2.0 having to do with failing out of a
subtransaction, which would include a plperlu spi_exec() to a query
that gets an error.  So I'm thinking that might be what you're hitting.
If you built from source, you could apply this patch:
http://archives.postgresql.org/pgsql-committers/2006-12/msg00063.php

            regards, tom lane

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

Предыдущее
От: m.c.wilkins@massey.ac.nz
Дата:
Сообщение: Re: updating a view
Следующее
От: Peter Koczan
Дата:
Сообщение: Re: A few SQL questions