Re: PGStatement#setPrepareThreshold - Mailing list pgsql-jdbc

From Bruce Momjian
Subject Re: PGStatement#setPrepareThreshold
Date
Msg-id 200608041919.k74JJm728425@momjian.us
Whole thread Raw
In response to Re: PGStatement#setPrepareThreshold  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: PGStatement#setPrepareThreshold  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc
Dave Cramer wrote:
> Bruce,
>
> Doesn't it make more sense to use the statement name ?
>
> If I prepare S_3 as "select * from foo"
>
> then the bind log is going to show me "select * from foo" not S_3
>
> I think in the case of named statements I'd prefer "S_3" however as I
> think about this in the case of unnamed statements I'd prefer the
> "select * from foo"

The bind shows:

     (errmsg("statement: <protocol> <BIND> %s  [PREPARE:  %s]",

The first %s is the statement name, and the second %s is the query.

--
  Bruce Momjian   bruce@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: PGStatement#setPrepareThreshold
Next
From: Tom Lane
Date:
Subject: Re: PGStatement#setPrepareThreshold