Re: Parsing speed (was Re: pgstats_initstats() cost) - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Parsing speed (was Re: pgstats_initstats() cost)
Date
Msg-id 20030813215910.X30109-100000@houston.familyhealth.com.au
Whole thread Raw
In response to Re: Parsing speed (was Re: pgstats_initstats() cost)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Parsing speed (was Re: pgstats_initstats() cost)
List pgsql-hackers
> > Wait just a minute!  phpPgAdmin would love to be able to 'parse' arbitrary
> > sql entered by the user to separate semi-coloned queries, identify various
> > types of queries, etc.  What would a Parse call allow us to do?
>
> Hm.  I was about to say "very little that you can't do with a PREPARE",
> but if you don't want to even count semicolons then Parse would be
> distinctly safer.  For example if the string is
>     SELECT * FROM foo; UPDATE foo SET ...
> then sticking a PREPARE in front would not have the desired effect ---
> but sending it in a Parse message would result in a syntax error.
> Not sure if that helps you get to your goal though.

What do you actually get back from a Parse request?

Chris




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.4 LOG: invalid message length
Next
From: Tom Lane
Date:
Subject: Re: set constraints docs page