Re: TODO item: list prepared queries - Mailing list pgsql-patches

From Neil Conway
Subject Re: TODO item: list prepared queries
Date
Msg-id 43BB01FD.4000704@samurai.com
Whole thread Raw
In response to Re: TODO item: list prepared queries  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: TODO item: list prepared queries
List pgsql-patches
Tom Lane wrote:
> In practice, any given application will probably use one method to the
> exclusion of the other, and wouldn't notice the "inconsistency" anyway.
> If you are using both methods of preparing statements for some reason,
> it's not improbable that you would want to know which way a given
> statement was created, and seeing the PREPARE in there would be a useful
> cue.

The "from_sql" field of the view is an infinitely better way to
determine the source of the prepared statement.

Anyway, if there was a reasonably cheap way to present the query strings
of protocol-level and SQL prepared statements in the same manner, I
think we should definitely do so. Since there doesn't appear to be one,
I'm content to just use the query string as sent by the user. I'll post
a revised patch that does that soon.

-Neil

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: TODO item: list prepared queries
Next
From: Tom Lane
Date:
Subject: Re: pgcrypto: bug in gen_salt (md5/xdes)