Re: Backend message type 0x50 arrived while idle

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Backend message type 0x50 arrived while idle
Дата
Msg-id 14780.1039020048@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Backend message type 0x50 arrived while idle  (Doug McNaught <doug@mcnaught.org>)
Список pgsql-general
Doug McNaught <doug@mcnaught.org> writes:
> AFAIK it's extremely bad practice in general to share a connection
> between two threads, unless you protect it with some kind of lock to
> avoid simultaneous use.

I suspect Doug's put his finger on the problem --- are you trying to
use the same PGconn object in both threads?  Not a good idea at all.
libpq isn't thread-aware (mainly because of the portability problems
that would ensue), and it *will* break if you try to use the same
PGconn concurrently in two different threads.

            regards, tom lane

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

Предыдущее
От: Joel Burton
Дата:
Сообщение: Re: Create Timestamp From Date and Time AGAIN (REPOST)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 7.3 no longer using indexes for LIKE queries