From: Tom Lane <tgl@sss.pgh.pa.us>
To: Neil Conway <neilc@samurai.com>
Cc: David Wheeler <david@wheeler.net>
Cc: pgsql-hackers@postgreSQL.org
Subject: Re: PREPARE and parameter types (Re: [INTERFACES] DBD::PostgreSQL)
Date: Wed, 20 Nov 2002 01:27:45 -0500
Message-ID: <28886.1037773665@sss.pgh.pa.us> (raw)
In-Reply-To: <87u1icixbb.fsf@mailbox.samurai.com>
References: <A3F94BB8-FB12-11D6-93B3-0003931A964A@wheeler.net>
<118.1037638710@sss.pgh.pa.us>
<8765uskg1a.fsf@mailbox.samurai.com>
<28501.1037769895@sss.pgh.pa.us>
<87u1icixbb.fsf@mailbox.samurai.com>
Neil Conway <neilc@samurai.com> writes:
> Fair enough -- although there's a major difference between the
> meta-data stored about tables (which are permanent database objects
> and are typically complex), and prepared statements (which (at
> present) are only stored for the duration of the current connection,
> and are relatively simple: many statements will not have more than a
> couple params). Arguably, the difference is enough to make it
> nonessential that we provide client programmers with that information.
I forgot to point out this: if the client programmer could conveniently
provide that info, we'd not be having this discussion, because he could
just as well include the datatypes in the PREPARE command to meet our
existing syntax. The fact that we are getting complaints about the
syntax is sufficient evidence that it's not always reasonable to expect
client-side code to know the datatypes. (I think this comes mainly from
the fact that client-side code is not monolithic but tends to consist
of multiple layers. Some of those layers may be expected to know
a-priori what datatypes a query involves, but others will not know.)
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, neilc@samurai.com, david@wheeler.net, pgsql-hackers@postgreSQL.org
Subject: Re: PREPARE and parameter types (Re: [INTERFACES] DBD::PostgreSQL)
In-Reply-To: <28886.1037773665@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox