#419 Functions returning the 'table' type are handled incorrectly

5.0.3
open
Functions (25)
5
2012-02-07
2012-02-07
null
No

If the function is created as returning the 'table' type, phpPgAdmin treats it as returning the 'setof record'. And when I try to modify the function I get the 'cannot change return type of existing function' error because it tries to alter it with a wrong return type.

ex
CREATE OR REPLACE FUNCTION "public"."getvalues" (int p1) RETURNS TABLE (val1 integer, val2 integer) AS
....

ERROR: cannot change return type of existing function
DETAIL: Row type defined by OUT parameters is different.
HINT: Use DROP FUNCTION first.

in

CREATE OR REPLACE FUNCTION "public"."getvalues" (int p1) RETURNS SETOF record AS
....

Discussion

  • null
    null
    2012-02-07

    • summary: Functions returning the 'table' type are display incorrectly --> Functions returning the 'table' type are handled incorrectly