Re: transaction is read-only error

From: Josh Kupershmidt <schmiddy(at)gmail(dot)com>
To: Salil Wadnerkar <rohshall(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: transaction is read-only error
Date: 2010-09-14 22:04:30
Message-ID: AANLkTim+bGE+3WgMiVPe=pAgebXQ-EstHLiG4AZBrxhT@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Tue, Sep 14, 2010 at 5:31 AM, Salil Wadnerkar <rohshall(at)gmail(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Rob Richardson 2010-09-15 13:16:31 Adding seconds to a time
Previous Message Mladen Gogala 2010-09-14 21:30:28 Neat trick