Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dIBN4-0004sS-8g for pgadmin-hackers@arkaria.postgresql.org; Tue, 06 Jun 2017 10:05:54 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dIBN3-00055O-RK for pgadmin-hackers@arkaria.postgresql.org; Tue, 06 Jun 2017 10:05:53 +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_2) (envelope-from ) id 1dIBMp-0004gg-Do for pgadmin-hackers@postgresql.org; Tue, 06 Jun 2017 10:05:39 +0000 Received: from mail-wr0-x22b.google.com ([2a00:1450:400c:c0c::22b]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dIBMm-0006Qw-9Y for pgadmin-hackers@postgresql.org; Tue, 06 Jun 2017 10:05:38 +0000 Received: by mail-wr0-x22b.google.com with SMTP id q97so51734676wrb.2 for ; Tue, 06 Jun 2017 03:05:35 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:from:date:message-id:subject:to; bh=cJ5Q7CQ0brH40sbHGNDTxMCtfZb5LFpNqrmGWU1XFW8=; b=QEpqcgfTZ/mtujHb9D8ZwRIX2VMLL0e55vYzA5k4gSEqURgXdtT+Mg51iSM2f7uq5d RvQuRzT3Vb17PJMUygWyvd5/OxLtfyAlgom6i6JwslESPPMOV+CE9No/E5+6NCC/j+EK F5XpeHx6/e2ZLzxH+1sMdCeGuHz2aElOddGPscku5vJtfQ1eU7M90jdsbAitnvev6Npt zxdWK4aosO21ph7HunWyu5Wc4OoOWHfgtjnVsnFheO18vNmX4fBBvk2hV0tHiO7IaIIB LjNIitgDGWg8DVYz6JFlIaMM2iaNvUegULEYaKTNWepi5tlSjZ5aeY5GET2bsJKKGEyG +pFA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=cJ5Q7CQ0brH40sbHGNDTxMCtfZb5LFpNqrmGWU1XFW8=; b=IOAs99pgfdKchhkWG01RaA/rPqSwXPLrTiotkp+NQviENe5/w9KTmJJbsiNSfc4Ao4 QpJxN9xdW4JFSN82dtmBwWgqSCpzqz73Kd54Z1TFBZpKlt58Ukk1HKmDc+RbaBF65WvD YVwbEWsPNnQYY6zdSJl3XBVPWQ99MEPvgHMrKDb3F2ynLmlIqfgPbKaPcKgp2TXGpJgD ADdh9+vboOAftNSoBxzGkEyXwTQhAoYadTaCikx4lRoDBbaQU9jpmKpWYowD1ec8Tkj9 lbEY4v+Ypx15ldG68TxWF/YXjkevSfnQEkWJPF2qEVWa0uAwEJAEGCdXHcqgMduBdrww HG/g== X-Gm-Message-State: AODbwcAQMrlyOSACCxcNHVGXAomKqSOg9ezFSXVq02suf48IU0Uf83AD LNxmWrRfBgvgdDXpBeu/0YzAg/12eBlf X-Received: by 10.223.131.1 with SMTP id 1mr2473972wrd.123.1496743534952; Tue, 06 Jun 2017 03:05:34 -0700 (PDT) MIME-Version: 1.0 Received: by 10.28.19.138 with HTTP; Tue, 6 Jun 2017 03:05:04 -0700 (PDT) From: Surinder Kumar Date: Tue, 6 Jun 2017 15:35:04 +0530 Message-ID: Subject: [pgAdmin4][Patch][RM_2461]: Unable to drop defaut value from the column in table To: pgadmin-hackers Content-Type: multipart/mixed; boundary="94eb2c0d2054b979ce055147c264" X-Pg-Spam-Score: -1.9 (-) 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 --94eb2c0d2054b979ce055147c264 Content-Type: multipart/alternative; boundary="94eb2c0d2054b979bf055147c262" --94eb2c0d2054b979bf055147c262 Content-Type: text/plain; charset="UTF-8" Hi Add drop column syntax for dropping default value of a column if default value is kept empty. Please find attached patch and review. Thanks, Surinder --94eb2c0d2054b979bf055147c262 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi<= /div>

Add drop column syntax fo= r dropping default value of a column if default value is kept empty.
<= div class=3D"gmail_default" style=3D"font-size:small">
Please find attached patch and= review.

Thanks,
Surinder
--94eb2c0d2054b979bf055147c262-- --94eb2c0d2054b979ce055147c264 Content-Type: application/octet-stream; name="RM_2461.patch" Content-Disposition: attachment; filename="RM_2461.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_j3lebk900 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vw cy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90ZW1wbGF0ZXMv Y29sdW1uL3NxbC85LjJfcGx1cy91cGRhdGUuc3FsIGIvd2ViL3BnYWRtaW4v YnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVt YXMvdGFibGVzL3RlbXBsYXRlcy9jb2x1bW4vc3FsLzkuMl9wbHVzL3VwZGF0 ZS5zcWwKaW5kZXggZmNmZDNjMS4uNzcyOGEyYSAxMDA2NDQKLS0tIGEvd2Vi L3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJh c2VzL3NjaGVtYXMvdGFibGVzL3RlbXBsYXRlcy9jb2x1bW4vc3FsLzkuMl9w bHVzL3VwZGF0ZS5zcWwKKysrIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2 ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3Rl bXBsYXRlcy9jb2x1bW4vc3FsLzkuMl9wbHVzL3VwZGF0ZS5zcWwKQEAgLTIw LDYgKzIwLDEyIEBAIEFMVEVSIFRBQkxFIHt7Y29ubnxxdElkZW50KGRhdGEu c2NoZW1hLCBkYXRhLnRhYmxlKX19CiAgICAgQUxURVIgQ09MVU1OIHslIGlm IGRhdGEubmFtZSAlfXt7Y29ubnxxdFR5cGVJZGVudChkYXRhLm5hbWUpfX17 JSBlbHNlICV9e3tjb25ufHF0VHlwZUlkZW50KG9fZGF0YS5uYW1lKX19eyUg ZW5kaWYgJX0gU0VUIERFRkFVTFQge3tkYXRhLmRlZnZhbH19OwogCiB7JSBl bmRpZiAlfQoreyMjIyAgRHJvcCBjb2x1bW4gZGVmYXVsdCB2YWx1ZSAjIyN9 Cit7JSBpZiBkYXRhLmRlZnZhbCBpcyBkZWZpbmVkIGFuZCBkYXRhLmRlZnZh bCA9PSAnJyBhbmQgZGF0YS5kZWZ2YWwgIT0gb19kYXRhLmRlZnZhbCAlfQor QUxURVIgVEFCTEUge3tjb25ufHF0SWRlbnQoZGF0YS5zY2hlbWEsIGRhdGEu dGFibGUpfX0KKyAgICBBTFRFUiBDT0xVTU4geyUgaWYgZGF0YS5uYW1lICV9 e3tjb25ufHF0VHlwZUlkZW50KGRhdGEubmFtZSl9fXslIGVsc2UgJX17e2Nv bm58cXRUeXBlSWRlbnQob19kYXRhLm5hbWUpfX17JSBlbmRpZiAlfSBEUk9Q IERFRkFVTFQ7CisKK3slIGVuZGlmICV9CiB7IyMjICBBbHRlciBjb2x1bW4g bm90IG51bGwgdmFsdWUgIyMjfQogeyUgaWYgJ2F0dG5vdG51bGwnIGluIGRh dGEgYW5kIGRhdGEuYXR0bm90bnVsbCAhPSBvX2RhdGEuYXR0bm90bnVsbCAl fQogQUxURVIgVEFCTEUge3tjb25ufHF0SWRlbnQoZGF0YS5zY2hlbWEsIGRh dGEudGFibGUpfX0KZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIv c2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxl cy90ZW1wbGF0ZXMvY29sdW1uL3NxbC9kZWZhdWx0L3VwZGF0ZS5zcWwgYi93 ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRh YmFzZXMvc2NoZW1hcy90YWJsZXMvdGVtcGxhdGVzL2NvbHVtbi9zcWwvZGVm YXVsdC91cGRhdGUuc3FsCmluZGV4IGIwNDUxMzEuLjVmNDg2NzIgMTAwNjQ0 Ci0tLSBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2 ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90ZW1wbGF0ZXMvY29sdW1u L3NxbC9kZWZhdWx0L3VwZGF0ZS5zcWwKKysrIGIvd2ViL3BnYWRtaW4vYnJv d3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMv dGFibGVzL3RlbXBsYXRlcy9jb2x1bW4vc3FsL2RlZmF1bHQvdXBkYXRlLnNx bApAQCAtMjAsNiArMjAsMTIgQEAgQUxURVIgVEFCTEUge3tjb25ufHF0SWRl bnQoZGF0YS5zY2hlbWEsIGRhdGEudGFibGUpfX0KICAgICBBTFRFUiBDT0xV TU4geyUgaWYgZGF0YS5uYW1lICV9e3tjb25ufHF0VHlwZUlkZW50KGRhdGEu bmFtZSl9fXslIGVsc2UgJX17e2Nvbm58cXRUeXBlSWRlbnQob19kYXRhLm5h bWUpfX17JSBlbmRpZiAlfSBTRVQgREVGQVVMVCB7e2RhdGEuZGVmdmFsfX07 CiAKIHslIGVuZGlmICV9Cit7IyMjICBEcm9wIGNvbHVtbiBkZWZhdWx0IHZh bHVlICMjI30KK3slIGlmIGRhdGEuZGVmdmFsIGlzIGRlZmluZWQgYW5kIGRh dGEuZGVmdmFsID09ICcnIGFuZCBkYXRhLmRlZnZhbCAhPSBvX2RhdGEuZGVm dmFsICV9CitBTFRFUiBUQUJMRSB7e2Nvbm58cXRJZGVudChkYXRhLnNjaGVt YSwgZGF0YS50YWJsZSl9fQorICAgIEFMVEVSIENPTFVNTiB7JSBpZiBkYXRh Lm5hbWUgJX17e2Nvbm58cXRUeXBlSWRlbnQoZGF0YS5uYW1lKX19eyUgZWxz ZSAlfXt7Y29ubnxxdFR5cGVJZGVudChvX2RhdGEubmFtZSl9fXslIGVuZGlm ICV9IERST1AgREVGQVVMVDsKKworeyUgZW5kaWYgJX0KIHsjIyMgIEFsdGVy IGNvbHVtbiBub3QgbnVsbCB2YWx1ZSAjIyN9CiB7JSBpZiAnYXR0bm90bnVs bCcgaW4gZGF0YSBhbmQgZGF0YS5hdHRub3RudWxsICE9IG9fZGF0YS5hdHRu b3RudWxsICV9CiBBTFRFUiBUQUJMRSB7e2Nvbm58cXRJZGVudChkYXRhLnNj aGVtYSwgZGF0YS50YWJsZSl9fQo= --94eb2c0d2054b979ce055147c264 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers --94eb2c0d2054b979ce055147c264--