Re: transaction is read-only error

On Fri, Sep 17, 2010 at 6:14 AM, Salil Wadnerkar <rohshall@gmail.com> wrote:
> Hi Josh,
>
> Thanks for replying. I tried the "set transaction" command. I still
> get the "transaction is read-only" error when I issue the "insert
> into" command.
> If there is no other solution, how do I set the value of the variable
> "default_transaction_read_only" to false from the admin console?

How about trying this using the psql client to connect to your database:

  BEGIN;
     SET TRANSACTION READ WRITE;
     -- try your insert statement here
  COMMIT;

As for permanently turning off default_transaction_read_only, you can
do it either with an ALTER DATABASE or by editing postgresql.conf,
setting default_transaction_read_only = off, and restarting or
reloading the server. You said the ALTER DATABASE didn't work before,
but maybe that was because you tried the ALTER DATABASE inside a
transaction? Either way.. if you're still having problems, use psql
directly and post exactly what you entered and what error
messages/other output you see.

Use these commands:
  SHOW default_transaction_read_only;
  SELECT name, setting, context, source FROM pg_settings WHERE name =
'default_transaction_read_only';

to help troubleshoot further.

Josh