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

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

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: Erwin Brandstetter <brandstetter(at)falter(dot)at>, 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 20:24:43
Message-ID: 4BEDB18B.10108@lelarge.info (view raw or flat)
Thread:
Lists: pgadmin-hackers
Le 14/05/2010 13:42, Dave Page a écrit :
> 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.

OK. Fixed.

> 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.
> 

Not sure we really need to. This bug only occured for TABLE-returning
functions and was already there before 1.10.3.


-- 
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com

In response to

Responses

pgadmin-hackers by date

Next:From: Erwin BrandstetterDate: 2010-05-14 20:54:08
Subject: Re: Bug in 1.10.3: Properties dialog for functions returning TABLE(..) is broken.
Previous:From: pgAdmin TracDate: 2010-05-14 20:24:21
Subject: Re: [pgAdmin III] #188: Properties dialog for functions returning TABLE() broken.

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