Hello:
I am getting the following errors. I am using 6.3.2 on linux Redhat 5.1

create table person (person_id int not null,
marital_status char(1),
unique(person_id));
NOTICE:  CREATE TABLE/UNIQUE will create implicit index
person_person_id_key for table person
CREATE
My comments: This notice looks ok.

create table longtablename (DATE_TIME_STAMP datetime not null,
UNIQUE (DATE_TIME_STAMP));
ERROR:  parser: unable to construct implicit index for table
longtablename; name too long
My comments: Here if the table name is long and the column name is long
Postgres has trouble with
the index name being too long.

ALTER TABLE longtablename ADD FOREIGN KEY (person_ID) REFERENCES
person(person_id);
NOTICE:  CREATE TABLE/FOREIGN KEY clause ignored; not yet implemented
ERROR:  ALTER TABLE/ADD CONSTRAINT not yet implemented
My comments: Here, since the table is empty, should this not be easy for
the postgres to alter the table??

ALTER TABLE person ADD
check (marital_status in ("T","F"))
;
ERROR:  parser: parse error at or near "in"
EOF
My comments: Here, since the table is empty, should this not be easy for
the postgres to alter the table??



Fri, 04 Sep 1998 17:33:43 -0500
Dev_Al <Dev_Al/houston_rd@peach.bmc.com>
Problems in create table ?? 6.3.2