Re: am i doing something stupid, or should i file a bug report? this seems absurd :) thanks

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 On 18/12/15 14:43, Anthony Damico wrote:

you can't drop a table if it contains data? i am confused

Of course you can. Lefteris is confused, I think.

On Friday, December 18, 2015, Lefteris mailto:lsidir@gmail.com> wrote:

Kind of yes, but then again you can not drop any table (not just the read-only ones) if it contains data.

On Fri, Dec 18, 2015 at 2:12 PM, Anthony Damico javascript:_e(%7B%7D,'cvml','ajdamico@gmail.com');> wrote:

alright, that seems like a small bug then. if a table has zero records, it cannot be protected but if it has one record, it can. thanks all

https://www.monetdb.org/bugzilla/show_bug.cgi?id=3889

On Fri, Dec 18, 2015 at 7:59 AM, Lefteris javascript:_e(%7B%7D,'cvml','lsidir@gmail.com');> wrote:

It is read-only, not write protected:)

I am joking, but we use the read-only property to create non-updatable indeces and perform other optimization that would be impossible to do if there could be updates, appends, inserts etc. into the table.

Now, if the read-only statement means also that you can not drop the table, that is debatable.

Trying creating a table, add one row of values, then make it a read-only and then try to drop it. My bet is it will not be dropped. Then try to delete the row while the table is still read-only, you should not be able.

Lefteris

On Fri, Dec 18, 2015 at 1:47 PM, Anthony Damico javascript:_e(%7B%7D,'cvml','ajdamico@gmail.com');> wrote:

dropping it isn't updating it?

On Friday, December 18, 2015, Guillaume Savary javascript:_e(%7B%7D,'cvml','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 youdid not "update" the data, it seems normal I guess.

-- Guillaume Savary Securactive R&D

_______________________________________________ users-list mailing list users-list@monetdb.org javascript:_e(%7B%7D,'cvml','users-list@monetdb.org'); https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org javascript:_e(%7B%7D,'cvml','users-list@monetdb.org'); https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org javascript:_e(%7B%7D,'cvml','users-list@monetdb.org'); https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

- -- Sjoerd Mullender -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQEcBAEBCAAGBQJWdA9NAAoJEISMxT6LrWYgZ2YIAL6r8hgzpzQg514/2bzsCe5P 9vhfhIGAkoYQBBoWlSqFX6foml6cD1yU9yu7Sqv2MCa6iLr4ixxP+9eCMStbN4If Jd8LvpV0vubKeXaidJwXw9aeXYQgvoxpUtyWmFWh8LLfIrK+bsdBsHzHC3iLODKR R5ZN0uJzYRy2G4AyU1zqA4hN5CUciHoiinplkZOSmwR0vw+KrVl8I0/z/TyIZJMS Ch4MWQLkomtOB6JetUpiHL/jmwYTBHcWFoMGrz6xHq35Ay3TZOu0+MCrjboMIj5/ BsL6al3SCd3age+RRmL7rG93Wf6U3xWYrnzfd3mwbeDrxISnwnFvrxu6cE6He70= =ZX4o -----END PGP SIGNATURE-----