Re: flock user defined function

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: flock user defined function
Дата
Msg-id 23898.1087944545@sss.pgh.pa.us
обсуждение исходный текст
Ответ на flock user defined function  (Chris Goughnour <cgoughnour@hotp.com>)
Ответы Re: flock user defined function  (Chris Goughnour <cgoughnour@hotp.com>)
Список pgsql-general
Chris Goughnour <cgoughnour@hotp.com> writes:
> Any suggestions? Thanks in advance.

I believe locks are associated with file descriptors (what you're
miscalling a handle).  The unlock function cannot release a lock
that is held via a different descriptor.  What it needs to be doing
is closing the descriptor that lockFile opened.  This would also
solve the rather serious descriptor-leak problem you've got.

            regards, tom lane

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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Connection gets into state where all queries fail
Следующее
От: Doug McNaught
Дата:
Сообщение: Re: flock user defined function