Re: Support retrieving value from any sequence - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Support retrieving value from any sequence
Date
Msg-id 8739.1436893588@sss.pgh.pa.us
Whole thread Raw
In response to Re: Support retrieving value from any sequence  (Thom Brown <thom@linux.com>)
Responses Re: Support retrieving value from any sequence
List pgsql-hackers
Thom Brown <thom@linux.com> writes:
> On 14 July 2015 at 17:17, Robert Haas <robertmhaas@gmail.com> wrote:
>> Since it's trivial to define this function if you need it, I'm not
>> sure there's a reason to include it in core.

> It's not always possible to create functions on a system when access
> is restricted.  It may even be the case that procedural languages are
> prohibited, and plpgsql has been removed.

By that argument, *any* random function has to be in the core.

I really don't see what's wrong with "SELECT last_value FROM sequence",
especially since that has worked in every Postgres version since 6.x.
Anyone slightly worried about backwards compatibility wouldn't use
an equivalent function even if we did add one.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: WIP: Enhanced ALTER OPERATOR
Next
From: Adam Brightwell
Date:
Subject: Re: security labels on databases are bad for dump & restore