Re: uppercase = lowercase

Поиск
Список
Период
Сортировка
От Robert Treat
Тема Re: uppercase = lowercase
Дата
Msg-id 1045757758.14509.6.camel@camel
обсуждение исходный текст
Ответ на Re: uppercase = lowercase  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: uppercase = lowercase  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-admin
On Wed, 2003-02-19 at 02:51, Tom Lane wrote:
> Robert Treat <xzilla@users.sourceforge.net> writes:
> > We get this question a lot, usually from folks converting from mysql.
> > Do any of the core folks think this is worth adding to contrib? Or
> > perhaps a project on gborg would be more appropriate?
>
> In the long run, the correct SQL-spec-compliant solution is selectable
> collation for each column, and then you could specify a case-insensitive
> collation for the columns you want to act this way.  But I don't really
> foresee that happening in the near future :-(.  In the meantime, a
> specialized datatype seems like an okay hack.
>
> I'd not favor putting it into the core distribution, because that would
> amount to a commitment to support it indefinitely, which I don't want
> to make.  contrib would be iffy for the same reason --- contrib tends
> to have a subtext of "this might be mainstream someday, if it gets
> polished up".  gborg, no problem.
>
> But that's just my $0.02.  Comments anyone?
>

I tend to agree with this. Perhaps what we need is some type of
meta-howto on converting from mysql to postgresql, which would list
specific places to find articles, custom data types, custom functions,
or code examples that folks might want if they are converting from
mysql. This should probably also be done for other databases as well.
This would give another option to the current debate on supporting
informix syntax on hackers right now, put the patch in a gborg project,
and list it as a resource in an informix meta-howto. Obviously this
could be done for oracle and others.. I know the information is out
there, but it's scattered, and given the number of times we see some of
these questions, needs to be easier to find.

Robert Treat


В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_dumpall
Следующее
От: Ganesan R
Дата:
Сообщение: PANIC: unable to locate a valid checkpoint record