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

Поиск
Список
Период
Сортировка
От Andy Ballingall
Тема Is it possible to redirect an update/insert/delete to a different table?
Дата
Msg-id ECOWS06MsMkXWNcu9mt0001b868@smtp-out6.blueyonder.co.uk
обсуждение исходный текст
Ответы Re: Is it possible to redirect an update/insert/delete to a different table?  (Peter Eisentraut <peter_e@gmx.net>)
Re: Is it possible to redirect an update/insert/delete to a different table?  (Jaime Casanova <systemguards@gmail.com>)
Re: Is it possible to redirect an update/insert/delete to a different table?  ("JuanCri" <juancri@gmail.com>)
Список pgsql-sql
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Hello,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Is there a way that I can specify that a request to change to a particular table is redirected
insteadto a different table?</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I’ve looked through rules, and as far as I can make out, they are only useful for explicit actions.
I’mlooking for something that behaves as though it simply substitutes the table name for a different table name before
executingthe command, no matter what the command looks like.</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Thanks</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Andy Ballingall</span></font></div>

В списке pgsql-sql по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: DISTINCT ON
Следующее
От:
Дата:
Сообщение: Create Public Schema