I've got tables: account & client, creating a client must automatically
create the corresponding account that'll be a foreign key into client.
AFAI read, I must DEFERRABLE INITIALLY DEFERRED the foreign key constraint
But can I do all this into only one transaction (writing account's row
before client's), or am I obliged to have 2 distinct transactions?
"Wish not to seem, but to be, the best."
pgsql-novice by date
|Next:||From: Andreas Kretschmer||Date: 2009-12-10 19:34:26|
|Subject: Re: one or 2 transactions?|
|Previous:||From: Brian Modra||Date: 2009-12-05 13:38:43|
|Subject: Re: Is autovaccum lazy?|