Re: CTID: Anyway to lock it?

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема Re: CTID: Anyway to lock it?
Дата
Msg-id 3DC85E59.2CEFA1A2@tpf.co.jp
обсуждение исходный текст
Ответ на Re: CTID: Anyway to lock it?  ("Dave Page" <dpage@vale-housing.co.uk>)
Список pgsql-odbc

Jim Hines wrote:
>
> > > Hmm, yes - it appears to be in inner_process_tokens(QueryParse *qp,
> > > QueryBuild *qb) in convert.c. I don't know what options might affect
> > > that though I'm afraid - do you know Hiroshi?
> >
> > The driver uses CTID and OID to implement updatable cursors.
> > Please turn off the *Updatable cursors* DSN option if you
> > don't like the behavior.
> >
> > regards,
> > Hiroshi Inoue
> >       http://w2422.nsk.ne.jp/~inoue/
>
> If I turn off the cursors, the Lyric software complains about an Invalid
> Cursor state.

If the software requires keyset-driven/static cursors with
optimistic concurrency control, you may have to turn on the
option or need the help of e.g. ODBC cursor library.

regards,
Hiroshi Inoue
    http://w2422.nsk.ne.jp/~inoue/

В списке pgsql-odbc по дате отправления:

Предыдущее
От: Simeó Reig
Дата:
Сообщение: ...
Следующее
От: Valerio Ferrucci
Дата:
Сообщение: Calling a function via ODBC