Tom Lane wrote: > Bruce Momjian <bruce@xxxxxxxxxx> writes: > > Tom Lane wrote: > >> Scara Maccai <m_lists@xxxxxxxx> writes: > >>> I got that there should be no difference... plus, I don't get any > >>> errors, > >> > >> You should have. The system enforces (or tries to) that a view can't be > >> part of an inheritance hierarchy, but you seem to have managed to find a > >> sequence of operations that avoids those checks. Turning a table into a > >> view with a manual CREATE RULE operation has always been a kluge, and > >> it's missing a check that the table isn't part of an inheritance tree. > > > Is this a TODO? Seems so. > > I think it's just a minor bugfix, but if you want to put it in TODO for > a day or two, go ahead... That's fine --- I will just push it to the patches queue so we know it is a live issue. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend