Re: trouble with the automatic indexes on CREATE TABLE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bill McGonigle <mcgonigle(at)medicalmedia(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: trouble with the automatic indexes on CREATE TABLE
Date: 2001-05-15 22:47:16
Message-ID: 14312.989966836@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bill McGonigle <mcgonigle(at)medicalmedia(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ryan Mahoney 2001-05-15 23:21:46 Re: SQL help...
Previous Message Nils Zonneveld 2001-05-15 22:26:03 Re: SELECT from a table in another database