Hi, Please find the attached patch file for fix of above issue.
*Issue:- * Below generated SQL was wrong. ALTER DOMAIN pem."TestDomain" RENAME TO "TestDomain1"; ALTER DOMAIN pem."TestDomain" DROP NOT NULL; In second query, domain name is wrong as domain name was updated by the first query. *Resolution:-* Now when any properties got changed along with domain name then correct SQL will be generated. Correct query should be as below. ALTER DOMAIN pem."TestDomain" RENAME TO "TestDomain1"; ALTER DOMAIN pem."TestDomain1" DROP NOT NULL; Please review it and do let us know for any comment. Thanks, Neel Patel On Wed, Jan 13, 2016 at 6:43 PM, Khushboo Vashi < khushboo.va...@enterprisedb.com> wrote: > Hi, > > While updating Domain from pgAdmin-III , I observed an error. > > When I update only Domain name it is working properly, but when I try to > update multiple fields, I get an error. > > For example, if I try to rename Domain *TestDomain* to *TestDomain1* and > also modifies one or more fields (except comment). I get below error. > > > ERROR: type "pem.TestDomain" does not exist > > *Generated SQL:* > > ALTER DOMAIN pem."TestDomain" > RENAME TO "TestDomain1"; > ALTER DOMAIN pem."TestDomain" > DROP NOT NULL; > > > Thanks, > Khushboo >
domain_fix.patch
Description: Binary data
-- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
