Thread: OWNER not being quoted for FOREIGN TABLEs code

OWNER not being quoted for FOREIGN TABLEs code

From
Diego Augusto Molina
Date:
Hi, thanks for the great job!

I found that when looking at the SQL code for foreign tables the
generated code includes the 'ALTER ... OWNER TO' but the role is not
being quoted. This happens in the latest version for any supported
PostgreSQL server.

So I checked out the code and fixed it, I hope, since I didn't
actually test it because that involves lots of building, but the fix
is pretty straight forward and simple so I hope it's all ok.

I'm attaching the patch.

Attachment

Re: OWNER not being quoted for FOREIGN TABLEs code

From
Akshay Joshi
Date:
Thanks, patch applied. I have also fixed for Procedures and Trigger Functions.

On Thu, Jun 25, 2020 at 11:01 PM Diego Augusto Molina <diegoaugustomolina@gmail.com> wrote:
Hi, thanks for the great job!

I found that when looking at the SQL code for foreign tables the
generated code includes the 'ALTER ... OWNER TO' but the role is not
being quoted. This happens in the latest version for any supported
PostgreSQL server.

So I checked out the code and fixed it, I hope, since I didn't
actually test it because that involves lots of building, but the fix
is pretty straight forward and simple so I hope it's all ok.

I'm attaching the patch.


--
Thanks & Regards
Akshay Joshi
Sr. Software Architect
EnterpriseDB Software India Private Limited
Mobile: +91 976-788-8246