Thread: 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@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
Bruce Momjian <pgman@candle.pha.pa.us> writes: > I an confirm this is a bug. The line: Presumably, ALTER RENAME is forgetting to rename the ON SELECT rule associated with the view. The actual use of the rule is driven by OID-based lookups and isn't affected, but I bet that psql tries to look up the rule by name. regards, tom lane