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?
Re: Is it possible to redirect an update/insert/delete to a different table? Re: Is it possible to redirect an update/insert/delete to a different table? |
Список | 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 по дате отправления: