| 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: | Whole Thread | Raw Message | 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. |