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