Re: Information/schema hiding... - Mailing list pgsql-hackers

From Neil Conway
Subject Re: Information/schema hiding...
Date
Msg-id 1081723823.17216.6.camel@tokyo
Whole thread Raw
In response to Information/schema hiding...  (Sean Chittenden <sean@chittenden.org>)
Responses Re: Information/schema hiding...
List pgsql-hackers
On Sun, 2004-04-11 at 17:10, Sean Chittenden wrote:
> Should information hiding be done in psql(1) or should this be managed
> by the backend and all logic kept out of psql(1)?

If the intent of this feature is security, it seems totally pointless to
implement it in psql (leaving aside whether it's actually a good idea or
not).

[ WRT to search_path and nonexistent schemas ]

> > Why is that needed?  It's already a no-op AFAIR.  It also is
> > incompatible with the existing behavior, in which nonexistent schemas
> > (think "$user") are dropped silently rather than noisily.
> 
> Actually, $user still works..

I think the more important question is: "Why is that needed?"

(Consider the PATH environmental var, which is fairly analogous to
search_path -- that doesn't complain if you add nonexistent directories
to it.)

-Neil




pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Information/schema hiding...
Next
From: Mark Kirkwood
Date:
Subject: Re: PostgreSQL configuration