From: Tom Lane <tgl@sss.pgh.pa.us>
To: Thomas G. Lockhart <lockhart@alumni.caltech.edu>
Cc: pgsql-hackers@postgreSQL.org
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [HACKERS] TCL_ARRAYS code in libpgtcl is pretty seriously broken
Date: Mon, 05 Oct 1998 10:11:51 -0400
Message-ID: <22734.907596711@sss.pgh.pa.us> (raw)
In-Reply-To: <3618195E.6FE14EF6@alumni.caltech.edu>
"Thomas G. Lockhart" <lockhart@alumni.caltech.edu> writes:
> This isn't a definitive answer and there may be another way to discover
> array-ness but it's where I would look. Not sure if you'd be happy
> having to do a select on pg_type for every query unless you're doing it
> already...
I think that won't fly for performance reasons. I know I wouldn't want
my Tcl applications paying an additional frontend-to-backend round trip
for every SELECT result...
I was actually a tad surprised to realize that the column-type info sent
by the backend couldn't answer such a basic question as "is this an
array?". Something to fix if we ever rev the FE/BE protocol again.
Don't think I'd propose a protocol rev just for this, though.
In the meantime, I'm inclined to take the fallback approach I suggested
yesterday: provide the array-to-list reformatting function as a separate
Tcl statement that the application programmer can decide to invoke.
The app writer is likely to know perfectly well where he needs that
feature anyway.
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, lockhart@alumni.caltech.edu, pgsql-hackers@postgreSQL.org
Subject: Re: [HACKERS] TCL_ARRAYS code in libpgtcl is pretty seriously broken
In-Reply-To: <22734.907596711@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