Skip site navigation (1) Skip section navigation (2)

TODO item: list prepared queries

From: Joachim Wieland <joe(at)mcknight(dot)de>
To: pgsql-patches(at)postgresql(dot)org
Subject: TODO item: list prepared queries
Date: 2005-12-12 09:56:09
Message-ID: 20051212095609.GA2003@mcknight.de (view raw or flat)
Thread:
Lists: pgsql-patches
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

Responses

pgsql-patches by date

Next:From: Peter EisentrautDate: 2005-12-12 11:32:09
Subject: Re: TODO item: list prepared queries
Previous:From: Simon RiggsDate: 2005-12-12 09:50:45
Subject: Re: running script on server shutdown (TODO)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group