From: | Stephen Frost <sfrost(at)snowman(dot)net> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, Greg Sabino Mullane <greg(at)turnstep(dot)com> |
Subject: | Re: FWD: Re: Updated backslash consistency patch |
Date: | 2009-01-22 02:23:54 |
Message-ID: | 20090122022354.GE32428@tamriel.snowman.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
* Robert Haas (robertmhaas(at)gmail(dot)com) wrote:
> > Here are the items I think are best to default to user-only:
> [...]
> > Here are the ones that should include system objects by default:
[...]
> So maybe we should provide U, S, and A modifiers for every type of
> object (user, system, all). That doesn't solve the problem of which
> should be the default for each object type, but at least it guarantees
> that you can type an extra character to get the behavior you want in
> any particular case.
You know, there's an easy answer to what to set the defaults to, though
it might be a bit cheesy- how about the current behavior? Adding
functionality (+U or +S or whatever) without breaking backwards
compatibility (much).
I'm not a huge fan of having \df still list system functions, but it's
less of an issue if I can just do \dfU when I want. Of course, for a
year or two I'll probably be cursing this thread whenver I pick the
wrong one, but that's life. ;)
In response to a comment earlier- I definitely like the idea of
pre-pending system calls that aren't really 'published' with a 'pg_'.
That probably raises some backwords compatability problems, but I still
think it's a good idea to try and do at some point.
Stephen
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2009-01-22 02:32:26 | Re: FWD: Re: Updated backslash consistency patch |
Previous Message | Bruce Momjian | 2009-01-22 01:29:37 | Re: pg_stats queries versus per-database encodings |