Okay, all clear.
Thanx a lot.
- Original Message -
From: Tino Wildenhain [EMAIL PROTECTED]
To: Marian Naghen [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Monday, December 19, 2005 7:50 AM
Subject: Re: [GENERAL] sequences in transaction blocks
Am Montag, den 19.12.2005
Can anyones suggest some readings about
implementing
sequences w/o holes ?
thanx in advance.
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 ?
Iuse the following table:
CREATE TABLE proceduri( procedura_id
int4 NOT NULL
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