Re: FWD: Re: Updated backslash consistency patch

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: 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>, Stephen Frost <sfrost(at)snowman(dot)net>, "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-21 20:10:10
Message-ID: 603c8f070901211210x1433b95di4dd356ebb69d4444@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Here are the items I think are best to default to user-only:
[...]
> Here are the ones that should include system objects by default:

Well, at a minimum, I think it's important for any type of object to
have an easy way to exclude system objects, because "show me all of
the stuff that didn't come with the database" is a valid use case for
any type of item.

It's certainly true that the more obscure the item is, the more likely
you are to be looking for the system object rather than a user object.
But it's really subjective where to put the line: some people might
put it between table and function (Tom), others might put it between
function and aggregate (Bruce), and still others might say there's no
object type so exotic that I don't want system objects excluded by
default (me). And there isn't any right or wrong answer here: it's
just opinions.

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.

...Robert

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2009-01-21 20:17:02 Re: reducing statistics write overhead
Previous Message Heikki Linnakangas 2009-01-21 19:45:50 Re: Pluggable Indexes