On Tue, 1 Mar 2005 17:48:44 +0200, Vitaly Belman <[EMAIL PROTECTED]> wrote:
>
> CREATE TABLE functions.temp1
> (
> id1 int4 NOT NULL,
> id2 int4,
> CONSTRAINT pk_temp1 PRIMARY KEY (id1),
> CONSTRAINT temp2_id2
I tried looking into your solution.. However, the "DEFERRABLE
INITIALLY DEFERRED" doesn't seem to act as I expect it to. I made two
sample tables:
CREATE TABLE functions.temp1
(
id1 int4 NOT NULL,
id2 int4,
CONS
On Sat, 26 Feb 2005 16:47:38 +0200, Vitaly Belman <[EMAIL PROTECTED]> wrote:
> I am allowing my users to delete data from certain tables. However, to
> be able to do a rollback of user changes, I decided to create another
> "backup" schema that most data tables will copy data to, upon delete.
>
>
I am allowing my users to delete data from certain tables. However, to
be able to do a rollback of user changes, I decided to create another
"backup" schema that most data tables will copy data to, upon delete.
So basically what I have is:
public schema, in which there are two tables, A and B.
ba
