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: 45FAA7AF.7000806@commandprompt.com (view raw or flat)
Thread:
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
consumption.

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
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


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-2014 The PostgreSQL Global Development Group