| 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: | Whole Thread | Raw Message | 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? |