Re: default child of partition master

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "April Lorenzen" <outboundindex(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: default child of partition master
Date: 2006-08-20 16:09:29
Message-ID: 27782.1156090169@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"April Lorenzen" <outboundindex(at)gmail(dot)com> 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 master table. The advantage of using rules is that you can have
several conditional rules to ensure that insertions go into the right
sub-tables, whereas a default would likely just fail :-(

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gene 2006-08-20 16:58:31 Re: default child of partition master
Previous Message Tom Lane 2006-08-20 16:05:57 Re: DROP OWNED BY doesn't work