"Christopher Kings-Lynne" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])