From: | Dario Besseghini <besseghi(at)Di(dot)Unipi(dot)IT> |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Subject: | CREATE TABLE ... CONSTRAINT |
Date: | 1998-08-17 14:59:30 |
Message-ID: | 199808171459.QAA11604@thorin.di.unipi.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all
I have been using postgreSQL for a while now and it is doing the job
I want it to. Thank you to all pgsql-hackers for their good job.
I am running a vanilla 6.3.2 installed from
postgresql-{,clients-,devel-,data-}6.3.2-4.rpm. Some of the problems
of taht distribution stem from the rpm specfile (for instance, a
world-writable and world-readable pg_pwd !!) and are not interesting
for this list.
However, there is one thing which I find annoying:
testdata=> CREATE TABLE test ( number int check ( number > 3 ) );
works fine, but the table is dumped with a different syntax:
CREATE TABLE test (number int4) CONSTRAINT test_number CHECK number > 3;
which is not accepted back:
testdata=> CREATE TABLE test (number int4) CONSTRAINT test_number CHECK number > 3;
ERROR: parser: parse error at or near "constraint"
Now, the second syntax is standard SQL and the parser should
recognize it, but in any case at least pg_dump compliance should be
aimed at.
Bye
Dario
--
######################################################################
# Dario Besseghini, system manager,
# Department of Computer Science, University of Pisa
# http://www.di.unipi.it/~besseghi
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 1998-08-17 18:15:13 | What does this error mean? |
Previous Message | Jackson, DeJuan | 1998-08-17 14:58:48 | RE: [GENERAL] getting the currval of a sequence |