Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group