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

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

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: 7.2 or 7.4 for critical data?
Next
From: Josué Maldonado
Date:
Subject: Re: Copy entire row on elete