Re: Is there a reason why no table OID in pg_tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Is there a reason why no table OID in pg_tables
Date: 2003-10-18 15:32:49
Message-ID: 1454.1066491169@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Richard Huxton <dev(at)archonet(dot)com> writes:
> Not a real problem, I just used pg_class, but is the lack of oid in pg_tables
> a design decision and if so why?

Views don't have OIDs (or any other system columns). We could export
pg_class.oid as an ordinary column in pg_tables, but then it would be
in your face whether you wanted it or not.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Huxton 2003-10-18 16:16:14 Re: Is there a reason why no table OID in pg_tables
Previous Message Richard Huxton 2003-10-18 15:07:07 Is there a reason why no table OID in pg_tables