Re: PostgreSQL 9.6: view based on sequence

Поиск
Список
Период
Сортировка
От Vincenzo Romano
Тема Re: PostgreSQL 9.6: view based on sequence
Дата
Msg-id CAHjZ2x6DNC7rmpk5X36HDH2o1dtJJDM6OOJa3hwrsR5rK_bPpA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL 9.6: view based on sequence  (Enrico Pirozzi <e.pirozzi@nbsgroup.it>)
Ответы Re: PostgreSQL 9.6: view based on sequence  (Enrico Pirozzi <e.pirozzi@nbsgroup.it>)
Список pgsql-general
2018-01-24 13:10 GMT+01:00 Enrico Pirozzi <e.pirozzi@nbsgroup.it>:
> it's just to know why postgresql does not return a warning.
>
>
>
> Il 24/01/2018 13:06, Vincenzo Romano ha scritto:
>>
>> I haven't any v9 any more in my deployments. Sorry.
>>
>> What is the objective of that view?
>> If it's to hide the nextval() function, then the solution can be
>> similar to mine.
>> If it's to access the sequence metainfo, then maybe it'd be better to
>> explore the pg_catalog schema.
>
>
> --
> Enrico Pirozzi
> e.pirozzi@nbsgroup.it
>

Those queries are all legal. No warning is due.

-- 
Vincenzo Romano - NotOrAnd.IT
Information Technologies
--
NON QVIETIS MARIBVS NAVTA PERITVS


В списке pgsql-general по дате отправления:

Предыдущее
От: Enrico Pirozzi
Дата:
Сообщение: Re: PostgreSQL 9.6: view based on sequence
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: PGSQL 10, many Random named DB