Re: PGStatement#setPrepareThreshold

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Dave Cramer <pg(at)fastcrypt(dot)com>, Oliver Jowett <oliver(at)opencloud(dot)com>, Csaba Nagy <nagy(at)ecircle-ag(dot)com>, Postgres JDBC <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: PGStatement#setPrepareThreshold
Date: 2006-08-04 19:27:34
Message-ID: 14945.1154719654@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc pgsql-patches

Bruce Momjian <bruce(at)momjian(dot)us> writes:
> ! (errmsg("statement: [protocol] <BIND> %s", portal_name)));

> --- 1452,1460 ----
> ! (errmsg("statement: <protocol> <BIND> %s [PREPARE: %s]",
> ! *portal_name ? portal_name : "<unnamed>",
> ! portal->sourceText ? portal->sourceText : "")));

This is getting less readable not more so; and you still haven't got the
prepared statement's name in there, let alone any place to put the
parameter values.

Perhaps we should give up on the idea that this can all fit on one log
line? Maybe

LOG: parse: <statement-name>
DETAIL: statement: <source-text>

LOG: bind: <portal-name> to <statement-name>
DETAIL: statement: <source-text>
parameter 1: <parameter value>
parameter 2: <parameter value>
...

LOG: execute: <portal-name>
DETAIL: statement: <source-text>

The $64 question here is whether we want to repeat the source-text
in all three messages (parse, bind, execute) or try to reduce the
verbosity.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim C. Nasby 2006-08-04 19:28:11 Re: 8.2 features status
Previous Message Jonah H. Harris 2006-08-04 19:26:03 Re: 8.2 features status

Browse pgsql-jdbc by date

  From Date Subject
Next Message Bruce Momjian 2006-08-04 19:42:02 Re: PGStatement#setPrepareThreshold
Previous Message Bruce Momjian 2006-08-04 19:19:48 Re: PGStatement#setPrepareThreshold

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2006-08-04 19:42:02 Re: PGStatement#setPrepareThreshold
Previous Message Bruce Momjian 2006-08-04 19:19:48 Re: PGStatement#setPrepareThreshold