pgadmin III bug - schema prefix missing in return type

Поиск
Список
Период
Сортировка
От Michael Shapiro
Тема pgadmin III bug - schema prefix missing in return type
Дата
Msg-id 5.2.0.9.2.20031124144230.00b83670@pop.ncsa.uiuc.edu
обсуждение исходный текст
Список pgadmin-support
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 



В списке pgadmin-support по дате отправления: