Search Postgresql Archives

Continue sequence

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

Which is the correct way to obtain a continue sequence without fail (hole/gap) for a composite-id ?

Example:

CREATE TABLE nf
(
number   INTERGER NOT NULL,
serie       VARCHAR(2) NOT NULL,
CONSTRAINT pky_nf PRIMARY KEY (number,serie)
)

number      serie
1               A
2               A
1               B
3               A
4               A
2               B

I think that I will need to use LOCK TABLE or SELECT FOR UPDATE, but in both cases if the client terminal shutdown suddenly the tuple/table stays locked on the server for a indeterminate time.

I did a test with the following commands using pgadmin III:

BEGIN;
LOCK TABLE nf IN EXCLUSIVE MODE;

I restarted my terminal and checked in another terminal that the LOCK condition was there. After 10 minutes, to unlock the table, I send a KILL command for the process that was locking the table/tuple.

Best regards,

Rogério Augusto Bassete - BRAZIL/SP


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux