Bill McGonigle <[EMAIL PROTECTED]> 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.
When doing CREATE TABLE (piped in from a file with my table definitions) I'
m getting errors that I think are related to the automatic index creation
on my UNIQUE columns:
ERROR: Relation 'phone_number_types' does not exist
ERROR: Cannot create index: 'phone_number__phone_number__key' already