From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | domain check constraint syntax problem for 7.4 |
Date: | 2003-01-26 05:09:21 |
Message-ID: | 20030126050921.GA12231@wolff.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
I am trying to create a domain with more than one check constraint and
I am getting an error that I don't think is correct according to the
documentation. I am not sure if this is a limitation of a partially
implemented feature or a bug that has so far been overlooked.
For example:
area=# create domain test6 as int constraint ack check(value<4);
CREATE DOMAIN
area=# create domain test7 as int constraint ack check(value<4),
area-# constraint ack1 check(value>0);
ERROR: parser: syntax error at or near "," at character 57
area=# create domain test7 as int check(value<4), check(value>0);
ERROR: parser: syntax error at or near "," at character 42
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-01-26 05:11:00 | Re: Can we revisit the thought of PostgreSQL 7.2.4? |
Previous Message | Rod Taylor | 2003-01-26 05:01:04 | Re: domain check constraint syntax problem for 7.4 |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2003-01-26 05:17:30 | Re: domain check constraint syntax problem for 7.4 |
Previous Message | Rod Taylor | 2003-01-26 05:01:04 | Re: domain check constraint syntax problem for 7.4 |