Re: Doc patch for create index - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: Doc patch for create index
Date
Msg-id 200704032239.l33Md6X23536@momjian.us
Whole thread Raw
In response to Doc patch for create index  (stark <stark@enterprisedb.com>)
List pgsql-patches
Patch applied.  Thanks.  Your documentation changes can be viewed in
five minutes using links on the developer's page,
http://www.postgresql.org/developer/testing.


---------------------------------------------------------------------------


stark wrote:
>
>
> A doc patch to add an example of what an invalid index looks like in psql, as
> requested by a commenter and Bruce.
>
>
>
> Index: doc/src/sgml/ref/create_index.sgml
> ===================================================================
> RCS file: /home/stark/src/REPOSITORY/pgsql/doc/src/sgml/ref/create_index.sgml,v
> retrieving revision 1.60
> diff -c -r1.60 create_index.sgml
> *** doc/src/sgml/ref/create_index.sgml    31 Jan 2007 23:26:03 -0000    1.60
> --- doc/src/sgml/ref/create_index.sgml    3 Apr 2007 17:19:25 -0000
> ***************
> *** 332,338 ****
>       uniqueness violation in a unique index, the <command>CREATE INDEX</>
>       command will fail but leave behind an <quote>invalid</> index. This index
>       will be ignored for querying purposes because it might be incomplete;
> !     however it will still consume update overhead.  The recommended recovery
>       method in such cases is to drop the index and try again to perform
>       <command>CREATE INDEX CONCURRENTLY</>.  (Another possibility is to rebuild
>       the index with <command>REINDEX</>.  However, since <command>REINDEX</>
> --- 332,352 ----
>       uniqueness violation in a unique index, the <command>CREATE INDEX</>
>       command will fail but leave behind an <quote>invalid</> index. This index
>       will be ignored for querying purposes because it might be incomplete;
> !     however it will still consume update overhead. The <application>psql</>
> !     <command>\d</> command will mark such an <quote>invalid</> index as such:
> !
> ! <programlisting>
> ! postgres=# \d tab
> !        Table "public.tab"
> !  Column |  Type   | Modifiers
> ! --------+---------+-----------
> !  col    | integer |
> ! Indexes:
> !     "idx" btree (col) INVALID
> ! </programlisting>
> !
> !     The recommended recovery
>       method in such cases is to drop the index and try again to perform
>       <command>CREATE INDEX CONCURRENTLY</>.  (Another possibility is to rebuild
>       the index with <command>REINDEX</>.  However, since <command>REINDEX</>
>
>
> --
>   Gregory Stark
>   EnterpriseDB          http://www.enterprisedb.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
>                 http://www.postgresql.org/about/donate

--
  Bruce Momjian  <bruce@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: guc patch: Make variables fall back to default values
Next
From: "FAST PostgreSQL"
Date:
Subject: Re: COPY-able sql log outputs