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
Список pgsql-bugs
Timur Khanjanov <intel@intrans.baku.az> 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 по дате отправления: