CREATE TABLE ... CONSTRAINT

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.

This is fixed. 6.4 beta is September 1. [ I ought to make this text a
macro.]

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)