Thread: Bug with ALTER TABLE

I've discovered a bug in ALTER TABLE behaviour when it comes to
renaming a view.

I'm not sure if renaming a view is supported but Postgres will let you
do it with ALTER TABLE aview RENAME TO aview2; SELECT operations still
work on the resulting view after this command but a dump or \d aview2
will now print out :

oldplumbing=# \d t
                 View "t"
 Attribute  |       Type        | Modifier
------------+-------------------+----------
 ?column?   | text              |
 address    | character varying |
 builder    | character varying |
 subdiv     | character varying |
 plan_#     | character varying |
 sched_date | date              |
 plan_id    | integer           |
View definition: Not a view

This is obviously not correct.

--
chalk slayer

* Ashley Clark in "Bug with ALTER TABLE" dated 2001/08/08 13:48 wrote:

<snip>

Duh, forgot the version #

                           version
-------------------------------------------------------------
 PostgreSQL 7.1 on i686-pc-linux-gnu, compiled by GCC 2.95.2

--
chalk slayer

Ashley Clark <aclark@ghoti.org> writes:
> I've discovered a bug in ALTER TABLE behaviour when it comes to
> renaming a view.

I've committed a fix for this.

            regards, tom lane