Re: Array parameter declaration error - Mailing list pgadmin-support

From Andreas Pflug
Subject Re: Array parameter declaration error
Date
Msg-id 4368040A.8060405@pse-consulting.de
Whole thread Raw
In response to Array parameter declaration error  (&ru <voros.andras@gmail.com>)
List pgadmin-support
&ru wrote:
> OS: Win XP
> pgAdmin III 1.2.1 and 1.4 beta2 and 1.4 beta3
> hungarian language
> binary distribution
> 
> I wanted to create a new function with array i/o parameters and the
> SQL command that pgAdmin assembled was this:
> 
> CREATE FUNCTION test(v "varchar"[]) RETURNS "varchar[]" AS
> $BODY$BEGIN
> RETURN v;
> END$BODY$
> LANGUAGE 'plpgsql' VOLATILE;
> 
> and after I applied the dialog form, of course the following error occured:
> 
> ERROR: type "varchar[]" does not exist.

Fixed in svn, thanks for reporting.

Regards,
Andreas


pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: pgAdmin III v1.4.0 Release Candidate 1 released for testing
Next
From: Andreas Pflug
Date:
Subject: Re: Hide databases