Re: Query preparation - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Query preparation
Date
Msg-id 49E5DD02.2060909@opencloud.com
Whole thread Raw
In response to Re: Query preparation  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: Query preparation
List pgsql-jdbc
Heikki Linnakangas wrote:

> Does anyone see a problem with caching the result set descriptor
> (RowDescription)? AFAICS it should never change after a statement is
> prepared. If not, I'll polish up and submit the patch.

If you tie it to the existing named statement mechanisms I think that
works. We invalidate the named statement anyway if the parameter types
change, and you want to invalidate any cached row description at the
same time. Schema changes could bite you, but I think they bite named
statements in other ways anyway. (Not sure how far the server-side
efforts to do plan invalidation progressed)

-O

pgsql-jdbc by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Query preparation
Next
From: Tom Lane
Date:
Subject: Re: Query preparation