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
