Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Constraint or index or both?



Hi developers! Hi Dave!

Testing 1.6.1 rev: 5646:5664M, client Win XP. Host Debian Sarge, PG 8.1.4

I noticed that primary key and unique constraints (both create an index) are listed twice in the object tree, under "Indexes" and "Constraints". In 1.4.3 those were only listed under "Constraints". I think you changed it when fixing the refresh.
It makes sense in a way, but is it on purpose?

ALTER TABLE test ADD CONSTRAINT test_pkey PRIMARY KEY(test_id);
ALTER TABLE test ADD CONSTRAINT test_uni_idx UNIQUE(x, y);

Regards
Erwin



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group