Read-only transactions - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Read-only transactions
Date
Msg-id Pine.LNX.4.44.0301070014070.8249-100000@localhost.localdomain
Whole thread Raw
Responses Re: Read-only transactions
List pgsql-hackers
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@gmx.net



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: IPv6 detection
Next
From: Tom Lane
Date:
Subject: Re: Read-only transactions