[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Notices when creating tables



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