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@xxxxxxxxxxxxx]
Sent: Tuesday, August 15, 2006 3:29 PM
To: Sriram Dandapani
Cc: pgsql-admin@xxxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
