Обсуждение: 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