Re: multi-backend psql - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: multi-backend psql
Date
Msg-id 1066789394.74834.4.camel@jester
Whole thread Raw
In response to Re: multi-backend psql  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: multi-backend psql  (Andreas Pflug <pgadmin@pse-consulting.de>)
List pgsql-hackers
On Tue, 2003-10-21 at 21:24, Christopher Kings-Lynne wrote:
> > There is always the biggest evil of all... Putting SHOW / DESCRIBE /
> > HELP commands into the backend itself. I'm sure the pgAdmin group likes
> > that idea (they're probably tired of maintaining 4 different versions of
> > queries for getting a list of tables). Any solution to make psql
> > backward or forward compatible should go an additional step to assist
> > other frontends as well.
>
> All that means for phpPgAdmin and pgAdmin is that we'll have to support
> 5 different queries :P

Yes, but I would hope it stops at 5, and over the next 3 years you don't
have 10 different query forms.

> We could use information_schema...

Nay... I would expect a PostgreSQL specific information_schema to get
just as much mucking around as the system tables, which means you are
still maintaining a set of queries per release.

pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: 7.4 compatibility question
Next
From: Tom Lane
Date:
Subject: Re: 7.4 compatibility question