Re: [HACKERS] crash on new system views

> 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.

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