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

Re: how to add oids field

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Adam Radlowski <adamr(at)informatyka(dot)gdansk(dot)pl>
Cc: "gunartha(dot)nyoman" <gunartha(dot)nyoman(at)ptjas(dot)co(dot)id>, pgsql-admin(at)postgresql(dot)org
Subject: Re: how to add oids field
Date: 2007-03-16 14:20:31
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Adam Radlowski wrote:
> gunartha.nyoman napisaƂ(a):
>> hi,
>> I am new comer in this millis...
>> i have a poblem, how to add a field/column in existing table without
>> oids.
>> if i create new table i can add field oids

More important, you shouldn't be doing this. OIDs are not for user

Joshua D. Drake

>> Thank alot before
>> regrads
>> Nyoman/bali
> So - create a new table with this same structure, but with oids, copy
> all records into new table. Retrive all the information about the old
> table (keys, indexes, triggers, etc.). Delete old table, rename new
> table to old name, create all needed indexes, keys, triggers,etc.
> bregards
> Adam
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match


      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997

Donate to the PostgreSQL Project:
PostgreSQL Replication:

In response to

pgsql-admin by date

Next:From: Jeff FrostDate: 2007-03-16 14:46:23
Subject: Re: pl/pgsql function spikes CPU 100%
Previous:From: Adam RadlowskiDate: 2007-03-16 13:50:47
Subject: Re: how to add oids field

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