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

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

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: 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:36:47
Message-ID: 66ff0cbe1bf948aed11d09e77cc7d62e@biglumber.com (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


I wrote:
> Sequences were not being shown due to the use of lowercase 's' instead
> of 'S', and the views were not checking for table visibility with
> regards to temporary tables and sequences.

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;

So I'd need another way to test that the schema was created by another process.
I agree that is_visible may not be ideal for most cases, but it should be okay
if we are simply using it to filter temporary schemas, right?

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
End Point Corporation
PGP Key: 0x14964AC8 200609041803
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFE/Km6vJuQZxSWSsgRAgkaAKC/Nzc8xIcxRC1TW2UJCB76LurWmgCg+Dkk
4HbMsy4H1uwRAUz9lqCSdXg=
=eBg2
-----END PGP SIGNATURE-----


In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-09-04 22:41:06
Subject: Re: [COMMITTERS] pgsql: sslinfo contrib module - information about current SSL
Previous:From: Alvaro HerreraDate: 2006-09-04 22:22:44
Subject: Re: [COMMITTERS] pgsql: sslinfo contrib module - information about current SSL

pgsql-committers by date

Next:From: Tom LaneDate: 2006-09-04 22:41:06
Subject: Re: [COMMITTERS] pgsql: sslinfo contrib module - information about current SSL
Previous:From: Alvaro HerreraDate: 2006-09-04 22:22:44
Subject: Re: [COMMITTERS] pgsql: sslinfo contrib module - information about current SSL

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