domain check constraint syntax problem for 7.4

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

Responses

Browse pgsql-hackers by date

  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

Browse pgsql-patches by date

  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