Re: [HACKERS] crash on new system views

On Wed, 16 Sep 1998, Andreas Zeugswetter 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?
>
> I guess it would be nice if views could show the original oid for all
> non join or single table views.

    IMHO, then the oid should be included as part of the view
definition itself...even on a join operation, having the OID might be
useful...consider a case where you have a join of two tables such that the
select is something like:

select a.oid,a.field,b.field where a.field=b.field;

    Having a.oid means that later I can just do:

select * from <view> where oid = <oid#>;

    But I think the person setting up the view should be the one
explicitly including the oid value, not the system "guessing"...