Обсуждение: Re: [HACKERS] crash on new system views
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.
> > > 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. |
> > > 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. |
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