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

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

Haven't read the patch, but a question seems in order here: should
we regard this as a back-patchable bug fix?  The original example
shows that it's possible to create a zero-column view in existing
releases, which I believe would then lead to dump/reload failures.
So that seems to qualify as a bug not just a missing feature.
On the other hand, given the lack of field complaints, maybe it's
not worth the trouble to back-patch.  I don't have a strong
opinion either way.

BTW, has anyone checked on what the matview code paths will do?
Or SELECT INTO?

            regards, tom lane


pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Why don't we have a small reserved OID range for patch revisions?
Next
From: Tom Lane
Date:
Subject: Re: Why don't we have a small reserved OID range for patch revisions?