Copy entire row on elete

From: Josué Maldonado <josue(at)lamundial(dot)hn>
To: pgsql-general(at)postgresql(dot)org
Subject: Copy entire row on elete
Date: 2004-05-06 20:55:29
Message-ID: 409AA641.3020506@lamundial.hn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message CSN 2004-05-06 20:59:16 regexp replace?
Previous Message Martijn van Oosterhout 2004-05-06 20:45:07 Re: CHECK constraints and optimizations