X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 0FA779FB331 for ; Sat, 19 Aug 2006 00:43:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 52808-01 for ; Sat, 19 Aug 2006 00:43:02 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id A9B3F9FB32F for ; Sat, 19 Aug 2006 00:43:01 -0300 (ADT) Received: from [10.67.160.130] (mobile-166-137-129-156.mycingular.net [166.137.129.156]) (using TLSv1 with cipher RC4-SHA (128/128 bits)) (No client certificate requested) by noel.decibel.org (Postfix) with ESMTP id 6D49056423; Fri, 18 Aug 2006 22:42:49 -0500 (CDT) In-Reply-To: <6992E470F12A444BB787B5C937B9D4DF0574F899@ca-mail1.cis.local> References: <6992E470F12A444BB787B5C937B9D4DF0574F899@ca-mail1.cis.local> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <0FD68995-B2A1-4E89-9FFE-94EF46E8F169@pervasive.com> Cc: Content-Transfer-Encoding: 7bit From: Jim Nasby Subject: Re: dropping partitioned table waits forever Date: Fri, 18 Aug 2006 08:04:09 -0500 To: Sriram Dandapani X-Mailer: Apple Mail (2.752.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200608/228 X-Sequence-Number: 22771 I think you'll probably need to submit a self-contained, reproducible test case. On Aug 15, 2006, at 6:00 PM, Sriram Dandapani wrote: > Postmaster was automatically restarted. (didn't crash). > > Rules are used to implement the partitioning (and the triggers as > well) > > Using postgres 8.1.2 > > -----Original Message----- > From: Jim C. Nasby [mailto:jnasby@pervasive.com] > Sent: Tuesday, August 15, 2006 3:29 PM > To: Sriram Dandapani > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] dropping partitioned table waits forever > > On Tue, Aug 15, 2006 at 02:34:57PM -0700, Sriram Dandapani wrote: >> When I modify the trigger, I noticed that postgres restarted. Not >> sure >> why, but it happens when it is being executed. This behaviour is >> consistent. > > Restarted as in the database crashed?? > > Is this actually being done with a trigger or with rules? > -- > Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com > Pervasive Software http://pervasive.com work: 512-231-6117 > vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 > > ---------------------------(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 > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461