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.


Tue, 15 Sep 1998 19:12:39 +0100 (BST)
Keith Parks <emkxp01@mtcc.demon.co.uk>
Re: [HACKERS] crash on new system views
> > > 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?

That's an interesting question.  Do we disallow the query?  Comments?


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

Tue, 15 Sep 1998 14:36:02 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] crash on new system views
On Tue, 15 Sep 1998, Bruce Momjian wrote:

> > > > 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?
> 
> That's an interesting question.  Do we disallow the query?  Comments?

	It sounds reasonable to me...considering that any other query on a
table which references a field that doesn't exist fails...no?

Marc G. Fournier                                
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 


Tue, 15 Sep 1998 19:14:18 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
Re: [HACKERS] crash on new system views