Thread: Copy entire row on elete

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.

> 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:

If you have a unique key you could do the following:

INSERT into C select * from old_table where key = OLD.key.
--
Mike Nolan

El 06/05/2004 3:45 PM, Mike Nolan en su mensaje escribio:

>>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:
>
>
> If you have a unique key you could do the following:
>
> INSERT into C select * from old_table where key = OLD.key.
> --
> Mike Nolan
>

Yes, that one worked fine, thanks.


--
Sinceramente,
Josué Maldonado.