Re: CTID: Anyway to lock it?

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема Re: CTID: Anyway to lock it?
Дата
Msg-id 3DC797B1.761EB5D2@tpf.co.jp
обсуждение исходный текст
Ответ на Re: CTID: Anyway to lock it?  ("Dave Page" <dpage@vale-housing.co.uk>)
Ответы Re: CTID: Anyway to lock it?  (Jim Hines <jhines@wdtv.com>)
Список pgsql-odbc
Dave Page wrote:
>
> > -----Original Message-----
> > From: Jim Hines [mailto:jhines@wdtv.com]
> > Sent: 04 November 2002 20:06
> > To: pgsql-odbc@postgresql.org; Dave Page
> > Subject: Re: [ODBC] CTID: Anyway to lock it?
> >
> > The folks at Chyron say they are not specifiing CTID and that
> > it must be
> > within the ODBC driver. Could this be the case? If so, what
> > setting would
> > control this?
>
> 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/

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

Предыдущее
От: "Tambet Matiisen"
Дата:
Сообщение: updatable views and optimistic locking
Следующее
От: "Samuele"
Дата:
Сообщение: Increase inactivity timeout