EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

PostgresStudio not showing implicitly created indexes  XML

Forum Index » Advanced Server
Author Message
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';

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:   
Powered by JForum 2.1.8 © JForum Team