CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT

Поиск
Список
Период
Сортировка
От MLikharev@micropat.com
Тема CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT
Дата
Msg-id fce02f87d9.f87d9fce02@micropat.com
обсуждение исходный текст
Ответы Re: CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
Дерево обсуждения 
Hi,
I was asking this question some time ago and was under impression that this will be fixed in 8.x. In general problem
is,CREATE TEMP TABLE AS SELECT does not report any rows to the engine, seems like, so GET DIAGNOSTICS ROW_COUNT after
thestatement returns 0 as well as FOUND false. This was working in 7.3, but behavior changed in 7.4. 
My question is, will it be fixed or should I consider not stop using get diagnostic after ‘create temp table as select’
fromnow on. Honstly this was a very convinient feature especialy knowing that select count(*)  not a fastes possible
operation.

Thank you.

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Relation between pgsql_tmp and work_mem
Следующее
От: "Wen Guangcheng"
Дата:
Сообщение: Problem in creating a table