Re: Open items - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Open items
Date
Msg-id 23244.1091546307@sss.pgh.pa.us
Whole thread Raw
In response to Re: Open items  ("Greg Sabino Mullane" <greg@turnstep.com>)
Responses Re: Open items  (Jonathan Gardner <jgardner@jonathangardner.net>)
List pgsql-hackers
"Greg Sabino Mullane" <greg@turnstep.com> writes:
> Second, Jan promised at OSCON to fix up server-side prepare so it actually
> works even if you do not have the exact types to pass in. I presume you
> will then be able to do something like this:
> PREPARE mystatement AS SELECT * FROM pg_class WHERE relanem = $1
> which will make driver writers very, very happy.

Why would a driver writer care?  He can use the Prepare protocol
message, which already can do the above --- and more to the point,
there's already a way for him to *find out* what types were resolved.
There is no way for the SQL-level PREPARE command to provide info
about how types were resolved, so I'm not in favor of hacking the
SQL command this way.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Unicode restriction
Next
From: Tom Lane
Date:
Subject: Re: Two questions about savepoints: Bug or feature?