"Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)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