Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 3C47D2E007B for ; Mon, 3 Mar 2008 12:35:30 -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 58180-05 for ; Mon, 3 Mar 2008 12:35:22 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from n77.bullet.mail.sp1.yahoo.com (n77.bullet.mail.sp1.yahoo.com [98.136.44.45]) by postgresql.org (Postfix) with SMTP id D3BEA2E006A for ; Mon, 3 Mar 2008 12:35:21 -0400 (AST) Received: from [216.252.122.218] by n77.bullet.mail.sp1.yahoo.com with NNFMP; 03 Mar 2008 16:35:11 -0000 Received: from [69.147.84.100] by t3.bullet.sp1.yahoo.com with NNFMP; 03 Mar 2008 16:35:11 -0000 Received: from [127.0.0.1] by omp201.mail.sp1.yahoo.com with NNFMP; 03 Mar 2008 16:35:11 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 665174.26601.bm@omp201.mail.sp1.yahoo.com Received: (qmail 92931 invoked by uid 60001); 3 Mar 2008 16:35:11 -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=o6j3FY9ma6zFEKkgBmGbqal5BW3a9ttZWj9hkiKXoWr7FEUMAbAgc58fWZ3tJyGrJ2riNvPRU4f9UQ9Y3OqKojIBBLMEIjs4h9gFJodU4NxG+sJAzgVB9VlgqLUkZmpsFSFpAx3l1wjcDSQIZeAbhGjMFrOLcF5qHb7cWYZS010=; X-YMail-OSG: 0Oqhx20VM1kLY8a._puM2hTZn.qNnPeTVoFQaDsalJbK_B4GICQTOff1iipyXPnzK494R3on1gs5gFkZFX5Pj33V3J2guEKyTVhA Received: from [128.8.215.134] by web46003.mail.sp1.yahoo.com via HTTP; Mon, 03 Mar 2008 08:35:11 PST Date: Mon, 3 Mar 2008 08:35:11 -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-1905596015-1204562111=:91488" Content-Transfer-Encoding: 8bit Message-ID: <574419.91488.qm@web46003.mail.sp1.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.275 tagged_above=0 required=5 tests=AWL=-0.136, HTML_MESSAGE=0.001, SUBJECT_FUZZY_TION=0.41 X-Spam-Level: X-Archive-Number: 200803/22 X-Sequence-Number: 28504 --0-1905596015-1204562111=:91488 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-1905596015-1204562111=:91488 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-1905596015-1204562111=:91488--