Postgres Pro
Downloads
Home   >   mailing lists

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

From Joachim Wieland
Subject TODO item: list prepared queries
Date
Msg-id 20051212095609.GA2003@mcknight.de
Whole thread Raw
Responses Re: TODO item: list prepared queries  (Peter Eisentraut <peter_e@gmx.net>)
Re: TODO item: list prepared queries  (Neil Conway <neilc@samurai.com>)
Re: TODO item: list prepared queries  (Neil Conway <neilc@samurai.com>)
List pgsql-patches
Tree view 
Hi,

I propose the attached patch for the TODO item:

* %Allow pooled connections to list all prepared queries

The patch adds a new SRF and a new view that contain all prepared queries
available in the session.
Besides the name of the plan and the actual query the view also displays
the timestamp of the preparation. This can help applications decide whether
or not they want to replan an existing prepared query.


Joachim
Attachment

pgsql-patches by date:

Previous
From: Simon Riggs
Date:
Subject: Re: running script on server shutdown (TODO)
Next
From: Peter Eisentraut
Date:
Subject: Re: TODO item: list prepared queries