Re: [ADMIN] DDL commands don't handle OID wrap

2006-04-17 Thread Tom Lane
Jim Nasby <[EMAIL PROTECTED]> writes: > 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? I'd be a bit surprised to find such a constraint on any of these, seeing that they don't have oids.

Re: [ADMIN] DDL commands don't handle OID wrap

2006-04-17 Thread Jim Nasby
On Apr 17, 2006, at 2:46 PM, Tom Lane wrote: "Jim C. Nasby" <[EMAIL PROTECTED]> 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

Re: [ADMIN] DDL commands don't handle OID wrap

2006-04-17 Thread Tom Lane
"Jim C. Nasby" <[EMAIL PROTECTED]> 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 h

[ADMIN] DDL commands don't handle OID wrap

2006-04-17 Thread Jim C. Nasby
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" duplicate key violates unique constraint "pg_type_oid_index" etc... Whil