Re: transaction is read-only error - Mailing list pgsql-novice

On Tue, Sep 14, 2010 at 5:31 AM, Salil Wadnerkar <rohshall@gmail.com> wrote:
[snip]
> This last line generates the error. So, I gave superuser permission to
> this user gm-dbo because I think non-superusers cannot change
> "default_transaction_read_only" to true.

I think any user should be able to issue:
  SET TRANSACTION READ WRITE;
at the beginning of a transaction, have you tried this?

Josh