From: | Michael Shapiro <mshapiro(at)ncsa(dot)edu> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | pgadmin III bug - schema prefix missing in return type |
Date: | 2003-11-24 20:45:54 |
Message-ID: | 5.2.0.9.2.20031124144230.00b83670@pop.ncsa.uiuc.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2003-11-24 23:42:23 | Re: pgAdmin3 solaris |
Previous Message | Devrim GUNDUZ | 2003-11-24 19:08:34 | poEdit packages for FC1 are ready. |