Обсуждение: Bug #5664 SQL DDL output generator for view

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

Bug #5664 SQL DDL output generator for view

От
Rahul Shirsat
Дата:
Hi Hackers,

Please find the attached patch below which resolves the following issue of SQL DDL output generator for view (preserving default values of columns)

Also, when changing VIEW's column's default value, the SQL generates ALTER TABLE, now this would be as ALTER VIEW instead.

This fix could not be associated with its test cases, as the changes are related to VIEW's column, in which we cannot add columns to the VIEW and test it.

--
Rahul Shirsat
Software Engineer | EnterpriseDB Corporation.
Вложения

Re: Bug #5664 SQL DDL output generator for view

От
Akshay Joshi
Дата:
Thanks, patch applied.

On Fri, Aug 7, 2020 at 8:00 PM Rahul Shirsat <rahul.shirsat@enterprisedb.com> wrote:
Hi Hackers,

Please find the attached patch below which resolves the following issue of SQL DDL output generator for view (preserving default values of columns)

Also, when changing VIEW's column's default value, the SQL generates ALTER TABLE, now this would be as ALTER VIEW instead.

This fix could not be associated with its test cases, as the changes are related to VIEW's column, in which we cannot add columns to the VIEW and test it.

--
Rahul Shirsat
Software Engineer | EnterpriseDB Corporation.


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