Re: Need query parameter in logs

From: Tsirkin Evgeny <tsurkin(at)mail(dot)jct(dot)ac(dot)il>
To: Robert Perry <rlperry(at)lodestonetechnologies(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Need query parameter in logs
Date: 2006-02-13 08:59:32
Message-ID: dd5da9d90602130059r77725da6re95a1cdb737daf93@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 <rlperry(at)lodestonetechnologies(dot)com> 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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Guido Barosio 2006-02-13 12:35:40 Re: How to VACUUM this table? "998994633 estimated total rows"
Previous Message Tsirkin Evgeny 2006-02-13 08:45:47 Re: Ancient messages regurgitated into pgsql-admin, again