pgadmin III bug - schema prefix missing in return type

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

Browse pgadmin-support by date

  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.