Re: Bug in PL/pgSQL FOR cursor variant

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Bug in PL/pgSQL FOR cursor variant
Дата
Msg-id 4C1FB2B2.3000904@enterprisedb.com
обсуждение исходный текст
Ответ на Re: Bug in PL/pgSQL FOR cursor variant  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Bug in PL/pgSQL FOR cursor variant
Список pgsql-bugs
On 21/06/10 17:08, Tom Lane wrote:
> I suspect you need to pstrdup() the portalname.

Yes, you're right. Thanks.

> Also, isn't exec_for_query() at just as much risk?
> The latter's problem would only be exposed if the cursor was closed
> at a batch boundary, but it's still a problem.

Can you elaborate? I thought I fixed exec_for_query(). (except for the
missing pstrdup).

> I wonder whether we ought to try to make it an error to close a portal
> that's still in use.

I think it's fine as it is. FWIW what we do now matches Oracle.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

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

Предыдущее
От: "Kelly McLaughlin"
Дата:
Сообщение: BUG #5519: uuid-ossp files missing from contrib rpm
Следующее
От: Devrim GÜNDÜZ
Дата:
Сообщение: Re: BUG #5519: uuid-ossp files missing from contrib rpm