Re: BUG #13513: Turning a table into a view - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #13513: Turning a table into a view
Date
Msg-id 17598.1437572535@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #13513: Turning a table into a view  (Andres Freund <andres@anarazel.de>)
Responses Re: BUG #13513: Turning a table into a view  (Andres Freund <andres@anarazel.de>)
List pgsql-bugs
Andres Freund <andres@anarazel.de> writes:
> You can probably work around the problem by inserting a VACUUM
> tbl_becoming_view; before the CREATE RULE. IIRC that should "recompute"
> relhastriggers.

Dunno, I think vacuum does update relhasindexes, but there would be no
reason for it to think about relhastriggers.

As you said upthread, this is not considered a supported feature; it's
something we accept in a very narrow set of cases for pg_dump's benefit.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Jaimin Pan
Date:
Subject: Re: [HACKERS] object_classes array is broken, again
Next
From: Andres Freund
Date:
Subject: Re: BUG #13513: Turning a table into a view