Re: Support retrieving value from any sequence

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Support retrieving value from any sequence
Дата
Msg-id 8739.1436893588@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Support retrieving value from any sequence  (Thom Brown <thom@linux.com>)
Ответы Re: Support retrieving value from any sequence  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Список 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 по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: WIP: Enhanced ALTER OPERATOR
Следующее
От: Adam Brightwell
Дата:
Сообщение: Re: security labels on databases are bad for dump & restore