"Greg Sabino Mullane" <greg(at)turnstep(dot)com> writes:
>>> SELECT *,has_schema_privilege(oid,'USAGE') FROM pg_namespace;

>> Well, if you test it as a superuser, it's going to return TRUE every
>> time.

> Exactly. So I'm not seeing how we can use USAGE as a reliable test for
> the case where a temporary table was created by the same user, but in
> another session.

Superusers can access anything they want to.  What's your point?
The spec says "accessible" ...

			regards, tom lane

In response to

• Re: [COMMITTERS] pgsql: Sequences were not being shown due to the use of lowercase `s` at 2006-09-04 23:49:58 from Greg Sabino Mullane

Responses

• Re: [COMMITTERS] pgsql: Sequences were not being shown due to the use of lowercase `s` at 2006-09-06 23:40:07 from Greg Sabino Mullane

pgsql-hackers by date

Next:	From: Bruce Momjian	Date: 2006-09-05 00:02:52
	Subject: Stressful time
Previous:	From: Gavin Sherry	Date: 2006-09-04 23:57:29
	Subject: Re: [PATCHES] Trivial patch to double vacuum speed

pgsql-committers by date

Next:	From: Bruce Momjian	Date: 2006-09-05 00:13:41
	Subject: pgsql: Update Japanese FAQ.
Previous:	From: Greg Sabino Mullane	Date: 2006-09-04 23:49:58
	Subject: Re: [COMMITTERS] pgsql: Sequences were not being shown due to the use of lowercase `s`