AW: [HACKERS] Rule system - Mailing list pgsql-hackers

From Andreas Zeugswetter
Subject AW: [HACKERS] Rule system
Date
Msg-id 01BDC5E2.F9BC2620@zeugswettera.user.lan.at
Whole thread Raw
Responses Re: AW: [HACKERS] Rule system  (jwieck@debis.com (Jan Wieck))
List pgsql-hackers
Jan Wieck wrote:
> What  else  must be there? I think everything on the instance
> level  is  better  done  by   triggers.   And   if   we   add
> row-/statement-level  triggers  on  SELECT, there would be no
> reason left to have  non-instead  rules.   Or  am  I  missing
> something?
While this is in my opinion true, it would be nice to extend the trigger syntax to
allow the triggered action to be expressed in sql like:

create trigger blabla after delete on people
referencing old as o
(insert into graves values (o.*));    -- disregard the syntax

Andreas


pgsql-hackers by date:

Previous
From: Andreas Zeugswetter
Date:
Subject: AW: [HACKERS] partial index
Next
From: Maarten Boekhold
Date:
Subject: Re: [HACKERS] 6.3.2. patch for functional indices