Thread: Re: [HACKERS] crash on new system views

Bruce Momjian <maillist@candle.pha.pa.us>
>
> > Bruce Momjian <maillist@candle.pha.pa.us>
> >
> > >
> > > This query crashes the backend.  pg_rules is a new system view:
> > >
> > >     BEGIN WORK;
> > >     DECLARE c_matches BINARY CURSOR FOR
> > >     SELECT  count(*)
> > >     FROM    pg_attrdef t1, pg_rules t2
> > >     WHERE   t1.adrelid = t2.oid
> > >     END WORK;
> > >
> > > Partial backtrace is below.  It is crashing in the optimizer.
> >
> > Bruce,
> >
> > I'm getting the same here when testing your query.
> >
> > The odd (maybe not?) thing is that views appear to have
> > a NULL oid for all tuples.
>
> This has always been the case.  Views don't have oid.
>

OK, so we shouldn't be able to select a column called oid from
any view?

Keith.

> > > The odd (maybe not?) thing is that views appear to have
> > > a NULL oid for all tuples.
> >
> > This has always been the case.  Views don't have oid.
> >
>
> OK, so we shouldn't be able to select a column called oid from
> any view?

That's an interesting question.  Do we disallow the query?  Comments?


--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
http://www.op.net/~candle              |  (610) 353-9879(w)
  +  If your life is a hard drive,     |  (610) 853-3000(h)
  +  Christ can be your backup.        |

> > > The odd (maybe not?) thing is that views appear to have
> > > a NULL oid for all tuples.
> >
> > This has always been the case.  Views don't have oid.
> >
>
> OK, so we shouldn't be able to select a column called oid from
> any view?

That's an interesting question.  Do we disallow the query?  Comments?


--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
http://www.op.net/~candle              |  (610) 353-9879(w)
  +  If your life is a hard drive,     |  (610) 853-3000(h)
  +  Christ can be your backup.        |

On Tue, 15 Sep 1998, Bruce Momjian wrote:

> > > > The odd (maybe not?) thing is that views appear to have
> > > > a NULL oid for all tuples.
> > >
> > > This has always been the case.  Views don't have oid.
> > >
> >
> > OK, so we shouldn't be able to select a column called oid from
> > any view?
>
> That's an interesting question.  Do we disallow the query?  Comments?

    It sounds reasonable to me...considering that any other query on a
table which references a field that doesn't exist fails...no?

Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org