Re: [HACKERS] crash on new system views

Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
>
> > Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)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.