From: | Asko Seeba <asko(dot)seeba(at)gmail(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Bugreport: erroneous code generated for domain |
Date: | 2005-05-03 13:06:10 |
Message-ID: | 7c55566b05050306067c755998@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2005-05-04 08:08:08 | Re: Bugreport: erroneous code generated for domain |
Previous Message | Fabio Tavares Vieira | 2005-04-28 18:42:08 | Problems when execute pgadmin3 |