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/
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