Copy entire row on elete

Поиск
Список
Период
Сортировка
От Josué Maldonado
Тема Copy entire row on elete
Дата
Msg-id 409AA641.3020506@lamundial.hn
обсуждение исходный текст
Ответы Re: Copy entire row on elete
Список pgsql-general
Hello list,

I use triggers with plpgsql, now I have a situation I have to copy the
entire tuple of a table before it gets deleted to another table. I
wonder if is there a way to say:

insert into c select * from OLD;

But I got this error:

ERROR:  OLD used in query that is not in a rule

"No cambies la salud por la riqueza, ni la libertad por el poder."Any
idea how to get it done properly?, thanks in advance.


--
Sinceramente,
Josué Maldonado.


В списке pgsql-general по дате отправления: