X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 3C6839DCBD9 for ; Mon, 13 Feb 2006 04:59:34 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 67696-04 for ; Mon, 13 Feb 2006 04:59:35 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from uproxy.gmail.com (uproxy.gmail.com [66.249.92.205]) by postgresql.org (Postfix) with ESMTP id CED6A9DCBCE for ; Mon, 13 Feb 2006 04:59:31 -0400 (AST) Received: by uproxy.gmail.com with SMTP id y2so523089uge for ; Mon, 13 Feb 2006 00:59:33 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references; b=U6AqjnkW0vINZzPZ+GUagrVzo3+En0XImTF5hZBqw6FLP9MQlgZLlj8yfi6724P+YNbdmw9rKnkoMQWefyXFYY2VwIr9HL/okmg1n1OgGzus76HsBvPl29bznno4uGCLtbRWieN+7LXqAd5y5ANocidrLPSj+ioGLEDNmGSEKHU= Received: by 10.66.243.20 with SMTP id q20mr1005216ugh; Mon, 13 Feb 2006 00:59:32 -0800 (PST) Received: by 10.67.30.2 with HTTP; Mon, 13 Feb 2006 00:59:32 -0800 (PST) Message-ID: Date: Mon, 13 Feb 2006 10:59:32 +0200 From: Tsirkin Evgeny To: Robert Perry Subject: Re: Need query parameter in logs Cc: pgsql-admin@postgresql.org In-Reply-To: <6060C59D-9834-44F1-A4AF-31539D55FB4B@lodestonetechnologies.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_14237_16942836.1139821172863" References: <6060C59D-9834-44F1-A4AF-31539D55FB4B@lodestonetechnologies.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200602/156 X-Sequence-Number: 20577 ------=_Part_14237_16942836.1139821172863 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Well I am not a guru ,but maybe you can add raise notice to your game_state_set_disqualified ? On 2/9/06, Robert Perry wrote: > > I am trying to help debug a application that is deployed in the > field. I suspect that it is sending some unexpected values to some > stored procs, but the logs look very much like: > > Feb 9 14:29:26 localhost postgres[3138]: [122-1] LOG: statement: > Select * from game_state_set_disqualified( $1, $2, $3, $4 ) > > How can I find out what $1, $2, $3, $4 are short of recompiling > the C > ++ client code? > > Thanks > Robert Perry > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > ------=_Part_14237_16942836.1139821172863 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Well I am not a guru ,but maybe you can add
raise notice
to your gam= e_state_set_disqualified ?

On 2/9/0= 6, Robert Perry < rlperry@lodestonetechnologies.com> wrote:
      &= nbsp; I am trying to help debug a application that is deployed in the
field. I suspect that it is sending some unexpected values to some
s= tored procs, but the logs look very much like:

Feb 9 14:29:26 localh= ost postgres[3138]: [122-1] LOG: statement:
Select * from game_state_set= _disqualified( $1, $2, $3, $4 )

        How can I find out = what $1, $2, $3, $4 are short of recompiling the C
++ client code?
Thanks
Robert Perry


---------------------------(end of broa= dcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
&nb= sp;      subscribe-nomail command to majordomo@postgresql.org so that your       message can get through to the mailin= g list cleanly

------=_Part_14237_16942836.1139821172863--