Can anyones suggest some readings about
implementing
sequences w/o holes ?
thanx in advance.
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,
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
I'm new to PostgreSQL and I'm a litle
confused.
I have 2 questions about using user_write_lock
functions:
1. if a user set a write lock and then, for some
reason (bad connections, app chashes, etc), disconect from server without releasing, what happened with the lock ? It will be
still
h
