Re: BUG #2779: Making an inherited table to a view causes could not open relation error in base table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Sven Klemm <sven(at)c3d2(dot)de>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2779: Making an inherited table to a view causes could not open relation error in base table
Date: 2006-11-24 21:58:03
Message-ID: 27119.1164405483@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Tom Lane wrote:
>> Actually, I wonder whether we still need to support conversion of
>> tables to views at all. That was never meant as anything but a
>> temporary hack to allow loading pre-7.1 pg_dump scripts.

> IIRC I tried it when I was reviewing the updatable views patch, and it
> worked.

Well, yeah, it still works for the cases it was intended to work for.
What I'm wondering is what other weird corner cases might need to be
forbidden to keep it secure against people who are looking for ways
to break it.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-11-24 22:06:09 Re: PostgreSQL 8.1.5: regression tests fail on sparc
Previous Message Tom Lane 2006-11-24 21:47:20 Re: BUG #2775: Error select