Postgres Pro
Downloads
Home   >   mailing lists

Re: trouble with the automatic indexes on CREATE TABLE - Mailing list pgsql-general

From Tom Lane
Subject Re: trouble with the automatic indexes on CREATE TABLE
Date
Msg-id 14312.989966836@sss.pgh.pa.us
Whole thread Raw
In response to trouble with the automatic indexes on CREATE TABLE  (Bill McGonigle <mcgonigle@medicalmedia.com>)
Responses Re: trouble with the automatic indexes on CREATE TABLE  (Bill McGonigle <mcgonigle@medicalmedia.com>)
List pgsql-general
Tree view 
Bill McGonigle <mcgonigle@medicalmedia.com> writes:
> CREATE TABLE Delivery_Methods (
>          delivery_method_id INTEGER NOT NULL UNIQUE,
>          delivery_method VARCHAR(50) NOT NULL UNIQUE
> );

If you want to use names like that, you'd be well advised to increase
NAMEDATALEN.  See the archives.

            regards, tom lane

pgsql-general by date:

Previous
From: Bill McGonigle
Date:
Subject: trouble with the automatic indexes on CREATE TABLE
Next
From: "Albertson, Chris"
Date:
Subject: RE: Performance aggregates