> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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
