Postgres Pro
Downloads
Home   >   mailing lists

BUG #15087: ALTER INDEX RENAME renames table if matches - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #15087: ALTER INDEX RENAME renames table if matches
Date
Msg-id 151960070775.21248.1471444285595717214@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #15087: ALTER INDEX RENAME renames table if matches  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      15087
Logged by:          Ezequiel Tolnay
Email address:      etolnay@gmail.com
PostgreSQL version: 10.0
Operating system:   Windows 10
Description:

A table name mytable can be renamed to newtable via:

ALTER INDEX mytable RENAME TO newtable

This is probably incorrect. It should either raise an error (as it does with
ALTER TABLE if the name supplied is that of an index), or better, when
specified IF EXISTS, simply do nothing.

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15086: Arrow keys do not work while using psql through SSHsession
Next
From: Tomas Vondra
Date:
Subject: Re: BUG #15087: ALTER INDEX RENAME renames table if matches