Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aJLEl-0004Nu-0P for pgadmin-hackers@arkaria.postgresql.org; Wed, 13 Jan 2016 13:13:19 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aJLEk-00086a-J5 for pgadmin-hackers@arkaria.postgresql.org; Wed, 13 Jan 2016 13:13:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aJLEj-00085G-Tz for pgadmin-hackers@postgresql.org; Wed, 13 Jan 2016 13:13:17 +0000 Received: from mail-lb0-x233.google.com ([2a00:1450:4010:c04::233]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1aJLEh-0005Le-12 for pgadmin-hackers@postgresql.org; Wed, 13 Jan 2016 13:13:17 +0000 Received: by mail-lb0-x233.google.com with SMTP id bc4so289489189lbc.2 for ; Wed, 13 Jan 2016 05:13:14 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:date:message-id:subject:from:to:content-type; bh=Ax2hUk1CyLkUQ1wM4xJ3c/m39BcRu8YsbgIe3MBwQEc=; b=bhZuahe74uRaoujUWO8TLwdxad0TMqDM81aru8AVhaGBVa5+jJHM+Ko9LJbbiF2pae tsG4MU+kJRPNgUT/HN3GARKZI0Ag4FtOJcR8ZQNxSLikX+WtTtex+AtkP593jv3SHl/X SRaVm/ItS6C2nljnOUKk9AfH9p+QzCJbAi6IL9hNFxVaHmqXsv0mCHiWvAR6ZkAy/Y21 7nt5SGkBIcphAvEaUS/eM+FYel9Dfq8oAW6m9ahAKRrxi8gRGo3sb6iype8Asr61WFfZ HOJJqOloWCwGXywRnLMO88Mmf3omo0jBzKzDIlEi5dZOB+vj4uWDkX4Qn7my3b1ZZZO9 GRNA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:date:message-id:subject:from:to :content-type; bh=Ax2hUk1CyLkUQ1wM4xJ3c/m39BcRu8YsbgIe3MBwQEc=; b=kUCWvleRha45XwgTutcBRdVrYv3282PMLEIdn5rcamRJQn/drmskgh9vj2lvhWzGY5 xlcgGLSiM4zv2ORsK6+cHdXWOwKpb+2Y6Air1hwtbebpsiM6ucFk5b5ZrFCpG/Vh4Mg6 LUvyXoBSjkb5h7Qqx0dAH9E5jAEoQpojMlyb55iMjned5TEvLuhjKCmJsizJtNm4PnOQ +xsSWrY80zT5QdWbYwCfFsGb+zCMRgi6dTUiBh/RVx3WOcUqSEcneQHPsqHAKGs5j/CY YDxkAhSQTY0OxalclPyDwrB64lfTNevHtin+b6J6aCw2xRsatv1W4BSsB+kqY3KSXl5g gh+Q== X-Gm-Message-State: ALoCoQnMvuOTfl/vQUY/a+GZHxOsv4nRO+43La2nUPYD4/6sO/UiX/u0pP+2XXYB+HMbIJXKvV6iQVrkvK/UM3QfhRDmj9oWs9BmCB7ZLJ4JKQYzT7eKpi4= MIME-Version: 1.0 X-Received: by 10.112.131.105 with SMTP id ol9mr51483098lbb.45.1452690793322; Wed, 13 Jan 2016 05:13:13 -0800 (PST) Received: by 10.25.42.138 with HTTP; Wed, 13 Jan 2016 05:13:13 -0800 (PST) Date: Wed, 13 Jan 2016 18:43:13 +0530 Message-ID: Subject: Unable to update Domain properly From: Khushboo Vashi To: pgadmin-hackers Content-Type: multipart/alternative; boundary=047d7b3a88d4b46e94052936ee18 X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgadmin-hackers Precedence: bulk Sender: pgadmin-hackers-owner@postgresql.org --047d7b3a88d4b46e94052936ee18 Content-Type: text/plain; charset=UTF-8 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 --047d7b3a88d4b46e94052936ee18 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,

While updating Domain from pgAd= min-III=C2=A0 , I observed an error.

When I update only D= omain name it is working properly, but when I try to update multiple fields= , I get an error.

For example,=C2=A0 if I try to rename D= omain TestDomain to TestDomain1 and also modifies one or more= fields (except comment). I get below error.


ERROR:= =C2=A0 type "pem.TestDomain" does not exist

Generated S= QL:

ALTER DOMAIN pem."TestDomain"
=C2=A0 RENAME TO = "TestDomain1";
ALTER DOMAIN pem."TestDomain"
=C2= =A0 DROP NOT NULL;


Thanks,
K= hushboo
--047d7b3a88d4b46e94052936ee18--