From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | besseghi(at)Di(dot)Unipi(dot)IT (Dario Besseghini) |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] CREATE TABLE ... CONSTRAINT |
Date: | 1998-08-29 02:52:41 |
Message-ID: | 199808290252.WAA27473@candle.pha.pa.us |
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.
This is fixed. 6.4 beta is September 1. [ I ought to make this text a
macro.]
--
Bruce Momjian | 830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)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)
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-08-29 03:44:04 | Re: [INTERFACES] Re: [HACKERS] changes in 6.4 |
Previous Message | David C Lawrence | 1998-08-28 21:46:15 | cmsg newgroup comp.databases.postgresql.patches |