Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 680012E0144 for ; Mon, 3 Mar 2008 12:21:49 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 36221-03 for ; Mon, 3 Mar 2008 12:21:39 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from n66.bullet.mail.sp1.yahoo.com (n66.bullet.mail.sp1.yahoo.com [98.136.44.50]) by postgresql.org (Postfix) with SMTP id 436332E0149 for ; Mon, 3 Mar 2008 12:21:39 -0400 (AST) Received: from [216.252.122.218] by n66.bullet.mail.sp1.yahoo.com with NNFMP; 03 Mar 2008 16:21:38 -0000 Received: from [69.147.65.158] by t3.bullet.sp1.yahoo.com with NNFMP; 03 Mar 2008 16:21:37 -0000 Received: from [127.0.0.1] by omp406.mail.sp1.yahoo.com with NNFMP; 03 Mar 2008 16:21:37 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 963401.95480.bm@omp406.mail.sp1.yahoo.com Received: (qmail 63648 invoked by uid 60001); 3 Mar 2008 16:21:29 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=b+sfansc4NMcdsz4Qm8icC5J5Xq6oeIIW4nwADdwXa1q4o7qncF0oKYxBQxaZVHYiJ06hsWCy8szQ+YJHQV5zsjIgFHEEKKCLsUPhGYDHBGL4oZRJSM6KNUwyN3aHMvVN3NwBion9MhQsPAxO4AMBjvjImlIjtuVTCWiLcAGDZQ=; X-YMail-OSG: _OxRuR0VM1nOruNwUk3hjz2gtxcB6C25IvoFqRHLAeCX07pGaychN7sQNUTUw65jOQ-- Received: from [128.8.215.134] by web46012.mail.sp1.yahoo.com via HTTP; Mon, 03 Mar 2008 08:21:29 PST Date: Mon, 3 Mar 2008 08:21:29 -0800 (PST) From: Nuwan Liyanage Subject: Delete from base table and not partitions To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-2005294160-1204561289=:62438" Content-Transfer-Encoding: 8bit Message-ID: <230743.62438.qm@web46012.mail.sp1.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.206 tagged_above=0 required=5 tests=AWL=-0.204, HTML_MESSAGE=0.001, SUBJECT_FUZZY_TION=0.41 X-Spam-Level: X-Archive-Number: 200803/21 X-Sequence-Number: 28505 --0-2005294160-1204561289=:62438 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Question: I have a base table with several temporal partitions like this: base_table partition_1 partition_2 There are check rules on partitions, and trigger rules on the base table to ensure data loaded into base_table goes to a correct partition. I added partition_3 and created the check rules on it, but forgot to add trigger rules on the base_table. So for a while data inserted into base_table and meant for partition_3 was actually inserted into base_table. Now I added the trigger rule to base_table and the data for partition_3 is going to the right place, but I am stuck with some data in the actual base_table. How could I move that data from the base table to the partition_3? thanks. --------------------------------- Never miss a thing. Make Yahoo your homepage. --0-2005294160-1204561289=:62438 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Question: I have a base table with several temporal partitions like this:
base_table
partition_1
partition_2

There are check rules on partitions, and trigger rules on the base
table to ensure data loaded into base_table goes to a correct
partition.

I added partition_3 and created the check rules on it, but forgot to
add trigger rules on the base_table. So for a while data inserted into
base_table and meant for partition_3 was actually inserted into
base_table.

Now I added the trigger rule to base_table and the data for
partition_3 is going to the right place, but I am stuck with some data
in the actual base_table. How could I move that data from the base
table to the partition_3?

thanks.


Never miss a thing. Make Yahoo your homepage. --0-2005294160-1204561289=:62438--