pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jim Nasby <jnasby@pervasive.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: DDL commands don't handle OID wrap
Date: Mon, 17 Apr 2006 17:09:15 -0500
Message-ID: <DFB1560F-60B3-486D-A6C9-14A32D00C5D5@pervasive.com> (raw)
In-Reply-To: <4551.1145303173@sss.pgh.pa.us>
References: <20060417193829.GN49405@pervasive.com>
	<4551.1145303173@sss.pgh.pa.us>

On Apr 17, 2006, at 2:46 PM, Tom Lane wrote:

> "Jim C. Nasby" <jnasby@pervasive.com> writes:
>> Haven't seen this in previous discussions of OID wrap in the  
>> archives.
>> The issue is that DDL statements don't make any attempt to skip past
>> used ranges of OIDs.
>> duplicate key violates unique constraint "pg_attrdef_oid_index"
>
> If you can make that happen in 8.1, I'd be fascinated to look at the
> test case.

Yet another reason for this customer to upgrade... :)

Also, in 8.1, here's a list of tables in pg_catalog that don't appear  
to have unique constraints on oid... do these all look safe?

decibel=# select table_name from information_schema.tables where  
table_schema='pg_catalog' and table_type='BASE TABLE' except select  
tablename from pg_indexes where schemaname='pg_catalog' and indexname  
like '%oid%';
    table_name
-----------------
pg_amop
pg_amproc
pg_attribute
pg_auth_members
pg_autovacuum
pg_depend
pg_description
pg_index
pg_inherits
pg_listener
pg_pltemplate
pg_shdepend
pg_statistic

--
Jim C. Nasby, Database Architect                decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"





view thread (4+ messages)  latest in thread

Message-ID: <DFB1560F-60B3-486D-A6C9-14A32D00C5D5@pervasive.com>
Permalink:  ../DFB1560F-60B3-486D-A6C9-14A32D00C5D5@pervasive.com/
Also on:    postgresql.org/message-id/DFB1560F-60B3-486D-A6C9-14A32D00C5D5@pervasive.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: jnasby@pervasive.com, tgl@sss.pgh.pa.us
  Subject: Re: DDL commands don't handle OID wrap
  In-Reply-To: <DFB1560F-60B3-486D-A6C9-14A32D00C5D5@pervasive.com>
  References: <20060417193829.GN49405@pervasive.com> <4551.1145303173@sss.pgh.pa.us> <DFB1560F-60B3-486D-A6C9-14A32D00C5D5@pervasive.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox