Re: PostgreSQL 9.6: view based on sequence - Mailing list pgsql-general

From Vincenzo Romano
Subject Re: PostgreSQL 9.6: view based on sequence
Date
Msg-id CAHjZ2x6DNC7rmpk5X36HDH2o1dtJJDM6OOJa3hwrsR5rK_bPpA@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL 9.6: view based on sequence  (Enrico Pirozzi <e.pirozzi@nbsgroup.it>)
Responses Re: PostgreSQL 9.6: view based on sequence  (Enrico Pirozzi <e.pirozzi@nbsgroup.it>)
List 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 by date:

Previous
From: Enrico Pirozzi
Date:
Subject: Re: PostgreSQL 9.6: view based on sequence
Next
From: Adrian Klaver
Date:
Subject: Re: PGSQL 10, many Random named DB