Get diagnistic (row_count) 7.3 vs. 7.4 changes - Mailing list pgsql-general

From Maksim Likharev
Subject Get diagnistic (row_count) 7.3 vs. 7.4 changes
Date
Msg-id 000201c4d7d8$cff34170$8815a8c0@aurigin.com
Whole thread Raw
Responses Re: Get diagnistic (row_count) 7.3 vs. 7.4 changes
List pgsql-general
Hi,
Just trying 7.4.5 and bumped into a problem.

consider following code:

CREATE OR REPLACE FUNCTION rowcount_test() RETURNS bigint AS '
DECLARE
    base_hits bigint;
BEGIN
    CREATE TEMP TABLE ltbl_temp AS SELECT 1 AS data;
    GET DIAGNOSTICS base_hits = ROW_COUNT;

    RETURN base_hits;
END;
' LANGUAGE PLPGSQL VOLATILE;

in 7.3.3 GET DIAGNOSTICS was returning number of selected rows into a temp
table
in 7.4.5 GET DIAGNOSTICS returns 0

Is it known behavior change or something else.
Thank you.


pgsql-general by date:

Previous
From: Woodchuck Bill
Date:
Subject: Re: Upcoming Changes to News Server ...
Next
From: Bill Kurland
Date:
Subject: md5 checksum mismatch