Re: [HACKERS] Are we losing momentum? - Mailing list pgsql-patches

From Sean Chittenden
Subject Re: [HACKERS] Are we losing momentum?
Date
Msg-id 20030421211755.GW79923@perrin.int.nxad.com
Whole thread Raw
In response to Re: [HACKERS] Are we losing momentum?  (Rod Taylor <rbt@rbt.ca>)
List pgsql-patches
> 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.

Anyone other than Rod (and now myself) had a chance to look this over?
This doesn't really address the lack of a SHOW syntax for new MySQL
users, but it sure does open up the possibilities for making it easier
to probe the backend.

On a related note, any thoughts on the SHOW stuff given that the topic
has come back to life on -hackers?  -sc

--
Sean Chittenden

Attachment

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] rename/unlink handling for Win32
Next
From: Alvaro Herrera
Date:
Subject: Re: Nested transactions, 1st try