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
|
Список | 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 по дате отправления: