Re: [Gnumed-devel] Corrupt database

[Jerzy Luszawski]

On 30-05-2013 22:20 "Karsten Hilbert" <address@hidden> wrote:


> > 2. How to drop a readonly table 
> 
> set default_transaction_read_only to off;
> drop table ...;
> 

If I understand this option correctly, using it is insecure, as any
transaction (may be from all over the world) started before resetting
it to ON becomes read-write.
That's why I use 

set session characteristics as transaction READ WRITE ;

It does not change any defaults and other sessions are initiated in
read-only.

-- 
Jerzy Luszawski