Re: error on INSERT - connection is read only

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема Re: error on INSERT - connection is read only
Дата
Msg-id 3B00AD46.13C8EA23@tpf.co.jp
обсуждение исходный текст
Ответ на error on INSERT - connection is read only  ("Nisha Srinivasan" <nisha@arch.sel.sony.com>)
Список 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 по дате отправления:

Предыдущее
От: Lamar Owen
Дата:
Сообщение: Re: [PORTS] 7.1.1-2.PGDG RPMset.
Следующее
От: Bruce Momjian
Дата:
Сообщение: SCHEMA idea