Re: [BUGS] BUG #2850: Cannot select from information_schema.schemat

2006-12-21 Thread Bernd Helmle
--On Donnerstag, Dezember 21, 2006 15:47:40 + Tony Marston <[EMAIL PROTECTED]> wrote: The fact that the SQL standard says that the schemata view is supposed to "Identify the schemata in a catalog that are owned by a given user" does not automatically mean that the information can *ONLY* be

Re: [BUGS] BUG #2850: Cannot select from information_schema.schemat

2006-12-21 Thread Tom Lane
"Tony Marston" <[EMAIL PROTECTED]> writes: > If I am logged on as a user other than 'postgres' and I try the query > SELECT * FROM information_schema.schemata > I get no results. Yet if I try the equivalent query > SELECT * FROM pg_namespace > I can see all the available schema names. > Why is the

[BUGS] BUG #2850: Cannot select from information_schema.schemat

2006-12-21 Thread Tony Marston
The following bug has been logged online: Bug reference: 2850 Logged by: Tony Marston Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows XP Description:Cannot select from information_schema.schemat Details: If I am logged on as a user