Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id B54619FB510 for ; Mon, 19 Mar 2007 22:52:02 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 07800-06 for ; Mon, 19 Mar 2007 22:51:35 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.ptjas.co.id (unknown [202.152.3.67]) by postgresql.org (Postfix) with ESMTP id 483B39FB277 for ; Mon, 19 Mar 2007 22:51:37 -0300 (ADT) Received: from [178.16.0.253] (helo=idas) by kurawa.ptjas.co.id with smtp (Exim 4.43) id 1HTTb2-00073Y-8f for pgsql-admin@postgresql.org; Tue, 20 Mar 2007 08:57:09 +0700 Message-ID: <001501c76a99$c9585b60$fd0010b2@idas> Reply-To: "gunartha.nyoman" From: "gunartha.nyoman" To: References: <005d01c767a5$88c3da30$fd0010b2@idas> <45FAA0B7.9000308@informatyka.gdansk.pl> Subject: Re: how to add oids field Date: Tue, 20 Mar 2007 09:45:07 +0700 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="ISO-8859-2"; reply-type=response Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.748 tagged_above=0 required=5 tests=AWL, BAYES_40 X-Spam-Level: * X-Archive-Number: 200703/125 X-Sequence-Number: 24949 Okey, Mr Radlowski and Mr. Drake thank for your comment Regards, Nyoman/Bali ----- Original Message ----- From: "Adam Radlowski" To: "gunartha.nyoman" Cc: Sent: Friday, March 16, 2007 8:50 PM Subject: Re: [ADMIN] how to add oids field 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 > > 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