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
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 |
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? |