1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
12
TITLE="PostgreSQL 9.1beta1 Documentation"
13
HREF="index.html"><LINK
16
HREF="sql-commands.html"><LINK
19
HREF="sql-altergroup.html"><LINK
21
TITLE="ALTER LANGUAGE"
22
HREF="sql-alterlanguage.html"><LINK
25
HREF="stylesheet.css"><META
26
HTTP-EQUIV="Content-Type"
27
CONTENT="text/html; charset=ISO-8859-1"><META
29
CONTENT="2011-04-27T21:20:33"></HEAD
35
SUMMARY="Header navigation table"
47
>PostgreSQL 9.1beta1 Documentation</A
57
HREF="sql-altergroup.html"
67
HREF="sql-altergroup.html"
80
TITLE="ALTER LANGUAGE"
81
HREF="sql-alterlanguage.html"
89
TITLE="ALTER LANGUAGE"
90
HREF="sql-alterlanguage.html"
101
NAME="SQL-ALTERINDEX"
111
>ALTER INDEX -- change the definition of an index</DIV
113
CLASS="REFSYNOPSISDIV"
151
>storage_parameter</I
167
>storage_parameter</I
182
> changes the definition of an existing index.
183
There are several subforms:
200
> form changes the name of the index.
201
There is no effect on the stored data.
211
> This form changes the index's tablespace to the specified tablespace and
212
moves the data file(s) associated with the index to the new tablespace.
215
HREF="sql-createtablespace.html"
216
>CREATE TABLESPACE</A
226
>storage_parameter</I
237
> This form changes one or more index-method-specific storage parameters
240
HREF="sql-createindex.html"
243
for details on the available parameters. Note that the index contents
244
will not be modified immediately by this command; depending on the
245
parameter you might need to rebuild the index with
247
HREF="sql-reindex.html"
250
to get the desired effects.
259
>storage_parameter</I
265
> This form resets one or more index-method-specific storage parameters to
266
their defaults. As with <TT
273
might be needed to update the index entirely.
302
> The name (possibly schema-qualified) of an existing index to
315
> The new name for the index.
327
> The tablespace to which the index will be moved.
334
>storage_parameter</I
339
> The name of an index-method-specific storage parameter.
351
> The new value for an index-method-specific storage parameter.
352
This might be a number or a word depending on the parameter.
366
> These operations are also possible using
368
HREF="sql-altertable.html"
374
> is in fact just an alias for the forms
378
> that apply to indexes.
381
> There was formerly an <TT
383
>ALTER INDEX OWNER</TT
385
this is now ignored (with a warning). An index cannot have an owner
386
different from its table's owner. Changing the table's owner
387
automatically changes the index as well.
390
> Changing any part of a system catalog index is not permitted.
401
> To rename an existing index:
403
CLASS="PROGRAMLISTING"
404
>ALTER INDEX distributors RENAME TO suppliers;</PRE
408
> To move an index to a different tablespace:
410
CLASS="PROGRAMLISTING"
411
>ALTER INDEX distributors SET TABLESPACE fasttablespace;</PRE
415
> To change an index's fill factor (assuming that the index method
418
CLASS="PROGRAMLISTING"
419
>ALTER INDEX distributors SET (fillfactor = 75);
420
REINDEX INDEX distributors;</PRE
450
HREF="sql-createindex.html"
453
HREF="sql-reindex.html"
461
SUMMARY="Footer navigation table"
472
HREF="sql-altergroup.html"
490
HREF="sql-alterlanguage.html"
506
HREF="sql-commands.html"
b'\\ No newline at end of file'