renameatt() can rename attribute of index, sequence, ...

From: KaiGai Kohei <kaigai(at)ak(dot)jp(dot)nec(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: renameatt() can rename attribute of index, sequence, ...
Date: 2010-03-03 02:19:27
Message-ID: 4B8DC72F.3050600@ak.jp.nec.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Is it an expected behavior?

postgres=> CREATE SEQUENCE s;
CREATE SEQUENCE
postgres=> ALTER TABLE s RENAME sequence_name TO abcd;
ALTER TABLE

postgres=> CREATE TABLE t (a int primary key, b text);
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "t_pkey" for table "t"
CREATE TABLE
postgres=> ALTER TABLE t_pkey RENAME a TO xyz;
ALTER TABLE

The documentation says:
http://developer.postgresql.org/pgdocs/postgres/sql-altertable.html

:
RENAME
The RENAME forms change the name of a table (or an index, sequence, or view) or
the name of an individual column in a table. There is no effect on the stored data.

It seems to me the renameatt() should check relkind of the specified relation, and
raise an error if relkind != RELKIND_RELATION.

--
KaiGai Kohei <kaigai(at)ak(dot)jp(dot)nec(dot)com>

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-03-03 02:22:50 Re: renameatt() can rename attribute of index, sequence, ...
Previous Message Andrew Dunstan 2010-03-03 02:00:03 Re: plperl _init settings