Thread: Bug #5664 SQL DDL output generator for view
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.
Attachment
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 ShirsatSoftware Engineer | EnterpriseDB Corporation.
--
Thanks & Regards
Akshay Joshi
pgAdmin Hacker | Sr. Software Architect
EDB PostgresMobile: +91 976-788-8246