pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joshua D. Drake <jd@commandprompt.com>
To: Adam Radlowski <adamr@informatyka.gdansk.pl>
Cc: gunartha.nyoman <gunartha.nyoman@ptjas.co.id>
Cc: pgsql-admin@postgresql.org
Subject: Re: how to add oids field
Date: Fri, 16 Mar 2007 07:20:31 -0700
Message-ID: <45FAA7AF.7000806@commandprompt.com> (raw)
In-Reply-To: <45FAA0B7.9000308@informatyka.gdansk.pl>
References: <005d01c767a5$88c3da30$fd0010b2@idas>
	<45FAA0B7.9000308@informatyka.gdansk.pl>

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/




view thread (4+ messages)  latest in thread

Message-ID: <45FAA7AF.7000806@commandprompt.com>
Permalink:  ../45FAA7AF.7000806@commandprompt.com/
Also on:    postgresql.org/message-id/45FAA7AF.7000806@commandprompt.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 using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: jd@commandprompt.com, adamr@informatyka.gdansk.pl, gunartha.nyoman@ptjas.co.id
  Subject: Re: how to add oids field
  In-Reply-To: <45FAA7AF.7000806@commandprompt.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