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

Re: Bug in 1.10.3: Properties dialog for functions returning TABLE(..) is broken.

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Erwin Brandstetter <brandstetter(at)falter(dot)at>
Cc: guillaume(at)lelarge(dot)info, pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Bug in 1.10.3: Properties dialog for functions returning TABLE(..) is broken.
Date: 2010-05-14 11:42:11
Message-ID: AANLkTimDIl9gp9j1NqwnRE4plp--vrmarsdlcRfR_576@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
On Fri, May 14, 2010 at 12:32 PM, Erwin Brandstetter
<brandstetter(at)falter(dot)at> wrote:
> On 14.05.2010 08:49, guillaume(at)lelarge(dot)info wrote:
>>
>> Hi Erwin,
>>
>> Le 14/05/2010 04:35, Erwin Brandstetter a écrit :
>>
>>>
>>> [...]
>>> On further testing 1.10.3 beta on Win XP Pro I found a bug that might be
>>> a show-stopper.
>>> See ticket #188.
>>>
>>>
>>
>> Can you give us the real statement to create that function?
>>
>
> I have tested with a variety of fuctions. Any function returning TABLE()
> will trigger the error. Example:
>
> CREATE FUNCTION foo (IN integer)
>  RETURNS TABLE(a integer, b integer) AS
> $BODY$
> SELECT 1,2;
> $BODY$
>  LANGUAGE 'sql';
>
> Then try changing anything via function properties.

Unfortunately it's too late to stop the show now (due to the
PostgreSQL build schedule, and pgCon next week). We can push out an
additional update in a week or so if we like.


-- 
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company

In response to

Responses

pgadmin-hackers by date

Next:From: Erwin BrandstetterDate: 2010-05-14 11:44:48
Subject: Re: Re: SVN Commit by dpage: r8369 - in trunk/pgadmin3: . docs pgadmin pkg/win32
Previous:From: Erwin BrandstetterDate: 2010-05-14 11:32:08
Subject: Re: Bug in 1.10.3: Properties dialog for functions returning TABLE(..) is broken.

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