BUG #4759: RETURNS TABLE not supported in pgAdmin

Started by Frank Heikensalmost 17 years ago2 messagesbugs
Jump to latest
#1Frank Heikens
frank@jakaree.com

The following bug has been logged online:

Bug reference: 4759
Logged by: Frank Heikens
Email address: frank@jakaree.com
PostgreSQL version: 8.4beta1
Operating system: Windows XP
Description: RETURNS TABLE not supported in pgAdmin
Details:

pgAdmin 1.10.0 Beta 1 (and older) doesn't support the new returning TABLE
and translates the returning columns to IN-parameters.

It's not a bug in the database, just a missing feature in pgAdmin. But a
real PITA, functions are impossible to maintain using pgAdmin.

SQL-input:
create or replace function new_user(name TEXT, salary DECIMAL) RETURNS table
(id int, name text, salary decimal) AS

pg_proc gives me a nice proargmodes[] with table-parameters:
"{i,i,t,t,t}"

Result in pgAdmin:
CREATE OR REPLACE FUNCTION new_user(IN "name" text, IN salary numeric, IN id
integer, IN "name" text, IN salary numeric)
RETURNS SETOF record AS

Now it looks like the function has 5 IN-parameters instead of just 2
IN-parameters and 3 TABLE-columns.

Kind regard,
Frank

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Frank Heikens (#1)
Re: BUG #4759: RETURNS TABLE not supported in pgAdmin

"Frank Heikens" <frank@jakaree.com> writes:

pgAdmin 1.10.0 Beta 1 (and older) doesn't support the new returning TABLE
and translates the returning columns to IN-parameters.

I think you'd be better advised to report this on the pgAdmin lists.
The pgAdmin authors might happen to read it here but it's not the
best place to report.

regards, tom lane