Re: Problems using a rule with the WHERE clause

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Luis Sousa <llsousa(at)ualg(dot)pt>
Cc: pgsql sql Mailing List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Problems using a rule with the WHERE clause
Date: 2001-06-26 14:41:20
Message-ID: 3075.993566480@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Luis Sousa <llsousa(at)ualg(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Eisentraut 2001-06-26 14:43:54 Re: Changing datatype of a column
Previous Message Tom Lane 2001-06-26 14:32:01 Re: [SQL] loosing connection after function call