pg.ddx.io pgsql-hackers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Rod Taylor <rbt@rbt.ca>
To: Sean Chittenden <sean@chittenden.org>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Peter Eisentraut <peter_e@gmx.net>
Cc: Curt Sampson <cjs@cynic.net>
Cc: Brent Verner <brent@rcfile.org>
Cc: PostgreSQL Patches <pgsql-patches@postgresql.org>
Subject: Re: [HACKERS] Are we losing momentum?
Date: 17 Apr 2003 17:25:15 -0400
Message-ID: <1050614715.99492.33.camel@jester> (raw)
In-Reply-To: <20030417210941.GV79923@perrin.int.nxad.com>
References: <Pine.LNX.4.44.0304162113580.1750-100000@peter.localdomain>
<10266.1050588320@sss.pgh.pa.us>
<20030417194803.GU79923@perrin.int.nxad.com>
<19492.1050609126@sss.pgh.pa.us>
<20030417210941.GV79923@perrin.int.nxad.com>
It's out of date and I did not receive any feedback on it (so I assume
it's not very useful), but the patch submitted in late February would
easily allow the described 'translation' to occur.
Summary:
Schema in backend translates a \<command> <arg> command into an sql
query which is then to be executed. Logic is still in psql, but the
available commands and how data is retrieved from the schema was backend
specific.
I'm using it here due to it's ability to add new psql commands (since
it's just data in a table.)
http://archives.postgresql.org/pgsql-patches/2003-02/msg00216.php
Anyway, might be useful for thoughts. Simply moving the commands into
the backend still leaves us with unsupported new commands in old clients
or new commands in old databases (leaving errors) unless the SHOW ...
syntax itself is handled by the backend.
> :-/ Yeah, I've been following that from a distance and I'm not so wild
> about that. I really like that the information_schema has been
> integrated into the base, but translating the SHOW commands into
> SELECTs from information_schema on the backend seems like a bad idea
> unless its going to be done abstract enough via some kind of rewrite
> engine that allows users to program the database to translate their
> verbiage into SQL (ex: KILL -> DROP, GET -> SELECT), which could be
> kinda fun.
--
Rod Taylor <rbt@rbt.ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
Attachments:
signature.asc (application/pgp-signature, 186B) download
view thread (140+ messages) latest in thread
Message-ID: <1050614715.99492.33.camel@jester> Permalink: ../1050614715.99492.33.camel@jester/ Also on: postgresql.org/message-id/1050614715.99492.33.camel@jester ·
reply
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: rbt@rbt.ca, sean@chittenden.org, tgl@sss.pgh.pa.us, peter_e@gmx.net, cjs@cynic.net, brent@rcfile.org, pgsql-patches@postgresql.org Subject: Re: [HACKERS] Are we losing momentum? In-Reply-To: <1050614715.99492.33.camel@jester> * 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