On Fri, Feb 8, 2019 at 7:55 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Andres Freund <andres@anarazel.de> writes:
> > You misunderstood my point: I'm asking why we shouldn't remove that check from views, rather than adding it to
createrule.
>
> +1. This seems pretty obviously to be something we just missed when
> we changed things to allow zero-column tables.
>
Thanks Andres for bringing up that point and thanks Tom for the confirmation.
Attached is the patch that allows us to create view on a table without
columns. I've also added some test-cases for it in create_view.sql.
Please have a look and let me know your opinion.
--
With Regards,
Ashutosh Sharma
EnterpriseDB:http://www.enterprisedb.com