Re: error on INSERT - connection is read only - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject Re: error on INSERT - connection is read only
Date
Msg-id 3B00AD46.13C8EA23@tpf.co.jp
Whole thread Raw
In response to error on INSERT - connection is read only  ("Nisha Srinivasan" <nisha@arch.sel.sony.com>)
List pgsql-hackers
Nisha Srinivasan wrote:
> 
> > Hi,
> >
> > l see that a lot of people have the same problem and have posted questions
> > but I couldn't find an answer on the web.
> >
> > I have Postgresql 6.5.3 running on Debian Linux.
> > And I use the iODBC driver manager 2.50.3 to make the ODBC calls.
> >
> > Am not able to insert data into Postgres tables across ODBC.
> > I can do it using psql though.
> >
> > odbc.ini has an entry saying readonly = no.

I may be off the point because I'm not an user of psqlodbc
driver under unix. There seems to be several restrictions
to describe odbc.ini though I don't know the reason.

1) Do you mean ~/.odbc.ini(user DSN?) by odbc.ini ?
2) Don't you have tabs between 'readonly' and '=' ?
3) Current driver is case sensitive in reading odbc.ini  and 'readonly' must be 'ReadOnly'.

regards,
Hiroshi Inoue


pgsql-hackers by date:

Previous
From: Lamar Owen
Date:
Subject: Re: [PORTS] 7.1.1-2.PGDG RPMset.
Next
From: Bruce Momjian
Date:
Subject: SCHEMA idea