18 Dec
2015
18 Dec
'15
12:47 p.m.
dropping it isn't updating it? On Friday, December 18, 2015, Guillaume Savary < guillaume.savary@securactive.net> wrote:
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