Re: Notices when creating tables

[Chris Travers <..hidden..>]

On Wed, Jun 15, 2011 at 8:49 PM, Luke <..hidden..> wrote:
> On Wed, 15 Jun 2011, Chris Travers wrote:
>
>> On Wed, Jun 15, 2011 at 6:56 PM, Luke <..hidden..>
>> wrote:
>>>
>>> (1.3 installation)
>>>
>>> Not being a PostGreSQL expert, should I be concerned at the rather huge
>>> number of these notices during installation?
>>>
>>> NOTICE:  CREATE TABLE will create implicit sequence "entity_id_seq" for
>>> serial column "entity.id"
>>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> "entity_pkey" for table "entity"
>>> NOTICE:  CREATE TABLE / UNIQUE will create implicit index "entity_id_key"
>>> for table "entity"
>>
>> Warnings are worth worrying about, these notices are not.  Pg however
>> tends to be fairly verbose about what goes on with DDL.....  Anytime
>> anything beyond what is explicitly asked for is done. we get these.
>> This means on every primary key, and every serial type.
>
> Is there any value in the end user of the script seeing them, or all the
> "CREATED (TABLE|FUNCTION|TRIGGER|...)" etc. messages?  Perhaps if it was
> interactive, but it's intended to be automated.
> For my own testing, I have grepped these notices and those action result
> items out of existence, and I could add that to the script to suppress these
> if they are not helpful.  Errors and warnings and such would still appear of
> course.

Sounds good.  I don't see a lot of value in generally showing these
but if there is concern about what's actually going on, I like to
watch notices sometimes.I suspect most users would prefer not to see
notices though.

Best Wishes,
Chris Travers