Re: system table storing sequence attributes - Mailing list pgsql-sql

From Milen A. Radev
Subject Re: system table storing sequence attributes
Date
Msg-id 4652F7AB.9040502@radev.net
Whole thread Raw
In response to Re: system table storing sequence attributes  ("Sabin Coanda" <sabin.coanda@deuromedia.ro>)
List pgsql-sql
Sabin Coanda написа:
> ""Marcin Stкpnicki"" <mstepnicki@gmail.com> wrote in message 
> news:pan.2007.05.22.12.41.38.862364@gmail.com...
> ...
>> I think that you either misunderstood this statement or try to break your
>> application in a nasty way ;). Please tell us more about your problem
>> and/or what do you want to achive, because sequences behave this way for a
>> reason (concurrency issues). Perhaps there is another solution.
> 
> I have a table with a serial primary key aoto generated by a sequence. I 
> add/remove records. At a moment I'd like to know what is the current value 
> of the sequence. I don't wish to know this in the same session where I 
> add/remove records.

Why do you need to know that? I can't think of any reason.

[...]


-- 
Milen A. Radev



pgsql-sql by date:

Previous
From: "Sabin Coanda"
Date:
Subject: Re: system table storing sequence attributes
Next
From: John Summerfield
Date:
Subject: FATAL: cache lookup failed for function 1003