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.