Re: DROP COLUMN Progress

"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
>> Are you checking access to columns that're to the right of the one
>> dropped?

> OK, interesting:

> test=# create table test (a int4, b int4, c int4, d int4);
> CREATE TABLE
> test=# insert into test values (1,2,3,4);
> INSERT 16588 1
> test=# alter table test drop b;
> ALTER TABLE
> test=# select * from test;
>  a | d | d
> ---+---+---
>  1 | 3 | 4
> (1 row)

What of
SELECT a,c,d FROM test

I'll bet that doesn't work at all...
        regards, tom lane