Search Postgresql Archives

Re: Index names not consistent

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



>  Running postgres 9.0.1 on Solaris 10 (Sparc)

> I am testing a development database before putting it in production. The
application install created the database and the indexes. When I run psql and
list the indexes \di I can count the number of indexes and see the names of the
indexes. If I run

> pg_dump -s databasename | grep INDEX

> I can also count the number of indexes and see the names of the indexes. Both
the number of indexes and the names of the indexes differ when using these two
methods to display index information. Is this normal?

It's really difficult to say with so little detail, but there's
certainly ways that that could happen. pg_dump might create some
indexes with ALTER TABLE ADD CONSTRAINT commands, for example,
rather than syntax using the word INDEX.

regards, tom lane



SOLVED: That was it Tom, thanks for the tip!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux