[pgadmin-support] pgadmin III bug - schema prefix missing in return type

[Michael Shapiro]

When I declare a function with a schema-qualified return type, PgAdmin does 
not show the schema in the return type:

Here's what I tell Postgres:
===============================================
CREATE OR REPLACE FUNCTION xxx.packet_data(pg_catalog.numeric, pg_catalog.text)
  RETURNS setof xxx.data_tbl AS
'
        select * from axxx.data_view
        where packet_rec_id = $1
        and   tag           = $2;
'
  LANGUAGE 'sql' VOLATILE;
=====================================================
Here is what PgAdmin shows (note the change following the RETURNS)
=====================================================
CREATE OR REPLACE FUNCTION xxx.packet_data(pg_catalog.numeric, pg_catalog.text)
  RETURNS setof data_tbl AS
'
        select * from axxx.data_view
        where packet_rec_id = $1
        and   tag           = $2;
'
  LANGUAGE 'sql' VOLATILE;


---
Michael 

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster