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