Re: [GENERAL] Bug with ALTER TABLE

I an confirm this is a bug. The line:

> View definition: Not a view

is the incorrect part.

Checking application/pgp-signature: FAILURE
-- Start of PGP signed section.
> 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
-- End of PGP section, PGP failed!

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026