From: | "Greg Sabino Mullane" <greg(at)turnstep(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Cc: | pgsql-patches(at)postgresql(dot)org |
Subject: | Re: Information_schema fixes for sequences and temporary tables |
Date: | 2006-08-19 03:03:46 |
Message-ID: | bd1b9d6f2c613c0d51af08f3776fc820@biglumber.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
> I'd be interested to see you cite chapter and verse in the SQL spec
> where it says that information_schema should hide temp tables of
> other backends. That change seems pretty dubious to me. (More
> likely, we should be adding tests on whether the caller has USAGE
> privilege on the table's containing schema.)
Fair point: what brought this about was someone wondering why a
SELECT 1 FROM information_schema.tables WHERE table_name = 'mytemptable'
returned true but a subsequent DROP TABLE mytemptable; failed.
Another subtle difference between \d and i_s.tables I suppose.
It all depends on how one interprets "accessible" here:
<quote>
Function: [of information_schema.tables]
Identify the tables defined in this catalog that are accessible
to a given user or role.
</quote>
While I might extend "accessible" to schemas outside of a user's search path,
I'm not sure that should include the pg_temp_ ones. Seems confusing for the
user to see other temp tables, even if the schema is returned, as one does not
specify a schema when creating temp tables. +1 on the USAGE idea.
> As for all that ESCAPE junk, consider using regexps instead; they
> play nicer with underscores in patterns.
Hmph. I was just copying the surrounding code, in the theory that it
increases the chance of my patches being accepted. :)
- --
Greg Sabino Mullane greg(at)turnstep(dot)com
End Point Corporation
PGP Key: 0x14964AC8 200608182237
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----
iD8DBQFE5n7EvJuQZxSWSsgRAr9UAKDSXYExsVwsYazS1ygaOCmsudGVpwCeKPHj
1g/fpDkpDdfOr9eGQzr3M9U=
=9QRx
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2006-08-19 04:52:43 | Re: [PATCHES] selecting large result sets in psql using |
Previous Message | Joshua D. Drake | 2006-08-19 02:12:10 | Re: BugTracker (Was: Re: 8.2 features status) |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2006-08-19 04:52:43 | Re: [PATCHES] selecting large result sets in psql using |
Previous Message | Greg Sabino Mullane | 2006-08-19 02:33:21 | Information schema - finalize key_column_usage |