Skip site navigation (1) Skip section navigation (2)

Re: current version: Patch - Have psql show current values

From: Dhanaraj M <Dhanaraj(dot)M(at)Sun(dot)COM>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: current version: Patch - Have psql show current values
Date: 2006-05-09 11:28:09
Message-ID: 44607CC9.1020900@sun.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Bruce Momjian wrote:

>I am thinking we just add another column to the \d display for sequences
>showing the current value.
>
>---------------------------------------------------------------------------
>
>  
>
As suggested in the previous mails, I tried to use the following to 
display the seq. value.
select last_value from <seq>.

However, it was not possible to display the seq. value using this.
Hence, I made a small change in the currval() function, so that it 
retrieves the last_value
even if the the value is not cached.

I hope this patch will be more suitable for this issue. Pl. look at the 
patch.

Thanks
Dhanaraj


Attachment: seqValueDisplay.patch
Description: text/x-patch (2.1 KB)

In response to

Responses

pgsql-hackers by date

Next:From: PFCDate: 2006-05-09 11:29:56
Subject: Re: [HACKERS] Big IN() clauses etc : feature proposal
Previous:From: Max KhonDate: 2006-05-09 11:19:24
Subject: Re: semaphore usage "port based"?

pgsql-patches by date

Next:From: Peter EisentrautDate: 2006-05-09 11:50:38
Subject: Re: Cleaning up multiply-defined-symbol warnings on OS X
Previous:From: Peter BrantDate: 2006-05-09 08:57:58
Subject: Re: pgstat: remove delayed destroy / pipe: socket

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group