Re: [HACKERS] psql \l to accept patterns

2013-03-03 Thread Peter Eisentraut
On Wed, 2013-01-30 at 00:20 +0900, Satoshi Nagayasu wrote: > It seems working well with the latest git master. > I think it's good enough to be committed. Committed, thanks. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.

Re: [HACKERS] psql \l to accept patterns

2013-01-29 Thread Tom Lane
Satoshi Nagayasu writes: > First of all, I was looking for some regression tests for > CREATE/ALTER/DROP DATABASE commands, but I couldn't find them > in the test/regress/sql/ directory. So, I asked the question. > I guess these database tests are in pg_regress.c. Right? Yeah, we don't bother wi

Re: [HACKERS] psql \l to accept patterns

2013-01-29 Thread Satoshi Nagayasu
(2013/01/30 0:34), Tom Lane wrote: > Satoshi Nagayasu writes: >>> On Mon, 2013-01-07 at 07:14 -0500, Peter Eisentraut wrote: Here is a patch for psql's \l command to accept patterns, like \d > >> BTW, is there any good place to put new regression test for the psql >> command? I couldn't find

Re: [HACKERS] psql \l to accept patterns

2013-01-29 Thread Tom Lane
Satoshi Nagayasu writes: >> On Mon, 2013-01-07 at 07:14 -0500, Peter Eisentraut wrote: >>> Here is a patch for psql's \l command to accept patterns, like \d > BTW, is there any good place to put new regression test for the psql > command? I couldn't find it out. As far as a test for this specifi

Re: [HACKERS] psql \l to accept patterns

2013-01-29 Thread Satoshi Nagayasu
Hi, I have tried this patch. https://commitfest.postgresql.org/action/patch_view?id=1051 2013/01/29 14:48, Peter Eisentraut wrote: On Mon, 2013-01-07 at 07:14 -0500, Peter Eisentraut wrote: Here is a patch for psql's \l command to accept patterns, like \d commands do. While at it, I also add

Re: [HACKERS] psql \l to accept patterns

2013-01-28 Thread Peter Eisentraut
On Mon, 2013-01-07 at 07:14 -0500, Peter Eisentraut wrote: > Here is a patch for psql's \l command to accept patterns, like \d > commands do. While at it, I also added an "S" option to show system > objects and removed system objects from the default display. This might > be a bit controversial,

Re: [HACKERS] psql \l to accept patterns

2013-01-11 Thread Stephen Frost
* Robert Haas (robertmh...@gmail.com) wrote: > On Tue, Jan 8, 2013 at 11:36 PM, Peter Eisentraut wrote: > > Good point. What about the other suggestion about only displaying > > databases by default that you can connect to? > > I would tend not to adopt that suggestion, on the grounds that it ha

Re: [HACKERS] psql \l to accept patterns

2013-01-11 Thread Robert Haas
On Tue, Jan 8, 2013 at 11:36 PM, Peter Eisentraut wrote: > On Mon, 2013-01-07 at 17:37 -0500, Robert Haas wrote: >> If we make the postgres database undroppable, unrenamable, and >> strictly read-only, I will happily support a proposal to consider it a >> system object. Until then, it's no more a

Re: [HACKERS] psql \l to accept patterns

2013-01-08 Thread Peter Eisentraut
On Mon, 2013-01-07 at 17:37 -0500, Robert Haas wrote: > If we make the postgres database undroppable, unrenamable, and > strictly read-only, I will happily support a proposal to consider it a > system object. Until then, it's no more a system object than the > public schema - which, you will note,

Re: [HACKERS] psql \l to accept patterns

2013-01-07 Thread Robert Haas
On Mon, Jan 7, 2013 at 5:14 PM, Peter Eisentraut wrote: > We removed showing system functions and operators from \df and \do > without S. Those are needed all the time. This was controversial at > the time, but it's the way it is now. The definition of "S", I suppose, > is more like "is there a

Re: [HACKERS] psql \l to accept patterns

2013-01-07 Thread Peter Eisentraut
On 1/7/13 3:53 PM, Robert Haas wrote: > On Mon, Jan 7, 2013 at 7:14 AM, Peter Eisentraut wrote: >> > Here is a patch for psql's \l command to accept patterns, like \d >> > commands do. While at it, I also added an "S" option to show system >> > objects and removed system objects from the default

Re: [HACKERS] psql \l to accept patterns

2013-01-07 Thread Tom Lane
Robert Haas writes: > On Mon, Jan 7, 2013 at 7:14 AM, Peter Eisentraut wrote: >> Here is a patch for psql's \l command to accept patterns, like \d >> commands do. While at it, I also added an "S" option to show system >> objects and removed system objects from the default display. This might >>

Re: [HACKERS] psql \l to accept patterns

2013-01-07 Thread Robert Haas
On Mon, Jan 7, 2013 at 7:14 AM, Peter Eisentraut wrote: > Here is a patch for psql's \l command to accept patterns, like \d > commands do. While at it, I also added an "S" option to show system > objects and removed system objects from the default display. This might > be a bit controversial, bu

Re: [HACKERS] psql \l to accept patterns

2013-01-07 Thread Alvaro Herrera
Peter Eisentraut wrote: > Here is a patch for psql's \l command to accept patterns, like \d > commands do. While at it, I also added an "S" option to show system > objects and removed system objects from the default display. This might > be a bit controversial, but it's how it was decided some ti

Re: [HACKERS] psql \l to accept patterns

2013-01-07 Thread Fabrízio de Royes Mello
On Mon, Jan 7, 2013 at 10:14 AM, Peter Eisentraut wrote: > Here is a patch for psql's \l command to accept patterns, like \d > commands do. While at it, I also added an "S" option to show system > objects and removed system objects from the default display. This might > be a bit controversial,

[HACKERS] psql \l to accept patterns

2013-01-07 Thread Peter Eisentraut
Here is a patch for psql's \l command to accept patterns, like \d commands do. While at it, I also added an "S" option to show system objects and removed system objects from the default display. This might be a bit controversial, but it's how it was decided some time ago that the \d commands shou