Pgadmin - Bugreport: erroneous code generated for domain

Author

Bugreport: erroneous code generated for domain

Asko Seeba

2005-05-03, 9:23 am

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Dave Page

2005-05-04, 3:25 am

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Asko Seeba
> Sent: 03 May 2005 14:06
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Bugreport: erroneous code
> generated for domain
>
> Hi,

Hello,

> 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.

I cannot reproduce this in the latest dev code - any chance you can
compile from source (http://developer.pgadmin.org/snapshots/src/,
http://www.pgadmin.org/download.php#source) and try it again please?

Regards, Dave

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Sponsored Links