Postgres Pro
Downloads
Home   >   mailing lists

CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT - Mailing list pgsql-general

From MLikharev@micropat.com
Subject CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT
Date
Msg-id fce02f87d9.f87d9fce02@micropat.com
Whole thread Raw
Responses Re: CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT
List pgsql-general
Tree view 
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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Relation between pgsql_tmp and work_mem
Next
From: "Wen Guangcheng"
Date:
Subject: Problem in creating a table