Re: Problems using a rule with the WHERE clause

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problems using a rule with the WHERE clause
Дата
Msg-id 3075.993566480@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Problems using a rule with the WHERE clause  (Luis Sousa <llsousa@ualg.pt>)
Список pgsql-sql
Luis Sousa <llsousa@ualg.pt> writes:
> I think this code is OK !!!!!

You probably don't want the second and third rules to be INSTEAD.
However,

> But I got the error message bellow in line 11
> of my script, that corresponds to the rule updateturnodocente_default
>
> psql:dev/pessoal/def/views_rules/teste_update:11: pqReadData() -- backend
> closed the channel unexpectedly.

that shouldn't happen, in any case.  If this is the current release
(7.1.2) then I'd like to see a complete script to reproduce the problem.
(I don't have time to guess at your table declarations...)
        regards, tom lane


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

Предыдущее
От: John Hasler
Дата:
Сообщение: Nested Transactions
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Changing datatype of a column