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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-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 | Content-Type | Size |
---|---|---|
seqValueDisplay.patch | text/x-patch | 2.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | PFC | 2006-05-09 11:29:56 | Re: [HACKERS] Big IN() clauses etc : feature proposal |
Previous Message | Max Khon | 2006-05-09 11:19:24 | Re: semaphore usage "port based"? |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2006-05-09 11:50:38 | Re: Cleaning up multiply-defined-symbol warnings on OS X |
Previous Message | Peter Brant | 2006-05-09 08:57:58 | Re: pgstat: remove delayed destroy / pipe: socket |