Re: [GENERAL] Partitioned tables, rules, triggers

2007-10-08 Thread Josh Tolley
On 10/6/07, Goboxe <[EMAIL PROTECTED]> wrote: > Josh, > > Thanks for sharing a very good info on partitioning. > Don't thank me -- this comes from Robert Treat. I'm just the messenger :) -Josh/eggyknap ---(end of broadcast)--- TIP 2: Don't 'kill -9

Re: [GENERAL] Partitioned tables, rules, triggers

2007-10-08 Thread Goboxe
Josh, Thanks for sharing a very good info on partitioning. On Oct 5, 10:08 pm, [EMAIL PROTECTED] ("Josh Tolley") wrote: > On 10/3/07, Goboxe <[EMAIL PROTECTED]> wrote: > > > Hi, > > > I have two questions on the above: > > > 1. I found in some postings recommended to use triggers instead of > >

Re: [GENERAL] Partitioned tables, rules, triggers

2007-10-05 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Erik Jones wrote: > On Oct 5, 2007, at 10:53 AM, Scott Marlowe wrote: > >> On 10/5/07, Josh Tolley <[EMAIL PROTECTED]> wrote: >>> On 10/3/07, Goboxe <[EMAIL PROTECTED]> wrote: Hi, I have two questions on the above: 1. I found

Re: [GENERAL] Partitioned tables, rules, triggers

2007-10-05 Thread Erik Jones
On Oct 5, 2007, at 10:53 AM, Scott Marlowe wrote: On 10/5/07, Josh Tolley <[EMAIL PROTECTED]> wrote: On 10/3/07, Goboxe <[EMAIL PROTECTED]> wrote: Hi, I have two questions on the above: 1. I found in some postings recommended to use triggers instead of rules. Is this documented somewhere?

Re: [GENERAL] Partitioned tables, rules, triggers

2007-10-05 Thread Scott Marlowe
On 10/5/07, Josh Tolley <[EMAIL PROTECTED]> wrote: > On 10/3/07, Goboxe <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I have two questions on the above: > > > > 1. I found in some postings recommended to use triggers instead of > > rules. Is this documented somewhere? > > A howto is available at > htt

Re: [GENERAL] Partitioned tables, rules, triggers

2007-10-05 Thread Josh Tolley
On 10/3/07, Goboxe <[EMAIL PROTECTED]> wrote: > Hi, > > I have two questions on the above: > > 1. I found in some postings recommended to use triggers instead of > rules. Is this documented somewhere? A howto is available at http://images.omniti.net/omniti.com/talks/partitions-public.pdf - Josh/e

[GENERAL] Partitioned tables, rules, triggers

2007-10-04 Thread Goboxe
Hi, I have two questions on the above: 1. I found in some postings recommended to use triggers instead of rules. Is this documented somewhere? 2. When using trigger, any examples on how to update the trigger dynamically when tables are added or deleted from the partitioned? Thanks, Amin -