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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
