Re: ON SELECT rule on a table without columns - Mailing list pgsql-hackers

From Ashutosh Sharma
Subject Re: ON SELECT rule on a table without columns
Date
Msg-id CAE9k0PkRJBZ3KhAiM3DBOLDxKN=egHBa6P-LBC48F_Vjk=VKrQ@mail.gmail.com
Whole thread Raw
In response to Re: ON SELECT rule on a table without columns  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: ON SELECT rule on a table without columns  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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

Attachment

pgsql-hackers by date:

Previous
From: Robbie Harwood
Date:
Subject: Re: libpq compression
Next
From: Konstantin Knizhnik
Date:
Subject: Re: libpq compression