Re: Problems using a rule with the WHERE clause - Mailing list pgsql-sql

From Tom Lane
Subject Re: Problems using a rule with the WHERE clause
Date
Msg-id 3075.993566480@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problems using a rule with the WHERE clause  (Luis Sousa <llsousa@ualg.pt>)
List 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 by date:

Previous
From: John Hasler
Date:
Subject: Nested Transactions
Next
From: Peter Eisentraut
Date:
Subject: Re: Changing datatype of a column