Re: Notices when creating tables

[Chris Travers <..hidden..>]

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.

Best Wishes
Chris Travers