Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id AF96E2E006A for ; Mon, 3 Mar 2008 12:45:51 -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 95219-02 for ; Mon, 3 Mar 2008 12:45:47 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from n25.bullet.mail.mud.yahoo.com (n25.bullet.mail.mud.yahoo.com [68.142.200.132]) by postgresql.org (Postfix) with SMTP id 692502E0081 for ; Mon, 3 Mar 2008 12:45:47 -0400 (AST) Received: from [68.142.200.224] by n25.bullet.mail.mud.yahoo.com with NNFMP; 03 Mar 2008 16:45:46 -0000 Received: from [68.142.201.67] by t5.bullet.mud.yahoo.com with NNFMP; 03 Mar 2008 16:45:46 -0000 Received: from [127.0.0.1] by omp419.mail.mud.yahoo.com with NNFMP; 03 Mar 2008 16:45:46 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 108892.88753.bm@omp419.mail.mud.yahoo.com Received: (qmail 65815 invoked by uid 60001); 3 Mar 2008 16:45:45 -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=bRrHqYdc6qdZ4YcDGHI5MdksG7Ht3eTykwE0+POQuYkkduZThpuMYN+yGf1LJh9zbOcEL6nkhYB4+GQVlCQlSMAK6l5ddHj85GzfPw97J4lVBuBHXoqrlK70iXgVbNHmGoZbQs6fT11kR8Pcx77QmErAHx9u7lQDayDG/JG2a2I=; X-YMail-OSG: nG6esecVM1nltuIzwaW3_P3zH8M981R1EqKvF5rO Received: from [128.8.215.134] by web46016.mail.sp1.yahoo.com via HTTP; Mon, 03 Mar 2008 08:45:45 PST Date: Mon, 3 Mar 2008 08:45:45 -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-1016877827-1204562745=:64615" Content-Transfer-Encoding: 8bit Message-ID: <657529.64615.qm@web46016.mail.sp1.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.309 tagged_above=0 required=5 tests=AWL=-0.102, HTML_MESSAGE=0.001, SUBJECT_FUZZY_TION=0.41 X-Spam-Level: X-Archive-Number: 200803/13 X-Sequence-Number: 28496 --0-1016877827-1204562745=:64615 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? --------------------------------- Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. --0-1016877827-1204562745=:64615 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?


Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. --0-1016877827-1204562745=:64615--