Re: \dt shows table but \d <table> says the table doesn't exist ?
От
David G. Johnston
Тема
Re: \dt shows table but \d <table> says the table doesn't exist ?
Дата
Msg-id
CAKFQuwaL-vb93NB7cFRcLNE_uoUcYAW++r9VGbhnzqWDh4S9FQ@mail.gmail.com
Ответ на
Список
Дерево обсуждения
\dt shows table but \d <table> says the table doesn't exist ? David Gauthier <dfgpostgres@gmail.com>
Re: \dt shows table but \d <table> says the table doesn't exist ? Adrian Klaver <adrian.klaver@aklaver.com>
Re: \dt shows table but \d <table> says the table doesn't exist ? Magnus Hagander <magnus@hagander.net>
Re: \dt shows table but \d <table> says the table doesn't exist ? Adrian Klaver <adrian.klaver@aklaver.com>
Re: \dt shows table but \d <table> says the table doesn't exist ? Tom Lane <tgl@sss.pgh.pa.us>
Re: \dt shows table but \d <table> says the table doesn't exist ? jian he <jian.universality@gmail.com>
Re: \dt shows table but \d <table> says the table doesn't exist ? Tom Lane <tgl@sss.pgh.pa.us>
Re: \dt shows table but \d <table> says the table doesn't exist ? "David G. Johnston" <david.g.johnston@gmail.com>
Re: \dt shows table but \d <table> says the table doesn't exist ? Tom Lane <tgl@sss.pgh.pa.us>
Re: \dt shows table but \d <table> says the table doesn't exist ? Adrian Klaver <adrian.klaver@aklaver.com>
Re: \dt shows table but \d <table> says the table doesn't exist ? "David G. Johnston" <david.g.johnston@gmail.com>
Re: \dt shows table but \d <table> says the table doesn't exist ? Tom Lane <tgl@sss.pgh.pa.us>
Re: \dt shows table but \d <table> says the table doesn't exist ? Magnus Hagander <magnus@hagander.net>
Re: \dt shows table but \d <table> says the table doesn't exist ? Tom Lane <tgl@sss.pgh.pa.us>
Re: \dt shows table but \d <table> says the table doesn't exist ? Isaac Morland <isaac.morland@gmail.com>
Re: \dt shows table but \d <table> says the table doesn't exist ? "David G. Johnston" <david.g.johnston@gmail.com>
Re: \dt shows table but \d <table> says the table doesn't exist ? hubert depesz lubaczewski <depesz@depesz.com>
On Friday, May 3, 2024, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
Have you met people?
I really don’t care enough to try and actually make converts here. It would have been a perfectly justifiable design choice to make our “pattern” matching case-insensitive by default, probably with a case-sensitive mode and no need to hack up quoting rules that are unique to it. It’s a find feature and search benefits from case-insensitivity. There isn’t anything so compelling about the current behavior that it seems like the superior choice. But maybe you are right and I just lack sufficient real-world experience to see things differently.
I also get not wanting to change behavior at this point though I’d welcome a modifier like “*” (like the ~* operator) to enable case-insensitive matching.
David J.
В списке pgsql-general по дате отправления
От: Adrian Klaver
Дата:
От: Tom Lane
Дата: