Postgres Pro
Downloads
Home   >   mailing lists

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

FromJaime Casanova
SubjectRe: Is it possible to redirect an update/insert/delete to a different table?
Date
Msg-id[email protected]
Whole thread Raw
In response toIs it possible to redirect an update/insert/delete to a different table?  (Andy Ballingall <[email protected]>)
ResponsesRe: Is it possible to redirect an update/insert/delete to a different table?
Listpgsql-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?