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