Bugreport: erroneous code generated for domain

Hi,

Up-to-date (2 May 2005) Debian Sid distribution version of pgAdmin III
(1.2.0, 10 Jan 2005).

I'm not sure if pgAdmin developers already know this, but just for the case.

I clicked on a domain on a PostgreSQL 7.4 database tree view, copied
and pasted the domain creation script into PostgreSQL 8.0 connected
pgsql text terminal client window and got error:

ERROR:  syntax error at or near "CONSTRAINT" at character 69
LINE 4:    CHECK CONSTRAINT blah_check CHECK ((VALUE)::text ~ '...

The script generated by pgAdmin is this:

CREATE DOMAIN public.blah AS varchar(32) NOT NULL  CHECK CONSTRAINT blah_check CHECK ((VALUE)::text ~ '^.*$'::text);

I removed the first "CHECK" manually from the script and it worked.

For formalities, following the guidelines from bug-reporting help:

Q: Is this behaviour expected? Have a look at the FAQs.
A: I hope no (and yes, looked at FAQ just for the case)

Q: Is this bug already reported? Check the known bugs.
A: I didn't find it (checked the known bugs).

Q: Are you running the latest version from the beta website? If not,
try the newest stuff.
A: Quite latest (the latest in debian sid): Help->About: Version 1.2.0
(Jan 10 2005). Looked at source installation guidelines -- looked like
too time consuming and skipped :)

Q: Ahh, so you've found a new one then?
A: Not 100% sure, but still wrote to not miss the opportunity ;)

--
Asko Seeba
GSM: +372 5105744, Skype: askoseeba