Received: from magenta.timewarp.co.uk (ns2.timewarp.co.uk [195.188.56.7] (may be forged)) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f14KMTx16868 for ; Sun, 4 Feb 2001 15:22:29 -0500 (EST) (envelope-from ken@kencorey.com) Received: from [195.167.153.42] by magenta.timewarp.co.uk (NTMail 5.06.0016/NT9060.00.3234d82d) with ESMTP id candiaaa for pgsql-sql@postgresql.org; Sun, 4 Feb 2001 20:18:24 +0000 From: Ken Corey To: Tom Lane Subject: Re: Hrm...why is this wrong? Date: Sun, 4 Feb 2001 20:25:02 +0000 X-Mailer: KMail [version 1.1.99] Content-Type: text/plain; charset="iso-8859-1" References: <01020413373508.18716@kenlinux.bithub.org> <6957.981317627@sss.pgh.pa.us> In-Reply-To: <6957.981317627@sss.pgh.pa.us> Cc: pgsql-sql@postgresql.org MIME-Version: 1.0 Message-Id: <0102042025020D.18716@kenlinux.bithub.org> Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by mail.postgresql.org id f14KMTx16869 X-Archive-Number: 200102/30 X-Sequence-Number: 1198 Wow! Answering emails on a Sunday? Someone should be giving you an award or something. On Sunday 04 February 2001 8:13 pm, you wrote: > Ken Corey writes: > > When the select at the bottom of this email is executed, I'm getting the > > message: > > ERROR: parser: parse error at or near "$1" > > I don't get that; I get > ERROR: Attribute 'username_in' not found > which is about what I'd expect for the given function text; maybe you > didn't transcribe it accurately? That's strange...perhaps the difference was a problem with my table definition? *shrug* I also had made a few mistakes, so once I got those fixed, the code seems to work again. > Anyway, an invaluable technique for debugging plpgsql functions is to > start psql with debug level 2, so that the queries the plpgsql executor > feeds to the SQL engine get logged in the postmaster log. (If you don't > run the postmaster with a logfile, you should...) For example: Hey, that's perfect. It's okay just so long as the debugging out goes *somewhere*...:^) Thanks, Tom. -- Ken Corey, CTO Atomic Interactive, Ltd.