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 <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 по дате отправления
FAQ