Re: Copy entire row on elete - Mailing list pgsql-general

From Josué Maldonado
Subject Re: Copy entire row on elete
Date
Msg-id 409AB250.7030606@lamundial.hn
Whole thread Raw
In response to Re: Copy entire row on elete  (Mike Nolan <nolan@gw.tssi.com>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: Mike Nolan
Date:
Subject: Re: Copy entire row on elete
Next
From: Alvaro Herrera
Date:
Subject: Re: regexp replace?