What command would achieve this? I'm using a somewhat dusty PostgreSql
(6.5.3).
>ALTER TABLE an-index RENAME TO an-index-new-name;
ERROR: TypeRename: type an-index not defined
and there is no ALTER INDEX.
Dave Lebling
----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> ALTER RENAME just changes the name of the given table. If you want to
> rename indexes, use ALTER RENAME to rename them, too.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>