Re: Is it possible to redirect an update/insert/delete to a different table?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: andy(at)areyoulocal(dot)co(dot)uk
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Is it possible to redirect an update/insert/delete to a different table?
Date: 2005-11-20 11:07:00
Message-ID: 200511201207.01114.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Eisentraut 2005-11-20 11:08:00 Re: Trigger / rule question
Previous Message Mario Splivalo 2005-11-20 10:35:07 Re: Create Public Schema