| From: | Andy Ballingall <andy(at)areyoulocal(dot)co(dot)uk> |
|---|---|
| To: | "'Peter Eisentraut'" <peter_e(at)gmx(dot)net> |
| 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 15:28:10 |
| Message-ID: | ECOWS02MmWL9vVmguzY0004c4cf@smtp-out2.blueyonder.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hello Peter,
I'm glad it's possible, but I can't see how from the documentation.
Say if I have a table called 'apples' and a table called 'pears'.
What would the rule look like that would remap all updates on apples so that
they were applied to pears instead?
Thanks,
Andy
-------------------------
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/
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.4/176 - Release Date: 20/11/2005
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joost Kraaijeveld | 2005-11-20 15:36:30 | Re: Trigger / rule question |
| Previous Message | Jaime Casanova | 2005-11-20 14:23:29 | Re: Is it possible to redirect an update/insert/delete to a different table? |