BUG #4759: RETURNS TABLE not supported in pgAdmin

Поиск
Список
Период
Сортировка
От Frank Heikens
Тема BUG #4759: RETURNS TABLE not supported in pgAdmin
Дата
Msg-id 200904161248.n3GCmI9c027460@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #4759: RETURNS TABLE not supported in pgAdmin  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Alexander Steffens
Дата:
Сообщение: Re: BUG #3826: Very Slow Execution of examplequery (wrong plan?)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #3826: Very Slow Execution of examplequery (wrong plan?)