Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iQYlO-0003GW-Ua for pgadmin-hackers@arkaria.postgresql.org; Fri, 01 Nov 2019 15:22:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iQYlN-00007P-M2 for pgadmin-hackers@arkaria.postgresql.org; Fri, 01 Nov 2019 15:22:57 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iQYlN-0008Sj-AB for pgadmin-hackers@lists.postgresql.org; Fri, 01 Nov 2019 15:22:57 +0000 Received: from mail-wr1-x444.google.com ([2a00:1450:4864:20::444]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1iQYlK-00081e-JC for pgadmin-hackers@postgresql.org; Fri, 01 Nov 2019 15:22:56 +0000 Received: by mail-wr1-x444.google.com with SMTP id q13so9987408wrs.12 for ; Fri, 01 Nov 2019 08:22:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pgadmin.org; s=google; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=QSzEC8J/jic/yUzgiJT/ExfnYj3bcKEvryJh9PYcwJg=; b=WyltbARWsp5qr3PpdaF+B2+TOtrcjiNmSXPd6yMbrJNUSgJ52HPyYtk1BozYMV9q1Q 7A0P0THzsmyvqKaTYYvriNbXBV8ilRC41jnpnhv4A2p3+RqQlpejaMFuEUhBCH7Peeqo 1q8vUPk3iQ5Ld42vz7EueWT48e7GQERlaZwTkknliK0TK3987xMUuDRpJ29X0KN49yLa gOXMTq3RKWMxF59TbOoOJsUKaqfGXNTSFKW6EEBIYKjZJYZTsUuU9QNXa4RJhEEQpvPF /8uw+KatE/CdJMXhnsXgOYsG7/KQ7+Pi9yTU3LgqPSoPnjUrWUN9iUVzhyEcrH9z3tLw agag== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=QSzEC8J/jic/yUzgiJT/ExfnYj3bcKEvryJh9PYcwJg=; b=althWmrMc00EvfQ9FUPMjxP6PRwQlHC+P8Ough69UcZddzXhkzmmgOwTURzTCMsGgf iJXy8/21WN2r6oWJsU3RnGpeodytbJswqw9Z8EQmspLKp4deEsH7lOUideR2Ici+mfFT fFs5dFsLrOS08XwC2ObYcPHHGIjv0F2NH1xZ5wOwQtQ9To+5K2w3ECkmxwj99/7CNJzb RSKoAhLzX6E4n+DARKK7n8ABWGQYDyBpxc6DuIHStWb3+9/Rpl+LzCCrTlc29zVQXZzr tbYVpybul11wdRWyk7ndsCwlLoa7nXIEqVYg/j3eIQnNKFreBHjZa331pSNCzjYl6KZr I/GA== X-Gm-Message-State: APjAAAUg9yprZ5I46oNnHhAkxhjJOVHddUS91KDqbRXSZOBLiz8sITWY bl2VQmVg9CiHJPsUePja9LEG93gQTe21rStxGjDguA== X-Google-Smtp-Source: APXvYqwgJDKdTGLqgzY8dPS2vy4CmAz0Rr5ftjjD3cbLjABB2ANca5nMaPktoyKAjm9wcxWwz61Xqzwm3di6mHYgu2M= X-Received: by 2002:adf:f0cc:: with SMTP id x12mr11312632wro.326.1572621773102; Fri, 01 Nov 2019 08:22:53 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Dave Page Date: Fri, 1 Nov 2019 15:22:40 +0000 Message-ID: Subject: Re: [pgAdmin][RM4451]Cannot construct SQL script for composite type having only one field variable To: Aditya Toshniwal Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="000000000000273d2205964a8aa0" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000273d2205964a8aa0 Content-Type: text/plain; charset="UTF-8" Thanks, patch applied. On Fri, Nov 1, 2019 at 9:54 AM Aditya Toshniwal < aditya.toshniwal@enterprisedb.com> wrote: > Hi Hackers, > > pgAdmin allows to create composite type only with 2 or more members. > Attached is the patch to remove the restriction as PostgreSQL allows zero > or more and fix the issue where SQL is not generated for types having less > than 2 members. > > Kindly review. > > -- > Thanks and Regards, > Aditya Toshniwal > Sr. Software Engineer | EnterpriseDB India | Pune > "Don't Complain about Heat, Plant a TREE" > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company --000000000000273d2205964a8aa0 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks, patch applied.

On Fri, Nov 1, 2019 at 9:54 AM Adity= a Toshniwal <aditya= .toshniwal@enterprisedb.com> wrote:
Hi Hackers,

pgAdmin allows to c= reate composite type only with 2 or more members.
Attached is the patch to = remove the restriction as PostgreSQL allows zero or more and fix the issue = where SQL is not generated for types having less than 2 members.

=
Kindl= y review.

--
Thanks and Regards,
Aditya Toshniwal
Sr. Software Engin= eer |=C2=A0EnterpriseDB India |=C2=A0Pune
"Don't Complain about Heat, Plant a TRE= E"


--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @p= gsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL = Company
--000000000000273d2205964a8aa0--