"Greg Sabino Mullane" <greg(at)turnstep(dot)com> writes:
> Tom Lane replied:
>> What became of my objection that the test should be on USAGE privilege
>> for the containing schema instead?

> I took a stab at implementing this, but what exactly would we check? Looks
> like all the temp tables have automatic usage for the same user, according to

> 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.

			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 22:36:47 from Greg Sabino Mullane

Responses

• 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

pgsql-hackers by date

Next:	From: Tom Lane	Date: 2006-09-04 22:51:50
	Subject: Erratic failures on buildfarm member leveret
Previous:	From: Tom Lane	Date: 2006-09-04 22:41:06
	Subject: Re: [COMMITTERS] pgsql: sslinfo contrib module - information about current SSL

pgsql-committers by date

Next:	From: User Turnstep	Date: 2006-09-04 23:00:29
	Subject: press - pr: Remvoe city ambiguity, add note on current advocacy quote
Previous:	From: Tom Lane	Date: 2006-09-04 22:41:06
	Subject: Re: [COMMITTERS] pgsql: sslinfo contrib module - information about current SSL