[HACKERS] Re: Privileges for INFORMATION_SCHEMA.SCHEMATA (was Re: [DOCS] Small clarification in 34.41. schemata)
On Wed, Jan 9, 2013 at 8:56 PM, Tom Lane t...@sss.pgh.pa.us wrote: However, it seems to me that this behavior is actually wrong for our purposes, as it represents a too-literal reading of the spec. The SQL standard has no concept of privileges on schemas, only ownership. We do have privileges on schemas, so it seems to me that the consistent thing would be for this view to show any schema that you either own or have some privilege on. IMHO, schemata should follow the standard as it does today. Other platforms have privileges on schemas as well, and this sort of thing seems to fall into the same bucket as other platform compatibilities outside the scope of what the standard thinks about, which means you use pg_catalog to access that information rather than information_schema, which should be expected to work consistently on all platforms that implement it. -- Casey Allen Shobe ca...@shobe.info
[HACKERS] Reproducible relcache reference leak
When I first log in to psql as a superuser, the first time I try to use lo_export (), I get a reference leak warning. This does not happen on subsequent attempts. However I can log out and log back in, and see the error again the first time I execute the query. Detail follows. Please CC responses, I'm not on the list. user [EMAIL PROTECTED]:/home/cshobe $ psql -U postgres osss Welcome to psql 8.0.0beta2, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit osss=# select lo_export (stelpa.images.image, '/tmp/osss.test.png') from stelpa.images; WARNING: relcache reference leak: relation pg_largeobject has refcnt 1 instead of 0 WARNING: relcache reference leak: relation pg_largeobject_loid_pn_index has refcnt 1 instead of 0 lo_export --- 1 (1 row) osss=# select lo_export (stelpa.images.image, '/tmp/osss.test.png') from stelpa.images; lo_export --- 1 (1 row) -- Casey Allen Shobe | http://casey.allen.shobe.info [EMAIL PROTECTED] | ICQ: 1494523 | AIM: SomeLinuxGuy ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org