Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 806FF9FB2F1 for ; Mon, 15 Jan 2007 13:36:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 67303-04 for ; Mon, 15 Jan 2007 13:35:53 -0400 (AST) X-Greylist: delayed 00:21:43.174312 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 9922B9FB320 for ; Mon, 15 Jan 2007 13:35:53 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.cisx.com (mail.cisx.com [213.133.202.146]) by svr4.postgresql.org (Postfix) with ESMTP id CCDA75AF97B for ; Mon, 15 Jan 2007 17:14:10 +0000 (GMT) Received: from DonAcer ([192.168.100.99]) by mail.cisx.com (8.13.1/8.13.1) with SMTP id l0FHDsVu019702 for ; Mon, 15 Jan 2007 17:13:59 GMT Message-ID: <002501c738c8$876a1700$6364a8c0@DonAcer> From: "Donald Fraser" To: "[ADMIN]" Subject: PL/pgSQL Return statements Date: Mon, 15 Jan 2007 17:13:45 -0000 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0022_01C738C8.83A48380" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.3028 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.498 tagged_above=0 required=5 tests=BAYES_50, HTML_40_50, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200701/125 X-Sequence-Number: 24281 This is a multi-part message in MIME format. ------=_NextPart_000_0022_01C738C8.83A48380 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I am currently trying to upgrade PostgreSQL from 8.0 to 8.1 on our = development machine and have run into a problem with RETURN VOID; = statements in PL/pgSQL functions that have a return type of void. I'm getting errors like the following: ERROR: RETURN cannot have a parameter in function returning void at or = near "VOID" at character 2983. Does this mean I must edit every function that is declared with RETURNS = VOID and remove the RETURN VOID; statement from the body? I did a pg_dumpall using the 8.1 libraries on the 8.0 database and this = made no difference. Thanks in advance,=20 regards Donald Fraser ------=_NextPart_000_0022_01C738C8.83A48380 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello,
I am currently trying to upgrade PostgreSQL from 8.0 to 8.1 on = our=20 development machine and have run into a problem with RETURN VOID;=20 statements in PL/pgSQL functions that have a return type of = void.
I'm getting errors like the following:
 
ERROR:  RETURN cannot have a parameter in function returning = void at=20 or near "VOID" at character 2983.
 
Does this mean I must edit every function that is declared with = RETURNS=20 VOID and remove the RETURN VOID; statement from the body?
 
I did a pg_dumpall using the 8.1 libraries on the 8.0 database and = this=20 made no difference.
 
Thanks in advance,
regards
Donald Fraser
------=_NextPart_000_0022_01C738C8.83A48380--