Okay, all clear.
Thanx a lot.
- Original Message -
From: "Tino Wildenhain" <[EMAIL PROTECTED]>
To: "Marian Naghen" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, December 19, 2005 7:50 AM
Subject: Re: [GENERAL] sequences in transaction blocks
> Am Montag,
Am Montag, den 19.12.2005, 09:39 + schrieb Marian Naghen:
> I want to insert records inside a transaction block (BEGIN -
> COMMIT/ROLLBACK). If the transaction fails,
> the sequence do not rollback and retain the new value.
>
> This is the default behavior of sequences ?
Yes it is (its the
am 19.12.2005, um 9:39:11 - mailte Marian Naghen folgendes:
> I want to insert records inside a transaction block (BEGIN -
> COMMIT/ROLLBACK). If the transaction fails,
> the sequence do not rollback and retain the new value.
>
> This is the default behavior of sequences ?
Yes.
HTH, An
I want to insert records inside a transaction block
(BEGIN - COMMIT/ROLLBACK). If the transaction fails,
the sequence do not rollback and retain the new
value.
This is the default behavior of sequences ?
I use the following table:
CREATE TABLE proceduri( procedura_id
int4 NOT NUL
On Tue, Jun 05, 2001 at 10:33:08PM -0500, Erik Pearson wrote:
> One last followup question -- what's MVCC?
http://www.postgresql.org/idocs/index.php?mvcc.html
Cheers,
Neil
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http
On Tue, 5 Jun 2001, Erik Pearson wrote:
> I searched through mailing list archives but was unable to find full
> coverage of this question -- my apologies if this is a reposted question.
>
> As in the FAQ, I am trying to retrieve the value of a sequence value from a
> newly inserted row. So, fi
On Tue, Jun 05, 2001 at 09:22:43PM -0500, Erik Pearson wrote:
> I searched through mailing list archives but was unable to find full
> coverage of this question -- my apologies if this is a reposted question.
>
> As in the FAQ, I am trying to retrieve the value of a sequence value from a
> newly
I searched through mailing list archives but was unable to find full
coverage of this question -- my apologies if this is a reposted question.
As in the FAQ, I am trying to retrieve the value of a sequence value from a
newly inserted row. So, first I call something like:
insert into foobar
On Mon, Dec 04, 2000 at 05:56:04PM -0500, Camm Maguire wrote:
> Greetings! I've run into this too, and it appears to me not to roll
> back either. A pity, as it forced us to make a separate table to hold
> the last sequence value and update the table in a trigger.
This is a dangerous thing if y
Greetings! I've run into this too, and it appears to me not to roll
back either. A pity, as it forced us to make a separate table to hold
the last sequence value and update the table in a trigger.
Take care,
igor <[EMAIL PROTECTED]> writes:
> Hi,
>
> Help me please to understand such a thing
10 matches
Mail list logo
