From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com> |
Cc: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Re: [pgAdmin4][Patch]: RM #4362 trigger function create script |
Date: | 2019-06-20 12:19:44 |
Message-ID: | CA+OCxoxkBnOEd-KQC7N_oCaKRU0f27FadSsabAyM6_RVmAQwjQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Thanks, applied.
On Thu, Jun 20, 2019 at 7:48 AM Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
wrote:
> Hi Dave
>
> On Wed, Jun 19, 2019 at 8:47 PM Akshay Joshi <
> akshay(dot)joshi(at)enterprisedb(dot)com> wrote:
>
>> Hi Dave
>>
>> On Wed, 19 Jun, 2019, 19:57 Dave Page, <dpage(at)pgadmin(dot)org> wrote:
>>
>>> Hi
>>>
>>> On Wed, Jun 19, 2019 at 9:55 AM Akshay Joshi <
>>> akshay(dot)joshi(at)enterprisedb(dot)com> 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)?
>>>
>>
>> We have used pg_get_function_result(func_oid) to get the returns
>> clause for function and assign its value to prorettypename variable. I have
>> followed the same logic for trigger function and fixed it. Similar logic
>> has already been used for functions.
>>
>
> I have tested it with two different type "SETOF TypeTest" and
> "SETOFType" for function, as trigger_function only have return type either
> trigger or event_trigger. I haven't found any issue with the reverse
> engineered sql and create script as well.
>
>>
>>> --
>>> Dave Page
>>> Blog: http://pgsnake.blogspot.com
>>> Twitter: @pgsnake
>>>
>>> EnterpriseDB UK: http://www.enterprisedb.com
>>> The Enterprise PostgreSQL Company
>>>
>>
>
> --
> *Thanks & Regards*
> *Akshay Joshi*
>
> *Sr. Software Architect*
> *EnterpriseDB Software India Private Limited*
> *Mobile: +91 976-788-8246*
>
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2019-06-20 12:26:08 | pgAdmin 4 commit: Fix regression tests. |
Previous Message | Dave Page | 2019-06-20 12:19:30 | pgAdmin 4 commit: Remove additional "SETOF" included when generating CR |