Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group