Re: [HACKERS] default child of partition master

2006-08-25 Thread Jim C. Nasby
On Sun, Aug 20, 2006 at 12:58:31PM -0400, Gene wrote: > Keep in mind if you have multiple rules for a master table, it won't return > the number of affected rows as you might expect. This screws up Hibernate > which I'm using for my application. It checks the return value to make sure > it was inse

Re: [HACKERS] default child of partition master

2006-08-20 Thread Gene
Keep in mind if you have multiple rules for a master table, it won't return the number of affected rows as you might expect. This screws up Hibernate which I'm using for my application. It checks the return value to make sure it was inserted properly. Luckily I only need one rule which puts it into

Re: [HACKERS] default child of partition master

2006-08-20 Thread Tom Lane
"April Lorenzen" <[EMAIL PROTECTED]> writes: > My suggestion is to allow specifying a default destination table in > the master partition table definition. This default destination table > could be changed with ALTER TABLE. The recommended way to do this is with an ON INSERT DO INSTEAD rule on the

[HACKERS] default child of partition master

2006-08-20 Thread April Lorenzen
I'm using partitioned tables a lot and loving it. I have a suggestion that I believe would make it easier to bring the performance and maintenance advantages of partitions to more applications and users: As I understand it, at present I can select records from sales_master and get data returned f