Re: Create Rule - Mailing list pgsql-general

From Tom Lane
Subject Re: Create Rule
Date
Msg-id 19671.1005864866@sss.pgh.pa.us
Whole thread Raw
In response to Create Rule  (Fernando San Martín Woerner <snmartin@galilea.cl>)
List pgsql-general
=?iso-8859-1?Q?Fernando_San_Mart=EDn_Woerner?= <snmartin@galilea.cl> writes:
> i'm trying to do this
> CREATE RULE borra_presupuesto AS ON DELETE TO presupuesto DO INSTEAD
> (UPDATE presupuesto SET en_uso = 'False' WHERE cod_presupuesto =
> old.cod_presupuesto;
> UPDATE detalle_presupuesto SET en_uso = 'False' WHERE cod_presupuesto =
> old.cod_presupuesto);

> but i get this error:
> ERROR:  parser: parse error at or near ""

Looks okay here: I get 'Relation "presupuesto" does not exist'
so it's getting past the parsing stage.

What PG version are you using?  I have a vague recollection that
the syntax for multiple-action rules might have changed awhile back.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Idle in transaction ????
Next
From: "Gurupartap Davis"
Date:
Subject: Re: pgsql and large tables