From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Sean Chittenden <sean@chittenden.org>
Cc: Curt Sampson <cjs@cynic.net>
Cc: Brent Verner <brent@rcfile.org>
Cc: pgsql-patches@postgresql.org
Subject: Re: [HACKERS] Are we losing momentum?
Date: Sat, 31 May 2003 12:49:00 -0400
Message-ID: <20930.1054399740@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.LNX.4.44.0305311754110.6382-100000@peter.localdomain>
References: <Pine.LNX.4.44.0305311754110.6382-100000@peter.localdomain>
Peter Eisentraut <peter_e@gmx.net> writes:
> Bruce Momjian writes:
>> Where do we want to go with this? It is interesting that it maps MySQL
>> SHOW commands on top of our existing SHOW syntax in psql. The patch
>> doesn't look too big.
> The response to "Are we losing momentum?" isn't to add redundant syntax
> for nonstandard features that we have no control over.
I'm of two minds about it myself. I don't like trying to play follow-the-
leader with a moving target. But if you think of it as trying to win
over converts from MySQL, it seems a lot more palatable.
It would also be interesting to combine this with Rod's idea of driving
describe-type queries by table instead of hardwired code. Imagine that
the backend's "show foo" command first looks for "foo" as a GUC
variable, as it does now, but upon failing to find one it looks in a
system table for a query associated with the name "foo". If it finds
such a query, it runs it and sends back the result. Now, not only can
we emulate "show tables", but people can easily add application-specific
"show whatever" commands, which seems tremendously cool.
There are some safety and protection issues to be solved here (probably
only superusers should be allowed to modify the query table, and we
should restrict the form of the query to be a single SELECT command)
but I can't think of any showstoppers. Now that we've abandoned backend
autocommit there are no technical reasons that SHOW shouldn't be allowed
to run a SELECT query.
I did not care for the original patch (which IIRC made psql recognize
"show" commands, rather than doing it in the backend) but something like
the above seems reasonably clean.
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-hackers@postgresql.org
Cc: tgl@sss.pgh.pa.us, peter_e@gmx.net, pgman@candle.pha.pa.us, sean@chittenden.org, cjs@cynic.net, brent@rcfile.org, pgsql-patches@postgresql.org
Subject: Re: [HACKERS] Are we losing momentum?
In-Reply-To: <20930.1054399740@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