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

create index concurrently docs ...

From: James Robinson <jlrobins(at)socialserve(dot)com>
To: pgsql-docs(at)postgresql(dot)org
Subject: create index concurrently docs ...
Date: 2006-12-06 15:59:48
Message-ID: 5F277D5E-DB72-4BA1-9DFA-175FB749FB21@socialserve.com (view raw or flat)
Thread:
Lists: pgsql-docs
In reading over the caveats regarding create index concurrently, I  
think it'd be nice to see an example of what the return result will  
be if an 'invalid' index is created so a dba who read the docs night  
recognize the error, as well as for searchengine fodder to find out  
what to do real fast if such an error happens to them.

Something around this paragraph in http://www.postgresql.org/docs/ 
current/static/sql-createindex.html#SQL-CREATEINDEX-CONCURRENTLY:

"If a problem arises during the second scan of the table, such as a  
uniqueness violation in a unique index, the CREATE INDEX command will  
fail but leave behind an "invalid" index."

Thanks!
----
James Robinson
Socialserve.com


Responses

pgsql-docs by date

Next:From: Devrim GUNDUZDate: 2006-12-07 06:16:03
Subject: Re: [DOCS] 8.2.0 pdf
Previous:From: Bruce MomjianDate: 2006-12-06 15:46:56
Subject: Re: psql man page error?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group