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

From MLikharev@micropat.com
Subject Re: CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT
Date
Msg-id 11d7ba11daf7.11daf711d7ba@micropat.com
Whole thread Raw
In response to CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT  (MLikharev@micropat.com)
Responses Re: CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT
List pgsql-general
Hello,
I was not able to find any traces from the previous discussion trend,
but I believe that finished when I replaced GET DIAGNOSTIC with SELECT  COUNT().

Perfectly fine workaround, but more I look at that more I see why GET DIAGNOSTIC was so convenient not to mentioned
thatSELECT COUNT() is not a fastest  
possible statement in PG.

Ideally what I would like are:
1. “Official” word whether that will be supported or not, ether way is fine,
but that will clear confusion for me and others.
2. Maybe some clause in docs clarifying behavior for the case

Best regards.


Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Can someone in the community comment on this question?  I don't know the
> answer.

I think it could be changed back without much work, but I have a feeling
that we'd deliberately decided on the change of behavior.  Can anyone
recall a prior discussion, or want to vote with or against MLikharev?

Note that the change is actually at the SPI level, and would affect
SPI_processed for all code using CREATE AS/SELECT INTO through SPI,
not only plpgsql.

            regards, tom lane



pgsql-general by date:

Previous
From: "bruce"
Date:
Subject: setting up default user
Next
From: John Gray
Date:
Subject: Re: Connecting to Postgres from LAN