Re: Creating a zero-column table

Philip Warner <pjw(at)rhyme(dot)com(dot)au> writes:
> At 04:08 PM 12/12/2002 -0500, Tom Lane wrote:
>> Should we remove this error check, thereby effectively making
>> zero-column tables first-class citizens?

> The other option is to disallow the steps that resulted in the zero-column
> table in the first place. This is probably more rational.

That was where we were a couple months ago: DROP COLUMN would refuse to
let you drop the last column of a table. But that has much worse
problems than whether we are able to deliver a "helpful" error message.
For example:
Amy does CREATE TABLE foo(f1 beths_type);
Beth now cannot drop her type beths_type.
In most circles this would be called a denial of service.

regards, tom lane