| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jim Beckstrom <jrbeckstrom(at)sbcglobal(dot)net> |
| Cc: | Michael Fuhr <mike(at)fuhr(dot)org>, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: create table with table constraints |
| Date: | 2005-12-15 22:35:57 |
| Message-ID: | 17703.1134686157@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Jim Beckstrom <jrbeckstrom(at)sbcglobal(dot)net> writes:
> Error: Unable to perform query: CREATE TABLE client( lastname CHAR(20) DEFAULT ' ', etc.,CONSTRAINT program (program1, intakedate, ssnbr))ERROR: parser: parse error at or near "("
You should probably try testing on something newer than 7.2 ;-).
In 8.0 and up I get a pretty clear pointer to the problem:
psql:bogus.sql:90: ERROR: syntax error at or near "(" at character 6692
psql:bogus.sql:90: LINE 86: CONSTRAINT clientru (casenbr),
psql:bogus.sql:90: ^
and in fact that constraint and the ones after it are missing the UNIQUE
keyword.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-12-15 22:49:15 | Re: create table with table constraints |
| Previous Message | Jim Beckstrom | 2005-12-15 22:21:29 | Re: create table with table constraints |