Re: [HACKERS] crash on new system views

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