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

Предыдущее
От: Pasi Eronen
Дата:
Сообщение: Re: BUG #17362: Error "could not find block containing chunk" when using index with icu collation on CentOS 7
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #17363: 14 regression: "could not identify a hash function for type record" in a nested record in sublink