"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])


Reply via email to