Skip site navigation (1) Skip section navigation (2)

Re: [ODBC] New driver options in 7.01.0007

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: pgsql-odbc(at)postgresql(dot)org, "'pgadmin-hackers(at)postgresql(dot)org'" <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: [ODBC] New driver options in 7.01.0007
Date: 2001-09-24 08:18:20
Message-ID: 3BAEEC4C.42B37087@tpf.co.jp (view raw or flat)
Thread:
Lists: pgadmin-hackerspgsql-odbc
Dave Page wrote:

> > > What?? OIDs optional?? That will *seriously* break pgAdmin at first
> > > thought. If anyone can give more info on this it would be
> > appreciated
> > > as I can't seem to get to the list archives at the moment.
> >
> > The following system tables don't have OIDs.
> >
> >     relname     | relhasoids
> > ----------------+------------
> >  pg_attribute   | f
> >  pg_group       | f
> >  pg_inherits    | f
> >  pg_index       | f
> >  pg_amop        | f
> >  pg_amproc      | f
> >  pg_largeobject | f
> >  pg_listener    | f
> >  pg_shadow      | f
> >  pg_attrdef     | f
> >  pg_description | f
> >  pg_relcheck    | f
> >  pg_statistic   | f
> 
> Thanks Hiroshi. That's less of a problem than I first imagined, but it will
> probably still break pgAdmin completely.
> 
> I assume there's a good reason for removing them?

PostgreSQL doesn't need/use their OIDs internally.
For example (attrelid, attnum) identifies the tuple
in pg_attribute properly. In addition they have
no index on thier OIDs and so the access to the
table via the OIDs aren't effective if the tables
are pretty large.

regards,
Hiroshi Inoue

In response to

pgsql-odbc by date

Next:From: Jean-Michel POUREDate: 2001-09-24 08:53:31
Subject: Re: [HACKERS] UTF-8 support
Previous:From: Dave PageDate: 2001-09-24 07:53:06
Subject: Re: [ODBC] New driver options in 7.01.0007

pgadmin-hackers by date

Next:From: Gowey, GeoffreyDate: 2001-09-24 14:53:02
Subject: Re: Changing data types
Previous:From: Dave PageDate: 2001-09-24 07:53:06
Subject: Re: [ODBC] New driver options in 7.01.0007

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group