Luis Sousa <[EMAIL PROTECTED]> writes:
>> that shouldn't happen, in any case. If this is the current release
>> (7.1.2)
> The version that I'm using is 7.1release-3.potato.1
I don't see any problem here when I run your script. I suspect you are
seeing another consequence of the rewriter bug I
Luis Sousa <[EMAIL PROTECTED]> 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
Luis Sousa <[EMAIL PROTECTED]> writes:
> CREATE RULE "updateturnodocente" AS ON UPDATE TO "docentesturno"
> WHERE OLD.idpessoal != 0
> DO INSTEAD (
> ...
> When I execute the INSERT into de view docentesturno I got the message:
> ERROR: Cannot update a view without an appropriate
