Copy entire row on elete - Mailing list pgsql-general

From Josué Maldonado
Subject Copy entire row on elete
Date
Msg-id 409AA641.3020506@lamundial.hn
Whole thread Raw
Responses Re: Copy entire row on elete  (Mike Nolan <nolan@gw.tssi.com>)
List 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 by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: CHECK constraints and optimizations
Next
From: CSN
Date:
Subject: regexp replace?