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@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026