Postgres Pro
Downloads
Home   >   mailing lists

Re: Is it possible to redirect an update/insert/delete to a different table? - Mailing list pgsql-sql

From Jaime Casanova
Subject Re: Is it possible to redirect an update/insert/delete to a different table?
Date
Msg-id c2d9e70e0511200623w6e90d15bt64a03a2cfcd7132b@mail.gmail.com
Whole thread Raw
In response to Is it possible to redirect an update/insert/delete to a different table?  (Andy Ballingall <andy@areyoulocal.co.uk>)
Responses Re: Is it possible to redirect an update/insert/delete to a different table?
List pgsql-sql
Tree view 
> I've looked through rules, and as far as I can make out, they are only
> useful for explicit actions. I'm looking for something that behaves as
> though it simply substitutes the table name for a different table name
> before executing the command, no matter what the command looks like.
>

Make 3 rules (INSERT/UPDATE/DELETE), 4 if you want SELECT as well...

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Trigger / rule question
Next
From: Andy Ballingall
Date:
Subject: Re: Is it possible to redirect an update/insert/delete to a different table?