Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
Search
Recent Topics
Hottest Topics
Member Listing
Back to home page
PostgresStudio not showing implicitly created indexes
Forum Index
»
Advanced Server
Author
Message
15 Mar 2010 16:19:09
Subject:
PostgresStudio not showing implicitly created indexes
null
Member
Joined: 2 Apr 2008 17:21:41
Messages: 78
Offline
When a primary constraint is created, an index is automatically created (as expected). The index shows up correctly in the data dictionary, but does not show up in Postgres Studio.
create table tab1 (col1 varchar2(200));
ALTER TABLE tab1 ADD CONSTRAINT tab1_pk PRIMARY KEY (col1);
select index_name from user_indexes where table_name='TAB1';
18 Mar 2010 14:31:38
Subject:
Re:PostgresStudio not showing implicitly created indexes
Don_Drake
New member
Joined: 15 Mar 2010 15:01:11
Messages: 3
Offline
I to find this really annoying. It's a pgAdmin problem, though.
The index can be found under Constraints though.
-Don
This message was edited 1 time. Last update was at 18 Mar 2010 14:32:06
Forum Index
»
Advanced Server
Go to:
Select a forum
News & Announcements
Website Issues
Postgres Plus Cloud Database
Postgres Enterprise Manager
Advanced Server
Standard Server
Postgres Plus AMIs with Amazon EC2
GridSQL - General
GridSQL - Developers
PostgreSQL Installers for Windows, Linux and OS X
Tuning and Migration Wizard
ApachePHP and application Installers
Powered by
JForum 2.1.8
©
JForum Team