Re: Parsed Query Trees

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Parsed Query Trees
Дата
Msg-id 6895.1194319534@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Parsed Query Trees  (Oliver Jowett <oliver@opencloud.com>)
Ответы Re: Parsed Query Trees  (Kevin Neufeld <kneufeld@refractions.net>)
Список pgsql-jdbc
Oliver Jowett <oliver@opencloud.com> writes:
> Kevin Neufeld wrote:
>> Does anyone know if a parsed query tree object is exposed in the jdbc
>> API?  I couldn't find any such thing, nor could I find it in the
>> developers roadmap.

> No, and the reason is that the JDBC driver doesn't actually parse the
> query beyond some basic manipulations to find parameter placeholders and
> so on. All the real parsing happens on the server side, and I don't know
> of a way to get access to the server's query tree as a client. (It's
> debatable how useful that would be, anyway)

I'd very strongly resist exposing the server's parsetrees to clients,
because then changing them would represent a protocol break, and we
change them constantly.

If you're desperate to have an editing facility like this, put it into
server-side code ... and expect to revise it at every major release.

            regards, tom lane

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: "Andres Olarte"
Дата:
Сообщение: How to get the SQL query from a PreparedStatement?
Следующее
От: Kevin Neufeld
Дата:
Сообщение: Re: Parsed Query Trees