checking currval

Поиск
Список
Период
Сортировка
Искать

checking currval

От:
Jodi Kanter <jkanter@virginia.edu>
Дата:
I cannot view the currval because it is not set in the session yet. Is there a way to set it without having to increment the value?
Thanks
Jodi
--

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu


 

 

 

Re: checking currval

От:
Weiping He <laser@zhengmai.com.cn>
Дата:
select last_value from your_sequence;

Jodi Kanter wrote:

> I cannot view the currval because it is not set in the session yet. Is 
> there a way to set it without having to increment the value?
> Thanks
> Jodi



Re: checking currval

От:
Jodi Kanter <jkanter@virginia.edu>
Дата:
I tried that and it did not work. It won't be a problem in the code since it appears that we are always doing a nextval prior to currval, but I was just wondering about how to do it while in a psql session.

Weiping He wrote:
select last_value from your_sequence;

Jodi Kanter wrote:

I cannot view the currval because it is not set in the session yet. Is there a way to set it without having to increment the value?
Thanks
Jodi




---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

--

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu


 

 

 


Re: checking currval

От:
Bruno Wolff III <bruno@wolff.to>
Дата:
On Wed, Jun 18, 2003 at 09:55:51 -0400,
  Jodi Kanter  wrote:
> I cannot view the currval because it is not set in the session yet. Is 
> there a way to set it without having to increment the value?

What value do you expect to see and why do you want to see it?

Re: checking currval

От:
"scott.marlowe" <scott.marlowe@ihs.com>
Дата:
What flavor Postgresql are you running?  That works on both my 7.2.x boxes 
and my 7.3 boxes.  If you're running anything older than 7.2.x, you might 
wanna upgrade before asking for help, since folks tend to assume you're 
running at least 7.2 around here.

Note that this IS NOT TRANSACTION safe.  If two processes do this at the 
same time and operate on that number, you can have a race condition that 
will cause you problems.

Use the nextval,setval,currval functions for transaction safe sequence 
work.

On Wed, 18 Jun 2003, Jodi Kanter wrote:

> I tried that and it did not work. It won't be a problem in the code 
> since it appears that we are always doing a nextval prior to currval, 
> but I was just wondering about how to do it while in a psql session.
> 
> Weiping He wrote:
> 
> > select last_value from your_sequence;
> >
> > Jodi Kanter wrote:
> >
> >> I cannot view the currval because it is not set in the session yet. 
> >> Is there a way to set it without having to increment the value?
> >> Thanks
> >> Jodi
> >
> >
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 7: don't forget to increase your free space map settings
> 
> 
> 

FAQ