Search Postgresql Archives

Re: How to get the value in the lastvalue field

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

 



 Hi
thanks for the replies. The situation is as follows. We get backups from the production server and update the local database in the local server but each time when we restore the database backup the sequence values are not getting updated properly. So what i thought was to write a function which will check the last value of the row in the table and compare it with the lastvalue of the sequnce and if it is not proper then update the lastvalue of the sequence to a proper value.
 
I Hope that i have explained the situation properly. If you have any other suggestion it will be greatly helpful as we are new to postgres and might be doing something wrong when restoring the database.
 
Regards
venki
 
-------Original Message-------
 
Date: 10/26/05 18:24:48
To: Venki
Subject: Re: [GENERAL] How to get the value in the lastvalue field
 
You can select it from the sequence's associated relation as from any
table... try:
 
select * from sequence_name;
 
However, be aware that what you see there is the situation only in your
transaction, and it is very possible that other transactions will use
higher values concurrently. So it really depends on what you want to do
if it is actually safe to do it this way...
 
Cheers,
Csaba.
 
 
On Wed, 2005-10-26 at 14:23, Venki wrote:
>  Hi,
> Can anyone in the list tell me how to get the value in the lastvalue
> field of a sequence. I tried
>
> select currval('field_seq');
>
> but got an error message
>
> ERROR:  currval of sequence "field_seq" is not yet defined in this
> session.
>
> I think currval will work only after an insert. I don't want to use
> nextval as this increases the lastvalue value.
>
>
>
> Thanks in advance
>
> Kind Regards,
> Venki
>
>
>
>
>
>
 
 

[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