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

Re: BUG #5218: Easy strategic feature requests

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Russell Wallace <russell(dot)wallace(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5218: Easy strategic feature requests
Date: 2009-11-30 18:06:07
Message-ID: 162867790911301006v6671422cyc93090ec58fe71b1@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-general
2009/11/30 Robert Haas <robertmhaas(at)gmail(dot)com>:
> On Mon, Nov 30, 2009 at 12:28 PM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
>>>
>>> Rather than trying to be compatible with MySQL directly, I think we
>>> might be better off adding a chapter to our documentation explaining
>>> to ex-MySQL users how to accomplish the same things in PostgreSQL.  We
>>> might even think about adding a contrib module with user-defined
>>> functions like show_databases(), show_tables(), describe(text), so
>>> that someone could do SELECT describe('foo'); and get a familiar sort
>>> of output.
>>>
>>
>> I thing so ex-MySQL needs exact DESCRIBE, exact SHOW statement. It is
>> some, what they used long time and then they missing it.
>
> Well, if people aren't willing to make ANY changes to their code or
> habits when porting to a new database, they're likely hosed no matter
> what we do about this particular issue.  That having been said, I
> wouldn't personally strongly object to implementing these commands as
> a convenience for MySQL users, but I suspect others will consider them
> unnecessary warts, which in some sense they are.
>
>> Hypothetically we could have a "super hook" on server side - or hook
>> on psql and we can implement these statements in some contrib module.
>
> With all respect, I think this is quite similar to several things
> you've proposed previously that have been rejected.  At least, I
> believe it suffers from many of the same problems.

I didn't speak about parser hook. This hook could exist on top. And it
can solve similar request. But It isn't my job.

Pavel

>
> ...Robert
>

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2009-11-30 18:25:35
Subject: Re: BUG #5218: Easy strategic feature requests
Previous:From: Robert HaasDate: 2009-11-30 18:02:15
Subject: Re: BUG #5218: Easy strategic feature requests

pgsql-general by date

Next:From: Tom LaneDate: 2009-11-30 18:25:35
Subject: Re: BUG #5218: Easy strategic feature requests
Previous:From: Robert HaasDate: 2009-11-30 18:02:15
Subject: Re: BUG #5218: Easy strategic feature requests

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