Обсуждение: OWNER not being quoted for FOREIGN TABLEs code

Поиск
Список
Период
Сортировка

OWNER not being quoted for FOREIGN TABLEs code

От
Diego Augusto Molina
Дата:
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.
Вложения

Re: OWNER not being quoted for FOREIGN TABLEs code

От
Akshay Joshi
Дата:
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