Re: trouble with the automatic indexes on CREATE TABLE

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