Thread: [pgAdmin][RM5843] [SQL] - Some 'options' values for function not shown in sql

[pgAdmin][RM5843] [SQL] - Some 'options' values for function not shown in sql

From
Pradip Parkale
Date:
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
Attachment

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

From
Akshay Joshi
Date:
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

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

From
Akshay Joshi
Date:
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

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

From
Pradip Parkale
Date:
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
Attachment

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

From
Pradip Parkale
Date:
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
Attachment
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

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

From
Pradip Parkale
Date:
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
Thanks, patch applied.

On Mon, Oct 12, 2020 at 11:59 AM Pradip Parkale <pradip.parkale@enterprisedb.com> wrote:
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


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