Bug with ALTER TABLE

From: Ashley Clark <aclark(at)ghoti(dot)org>
To: Postgres General List <pgsql-general(at)postgresql(dot)org>
Subject: Bug with ALTER TABLE
Date: 2001-08-08 18:48:55
Message-ID: 20010808134855.A15060@ghoti.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ashley Clark 2001-08-08 18:53:36 Re: Bug with ALTER TABLE
Previous Message Bruce Momjian 2001-08-08 18:41:18 Off Topic: Blocking Spam

Browse pgsql-hackers by date

  From Date Subject
Next Message Ashley Clark 2001-08-08 18:53:36 Re: Bug with ALTER TABLE
Previous Message Marc G. Fournier 2001-08-08 18:07:50 Re: To be 7.1.3 or not to be 7.1.3?