Re: Unable to update Domain properly

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(dot)vashi(at)enterprisedb(dot)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
>