Re: wrong output in dump of rules with old values of row type columns
От
Tom Lane
Тема
Re: wrong output in dump of rules with old values of row type columns
Дата
Msg-id
2996293.1642000125@sss.pgh.pa.us
Ответ на
wrong output in dump of rules with old values of row type columns (Timur Khanjanov)
Список
Дерево обсуждения
wrong output in dump of rules with old values of row type columns Timur Khanjanov <intel@intrans.baku.az>
Re: wrong output in dump of rules with old values of row type columns Tom Lane <tgl@sss.pgh.pa.us>
Re: wrong output in dump of rules with old values of row type columns Timur Khanjanov <intel@intrans.baku.az>
Timur Khanjanov writes: > create table test(a int); > create table test_log(old test); > create rule del as on delete to test do insert into test_log values(old); As a workaround you could write it as create rule del as on delete to test do insert into test_log select old; which will reverse-list as ON DELETE TO test DO INSERT INTO test_log (old) SELECT old.*::test AS old Looks like we need to apply the same hack in VALUES lists. regards, tom lane
В списке pgsql-bugs по дате отправления
От: Pasi Eronen
Дата: