Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B9A179FBE02 for ; Fri, 16 Mar 2007 10:53:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 61603-05 for ; Fri, 16 Mar 2007 10:53:25 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from ns1.peker.com.pl (181-ego-2.acn.waw.pl [62.121.85.181]) by postgresql.org (Postfix) with SMTP id 816F59FBBAA for ; Fri, 16 Mar 2007 10:53:23 -0300 (ADT) Received: (qmail 5251 invoked by uid 540); 16 Mar 2007 13:48:50 -0000 Received: from 217.149.240.98 by ns1.peker.com.pl (envelope-from , uid 401) with qmail-scanner-1.25st (clamdscan: 0.82/760. spamassassin: 3.0.2. perlscan: 1.25st. Clear:RC:1(217.149.240.98):. Processed in 0.070306 secs); 16 Mar 2007 13:48:50 -0000 Received: from rzgw1.artnet.pl (HELO ?10.4.128.44?) (informatyka-adamr@217.149.240.98) by ns1.peker.com.pl with SMTP; 16 Mar 2007 13:48:49 -0000 Message-ID: <45FAA0B7.9000308@informatyka.gdansk.pl> Date: Fri, 16 Mar 2007 14:50:47 +0100 From: Adam Radlowski User-Agent: Thunderbird 1.5.0.7 (X11/20060909) MIME-Version: 1.0 To: "gunartha.nyoman" CC: pgsql-admin@postgresql.org Subject: Re: how to add oids field References: <005d01c767a5$88c3da30$fd0010b2@idas> In-Reply-To: <005d01c767a5$88c3da30$fd0010b2@idas> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/98 X-Sequence-Number: 24922 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