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
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

In response to

Responses

Browse pgsql-hackers by date

  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"?

Browse pgsql-patches by date

  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