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 1hdbZE-0001gg-8M for pgadmin-hackers@arkaria.postgresql.org; Wed, 19 Jun 2019 14:28:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hdbZD-0008OM-38 for pgadmin-hackers@arkaria.postgresql.org; Wed, 19 Jun 2019 14:28:03 +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 1hdbZC-0008La-PD for pgadmin-hackers@lists.postgresql.org; Wed, 19 Jun 2019 14:28:02 +0000 Received: from mail-wr1-x441.google.com ([2a00:1450:4864:20::441]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hdbZA-0003lU-6u for pgadmin-hackers@postgresql.org; Wed, 19 Jun 2019 14:28:01 +0000 Received: by mail-wr1-x441.google.com with SMTP id n4so3575565wrw.13 for ; Wed, 19 Jun 2019 07:28:00 -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=EAzd1r+R7bfUk3fAd01xghH9IzwbERnTRzSkFpf4kUU=; b=Llwep2+rMzft1t0V+BoAThAvw0YUEotCI2lTu0ZLDJj12l5gJ6F8h/fTjwJsNiYmDC xTMb/+DJhq0MOSdHmq1kp7o6h6mugyvEQEeX4mVt+E8GYYgM/6yqUMEq+K2wrIrf9eoQ qLrgWft8AzvqPaAl8I/XUq1xOevRaCtXrlvan8aM2nKdlItPZxQypNRIdoYdudqmaa3o q3cv44ePu5QbWe26AgxgxcD0s1t5bRztrHj1aZ7oo4hj2oLTu5ODpMixstURnSf8s4yU EGe7d8MP+s+ZPzKBn6Jk3u13kPb7qXBi64CWAv6aIo5wMlBP2N8feIqCJ4oyf4+l3IaC bmGA== 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=EAzd1r+R7bfUk3fAd01xghH9IzwbERnTRzSkFpf4kUU=; b=D5rixYBOLrGzZJYBo99TPRuudbeyN9zMJlV2Nao1+y5qm34zl7oLW4D7KZd9W3ycHj lU2Totlr1tgZV90RUEAP2kXv2hWjqwhs7H7wLvEZ3l8ALG3QTu8732E9/g2xFDXYeFfk NaYQfRh29NE+YvXuwpYpU9Zf9UYog/H8fNHKZXW5pFBg9QVY0TEY5lOTWRc2UvEKhuwu tgA4tbBinMjrh4t+38Pehuy7X5JZCa+9za0RDDJ8NjjzoN8RS6qmK5TFdl+VAlYMLrBs vD9EpGxehT1CSV5PyaCSzqykw8YypUeidPynyWyYveU5n41jZ2Tl9aHpLXyBss+LeTF+ wZ2w== X-Gm-Message-State: APjAAAUQZfybENjHbSo3McrwOZ22R1w743mZNgiLpo9fCXxyCRYFnY3F iettJysM2WW9o28wnObjrarFDWy+5iMDUA1FuWQnuA== X-Google-Smtp-Source: APXvYqwc2zY+QzrOE3EFw9MX2ALDz+8IamjfMmgnOAsxBm82mHj+i+Gen3b8p14rKSLsyXJkkXART2nDGGMpaSuaYGA= X-Received: by 2002:adf:f589:: with SMTP id f9mr5952464wro.90.1560954477958; Wed, 19 Jun 2019 07:27:57 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Dave Page Date: Wed, 19 Jun 2019 15:27:46 +0100 Message-ID: Subject: Re: [pgAdmin4][Patch]: RM #4362 trigger function create script To: Akshay Joshi Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="0000000000002b69d2058bae09a8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --0000000000002b69d2058bae09a8 Content-Type: text/plain; charset="UTF-8" Hi On Wed, Jun 19, 2019 at 9:55 AM Akshay Joshi wrote: > Hi Hackers, > > Attached is the patch to fix RM #4362 trigger function create script. > Please review it. > While I can see how this works, I question why we have the string "SETOF" in prorettypname anyway? That's a separate property, so it should be in a separate variable. What if I have a type called "SETOFDavesStuff" (unlikely, but it illustrates the point)? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company --0000000000002b69d2058bae09a8 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi

On Wed, Jun 19, 2019 at 9:55 AM Akshay Joshi <akshay.joshi@enterprisedb.co= m> wrote:
Hi Hackers,

Attached is the patch to f= ix RM #4362 trigger function create script.=C2=A0
Please review i= t.

While I can see how this wor= ks, I question why we have the string "SETOF" in prorettypname an= yway? That's a separate property, so it should be in a separate variabl= e. What if I have a type called "SETOFDavesStuff" (unlikely, but = it illustrates the point)?

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

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL= Company
--0000000000002b69d2058bae09a8--