From gunartha.nyoman@ptjas.co.id Fri Mar 16 07:38:15 2007 Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5C37B9FB7D0 for ; Fri, 16 Mar 2007 04:38:15 -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 74298-05 for ; Fri, 16 Mar 2007 04:38:06 -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 CA58C9FB758 for ; Fri, 16 Mar 2007 04:38:00 -0300 (ADT) Received: from [178.16.0.253] (helo=idas) by kurawa.ptjas.co.id with smtp (Exim 4.43) id 1HS76C-0000gk-Pm for pgsql-admin@postgresql.org; Fri, 16 Mar 2007 14:43:41 +0700 Message-ID: <005d01c767a5$88c3da30$fd0010b2@idas> Reply-To: "gunartha.nyoman" From: "gunartha.nyoman" To: Subject: how to add oids field Date: Fri, 16 Mar 2007 15:31:43 +0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_005A_01C767E0.33378400" 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=2.761 tagged_above=0 required=5 tests=AWL, BAYES_50, HTML_MESSAGE X-Spam-Level: ** X-Archive-Number: 200703/95 X-Sequence-Number: 24919 This is a multi-part message in MIME format. ------=_NextPart_000_005A_01C767E0.33378400 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable hi,=20 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 ------=_NextPart_000_005A_01C767E0.33378400 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
hi,
 
I am new comer in this = millis...
i have a poblem, how to add a = field/column in=20 existing table without oids.
if i create new table i can add field=20 oids
 
Thank alot before
 
regrads
Nyoman/bali
------=_NextPart_000_005A_01C767E0.33378400-- From adamr@informatyka.gdansk.pl Fri Mar 16 13:53:30 2007 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 From jd@commandprompt.com Fri Mar 16 14:19:55 2007 Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 22BBE9FB8A8 for ; Fri, 16 Mar 2007 11:19:55 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 97470-04 for ; Fri, 16 Mar 2007 11:19:49 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id C8CFC9FB692 for ; Fri, 16 Mar 2007 11:19:49 -0300 (ADT) Received: from [192.168.1.50] (or-67-76-146-141.sta.embarqhsd.net [67.76.146.141]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l2GEJZCU019802 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Fri, 16 Mar 2007 07:19:36 -0700 Message-ID: <45FAA7AF.7000806@commandprompt.com> Date: Fri, 16 Mar 2007 07:20:31 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Thunderbird 1.5.0.9 (X11/20070103) MIME-Version: 1.0 To: Adam Radlowski CC: "gunartha.nyoman" , pgsql-admin@postgresql.org Subject: Re: how to add oids field References: <005d01c767a5$88c3da30$fd0010b2@idas> <45FAA0B7.9000308@informatyka.gdansk.pl> In-Reply-To: <45FAA0B7.9000308@informatyka.gdansk.pl> X-Enigmail-Version: 0.94.0.0 Content-Type: text/plain; charset=ISO-8859-2 Content-Transfer-Encoding: 8bit X-Virus-Scanned: ClamAV version 0.88.5, clamav-milter version 0.88.5 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Fri, 16 Mar 2007 07:19:36 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/99 X-Sequence-Number: 24923 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/ From gunartha.nyoman@ptjas.co.id Tue Mar 20 01:52:02 2007 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