Postgres Pro
Downloads
Home   >   mailing lists

Re: [pgAdmin][RM5843] [SQL] - Some 'options' values for function not shown in sql - Mailing list pgadmin-hackers

From Pradip Parkale
Subject Re: [pgAdmin][RM5843] [SQL] - Some 'options' values for function not shown in sql
Date
Msg-id CAJ9T6Svv-jHQQ6D5h5ow3rxNDRM2EqfENxNTXRjeueg=vxnF9Q@mail.gmail.com
Whole thread Raw
In response to Re: [pgAdmin][RM5843] [SQL] - Some 'options' values for function not shown in sql  (Akshay Joshi <akshay.joshi@enterprisedb.com>)
Responses Re: [pgAdmin][RM5843] [SQL] - Some 'options' values for function not shown in sql  (Akshay Joshi <akshay.joshi@enterprisedb.com>)
List pgadmin-hackers
Tree view
Hi Akshay,

Please find the attached patch for below issues:
1) The volatility option is not reflecting. It stays volatile always when creating the function - Fixed
2) Set "Returns as set" to true and enter estimated rows like 12. Now set returns as set to false and save. It gives ERROR: ROWS is not applicable when function does not return a set. Need to clear estimated rows when returns as set is false. - Fixed
3) If estimated rows are added and support function is selected then SQL looks ugly. - Fixed

On Mon, Oct 5, 2020 at 2:41 PM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
Thanks, patch applied.

On Thu, Oct 1, 2020 at 2:25 PM Pradip Parkale <pradip.parkale@enterprisedb.com> wrote:
Hi Akshay,

Please find the attached patch to allow the user to modify the option settings of the procedure. This issue was only for PPAS 11 and PPAS 12.

On Wed, Sep 23, 2020 at 11:30 PM Pradip Parkale <pradip.parkale@enterprisedb.com> wrote:
Hi Akshay,

Please find the small patch for the ' Parallel Unsafe' option is missing in SQL. It was missing in first patch for PG96 and PG10.


On Wed, Sep 23, 2020 at 1:25 PM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
Thanks, patch applied. It's a small fix so I have fixed it.

On Wed, Sep 23, 2020 at 12:14 PM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
Hi Pradip

RESQL tests are failing on EPAS 9.5, 9.6, and 10. Please fix and resend the patch.

On Tue, Sep 22, 2020 at 6:41 PM Pradip Parkale <pradip.parkale@enterprisedb.com> wrote:
Hi Hackers,

The 'Unsafe' parallel option was not visible in the SQL for function and procedure. Attached is the patch to fix this issue.

--
Thanks & Regards,
Pradip Parkale
Software Engineer | EnterpriseDB Corporation


--
Thanks & Regards
Akshay Joshi
pgAdmin Hacker | Sr. Software Architect
EDB Postgres
Mobile: +91 976-788-8246



--
Thanks & Regards
Akshay Joshi
pgAdmin Hacker | Sr. Software Architect
EDB Postgres
Mobile: +91 976-788-8246



--
Thanks & Regards,
Pradip Parkale
Software Engineer | EnterpriseDB Corporation


--
Thanks & Regards,
Pradip Parkale
Software Engineer | EnterpriseDB Corporation


--
Thanks & Regards
Akshay Joshi
pgAdmin Hacker | Sr. Software Architect
EDB Postgres
Mobile: +91 976-788-8246



--
Thanks & Regards,
Pradip Parkale
Software Engineer | EnterpriseDB Corporation
Attachment

pgadmin-hackers by date:

Previous
From: Akshay Joshi
Date:
Subject: Re: RM-2519: Show the trigger function under the trigger node.
Next
From: Akshay Joshi
Date:
Subject: pgAdmin 4 commit: Update Italian translation.