I would like to implement read-only transactions following the SQL spec,
so we can check off this item on the supported list. According to the
list I gathered, the following commands will fail if the transaction is
read-only:
alter *
analyze
checkpoint
cluster
comment
create *
delete (from non-temporary table)
drop *
execute (if the prepared statement is one in the list)
explain analyze (ditto)
grant
insert (into non-temporary table)
reindex
revoke
select into
truncate
update (non-temporary table)
vacuum
I think it's light-weight and marginally useful.
--
Peter Eisentraut peter_e(at)gmx(dot)net