X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 5818B9FA1A8 for ; Fri, 9 Jun 2006 17:33:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 86763-02 for ; Fri, 9 Jun 2006 17:33:27 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from pd8mo2no.prod.shaw.ca (idcmail-mo2no.cg.shawcable.net [64.59.134.9]) by postgresql.org (Postfix) with ESMTP id 985FA9FA5DD for ; Fri, 9 Jun 2006 17:33:27 -0300 (ADT) Received: from pd7mr5no.prod.shaw.ca (pd7mr5no-qfe2.prod.shaw.ca [10.0.144.222]) by l-daemon (Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15 2004)) with ESMTP id <0J0M00JZM13PGZC0@l-daemon> for pgsql-sql@postgresql.org; Fri, 09 Jun 2006 14:33:25 -0600 (MDT) Received: from pn7ml1no.prod.shaw.ca ([10.0.149.110]) by pd7mr5no.prod.shaw.ca (Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15 2004)) with ESMTP id <0J0M007LO13PRIG0@pd7mr5no.prod.shaw.ca> for pgsql-sql@postgresql.org; Fri, 09 Jun 2006 14:33:25 -0600 (MDT) Received: from Dell4500 ([24.77.157.242]) by l-daemon (Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15 2004)) with SMTP id <0J0M0010Y13JP540@l-daemon> for pgsql-sql@postgresql.org; Fri, 09 Jun 2006 14:33:25 -0600 (MDT) Date: Fri, 09 Jun 2006 15:33:31 -0500 From: George Weaver Subject: Re: Problems Testing User-Defined Function To: Rommel the iCeMAn Cc: pgsql-sql@postgresql.org Message-id: <008001c68c03$f9aa5cc0$6400a8c0@Dell4500> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 X-Mailer: Microsoft Outlook Express 6.00.2900.2869 Content-type: text/plain; format=flowed; charset=iso-8859-1; reply-type=original Content-transfer-encoding: 7bit X-Priority: 3 X-MSMail-priority: Normal References: <000001c68bff$828b5ad0$1264a8c0@theport.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/110 X-Sequence-Number: 25346 ----- Original Message ----- From: "Rommel the iCeMAn" > > I am trying to pass the following values to the function but I have been > so > far unsuccessful. What error message are you receiving? > > SELECT sp_insert_manifest('me', me@you.com', 'me@you.com', 'test.txt', > NULL, > '2006/06/09') Is this a direct paste? If so, you are missing the apostrophe before me@ you.com. Regards, George