Skip site navigation (1) Skip section navigation (2)

Re: [COMMITTERS] pgsql: Sequences were not being shown due to the use of lowercase `s`

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [COMMITTERS] pgsql: Sequences were not being shown due to the use of lowercase `s`
Date: 2006-09-04 22:46:36
Message-ID: 13928.1157409996@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
"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

Responses

pgsql-hackers by date

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

pgsql-committers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group