Le 17/12/2015 20:54, Anthony Damico a écrit :
sql>create table my_table as select 1 with data;
operation successful (57.729ms)
sql>alter table my_table set read only;
operation successful (5.488ms)
sql>alter table my_table add column my_column integer;
operation successful (10.563ms)
sql>drop table my_table;
operation successful (6.075ms)
Doc: "An individual table can be protected using the READ ONLY mode. All attempts to update are flagged as a SQL error."
As you did not "update" the data, it seems normal I guess.
-- Guillaume Savary Securactive R&D