From: Andy Ballingall <andy@areyoulocal.co.uk>
To: 'Andreas Kretschmer' <akretschmer@spamfence.net>
To: pgsql-sql@postgresql.org
Subject: Re: Is it possible to redirect an update/insert/delete to a different table?
Date: Sun, 20 Nov 2005 17:15:22 -0000
Message-ID: <ECOWS01MabrDy4i5oln0004dff7@smtp-out1.blueyonder.co.uk> (raw)
In-Reply-To: <20051120164234.GB2832@kaufbach.delug.de>
>Try it. [snipped example]
Ah. Basically, you set up the rule to assign every column, and if the update
doesn't redefine some columns, then it still works. I didn't understand that
you could get the rule to work generically like this.
I'll presume that the rule will need amending if the table column definition
later changes. (E.g. if I add 'stalk_length' to my apples and pears
tables)...
Thanks very much for your help.
Andy
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: andy@areyoulocal.co.uk, akretschmer@spamfence.net
Subject: Re: Is it possible to redirect an update/insert/delete to a different table?
In-Reply-To: <ECOWS01MabrDy4i5oln0004dff7@smtp-out1.blueyonder.co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox