Home > mailing lists

problems viewing information_schema.schemata - Mailing list pgsql-general

From	Little, Douglas
Subject	problems viewing information_schema.schemata
Date	July 27, 2011 16:59:23
Msg-id	8585BA53443004458E0BAA6134C5A7FB6BF348B0@EGEXCMB01.oww.root.lcl Whole thread Raw
Responses	Re: problems viewing information_schema.schemata (sqldbxdeveloper <xolopivo@hotmail.com>)
List	pgsql-general

Hi,

Some of my users are using sqldbx and it’s not working due to a dependence on displaying the content of information_schema.schemata

When I query the view I see content. When they do it, nothing – 0 rows – from sqldbx, pgadmin or other client.

I suspect that they don’t have access to a catalog table, but can’t find it.

What is the definition for schemata?

Thanks

Doug Little

Sr. Data Warehouse Architect | Business Intelligence Architecture | Orbitz Worldwide

500 W. Madison, Suite 1000 Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741

From: Ioana Danes
Date: 27 July 2011, 16:34:28
Subject: error when compiling a c function

From: Jaime Casanova
Date: 27 July 2011, 17:47:26
Subject: Re: repmgr problem with registering standby