Re: Array parameter declaration error

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: &ru <voros(dot)andras(at)gmail(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Array parameter declaration error
Date: 2005-11-02 00:10:50
Message-ID: 4368040A.8060405@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Andreas Pflug 2005-11-02 00:12:50 Re: Hide databases
Previous Message Dave Page 2005-11-01 19:34:22 pgAdmin III v1.4.0 Release Candidate 1 released for testing