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
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?) |