Skip site navigation (1) Skip section navigation (2)

Re: [BUGS] BUG #5218: Easy strategic feature requests

From: Russell Wallace <russell(dot)wallace(at)gmail(dot)com>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: [BUGS] BUG #5218: Easy strategic feature requests
Date: 2009-11-29 14:31:05
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugspgsql-general
On Sun, Nov 29, 2009 at 1:57 PM, Craig Ringer
<craig(at)postnewspapers(dot)com(dot)au> wrote:
> Rather than implementing SHOW (blah) as wrappers for selects from views in
> the backend, though, IMO it'd make a lot more sense to provide minimal stubs
> that raised an exception telling the user the right way to do it.
> "SHOW TABLES is a MySQL-specific command that isn't part of the SQL standard
> and isn't used by other databases. Please query the SQL-standard
> INFORMATION_SCHEMA instead, or for interactive work use psql's \d command."

And hopefully a URL to a page that gives more details on
INFORMATION_SCHEMA, including the specific commands for the equivalent
of SHOW TABLES etc? Okay, fair enough, that would still provide most
of the benefit.

> In theory, PostgreSQL could be reworked to support changing databases within
> a connection. In practice ... eek. From my minmimal understanding of the
> codebase, enabling a backend to switch databases would require a huge
> overhaul of authentication, backend startup and management, shared memory
> management, and more.

eek indeed! Right, it's definitely not worth that sort of headache. An
error message explaining the situation would provide much of the
benefit for orders of magnitude less cost.

In response to

pgsql-bugs by date

Next:From: Kenaniah CernyDate: 2009-11-29 22:41:20
Subject: Re: BUG #5219: Segfault in to_tsvector
Previous:From: Euler Taveira de OliveiraDate: 2009-11-29 14:09:20
Subject: Re: BUG #5216: pgFouine 1.1 not working correctly, when LC_MESSAGES is "es_ES.UTF-8"

pgsql-general by date

Next:From: Tom LaneDate: 2009-11-29 14:42:35
Subject: Re: Time zone 'GMT+8'
Previous:From: Craig RingerDate: 2009-11-29 13:57:12
Subject: Re: [BUGS] BUG #5218: Easy strategic feature requests

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group