Does anyone know the answer to this? I couldn't find it, but it is a good quesiton.
--------------------------------------------------------------------------- James Robinson wrote: > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
