Re: psql: Add \dL to show languages
От
Andreas Karlsson
Тема
Re: psql: Add \dL to show languages
Дата
Msg-id
1295375744.29248.32.camel@jansson
Ответ на
Re: psql: Add \dL to show languages (Josh Kupershmidt)
Список
Дерево обсуждения
psql: Add \dL to show languages Josh Kupershmidt <schmiddy@gmail.com>
Re: psql: Add \dL to show languages Andreas Karlsson <andreas@proxel.se>
Re: psql: Add \dL to show languages Josh Kupershmidt <schmiddy@gmail.com>
Re: psql: Add \dL to show languages Andreas Karlsson <andreas@proxel.se>
Re: psql: Add \dL to show languages Josh Kupershmidt <schmiddy@gmail.com>
Re: psql: Add \dL to show languages Andreas Karlsson <andreas@proxel.se>
Re: psql: Add \dL to show languages Josh Kupershmidt <schmiddy@gmail.com>
Re: psql: Add \dL to show languages Andreas Karlsson <andreas@proxel.se>
Re: psql: Add \dL to show languages Robert Haas <robertmhaas@gmail.com>
Re: psql: Add \dL to show languages Josh Kupershmidt <schmiddy@gmail.com>
Re: psql: Add \dL to show languages Robert Haas <robertmhaas@gmail.com>
Re: psql: Add \dL to show languages Magnus Hagander <magnus@hagander.net>
Re: psql: Add \dL to show languages Robert Haas <robertmhaas@gmail.com>
Re: psql: Add \dL to show languages Josh Kupershmidt <schmiddy@gmail.com>
Re: psql: Add \dL to show languages Robert Haas <robertmhaas@gmail.com>
Re: psql: Add \dL to show languages Magnus Hagander <magnus@hagander.net>
Re: psql: Add \dL to show languages Peter Eisentraut <peter_e@gmx.net>
Re: psql: Add \dL to show languages David Fetter <david@fetter.org>
Re: psql: Add \dL to show languages Bruce Momjian <bruce@momjian.us>
Re: psql: Add \dL to show languages Andreas Karlsson <andreas@proxel.se>
Re: psql: Add \dL to show languages Robert Haas <robertmhaas@gmail.com>
Re: psql: Add \dL to show languages Josh Kupershmidt <schmiddy@gmail.com>
Re: psql: Add \dL to show languages Robert Haas <robertmhaas@gmail.com>
Hi Josh, Nope, I do not have any better ideas than "DO Blocks?". Everything looks good with the exception one bug now. \dL foo ********* QUERY ********** SELECT l.lanname AS "Name", pg_catalog.pg_get_userbyid(l.lanowner) as "Owner", l.lanpltrusted AS "Trusted" FROM pg_catalog.pg_language lWHERE l.lanname ~ '^(foo)$' ORDER BY 1; ************************** ERROR: syntax error at or near "l" LINE 4: FROM pg_catalog.pg_language lWHERE l.lanname ~ '^(foo)$' I believe the fix is to move \n from before the WHERE clause to after the FROM, and from before ORDER BY to after WHERE. Fix this bug and I believe this patch is ready for a committer. PS. You added some trailing withspace after printACLColumn, A recommendation if you want to avoid it is to either have a git commit hook which checks for that and/or have colouring of git diffs so you can see it marked in red. I use both. :) Andreas
В списке pgsql-hackers по дате отправления