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

From Peter Eisentraut
Subject Re: Is it possible to redirect an update/insert/delete to a different table?
Date
Msg-id 200511201207.01114.peter_e@gmx.net
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
Andy Ballingall wrote:
> 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.

You can write a couple of rules for that.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


pgsql-sql by date:

Previous
From: Mario Splivalo
Date:
Subject: Re: Create Public Schema
Next
From: Peter Eisentraut
Date:
Subject: Re: Trigger / rule question