Re: Bugreport: erroneous code generated for domain

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Asko Seeba
> Sent: 03 May 2005 14:06
> To: pgadmin-support(at)postgresql(dot)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