Re: FWD: Re: Updated backslash consistency patch

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

In response to

Browse pgsql-hackers by date

  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