BUG #4759: RETURNS TABLE not supported in pgAdmin

From: "Frank Heikens" <frank(at)jakaree(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4759: RETURNS TABLE not supported in pgAdmin
Date: 2009-04-16 12:48:18
Message-ID: 200904161248.n3GCmI9c027460@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4759
Logged by: Frank Heikens
Email address: frank(at)jakaree(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2009-04-16 13:54:29 Re: BUG #3826: Very Slow Execution of examplequery (wrong plan?)
Previous Message Alexander Steffens 2009-04-16 12:22:46 Re: BUG #3826: Very Slow Execution of examplequery (wrong plan?)