Re: default child of partition master - Mailing list pgsql-hackers

From Tom Lane
Subject Re: default child of partition master
Date
Msg-id 27782.1156090169@sss.pgh.pa.us
Whole thread Raw
In response to default child of partition master  ("April Lorenzen" <outboundindex@gmail.com>)
Responses Re: default child of partition master
List pgsql-hackers
"April Lorenzen" <outboundindex@gmail.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


pgsql-hackers by date:

Previous
From: "April Lorenzen"
Date:
Subject: default child of partition master
Next
From: Gene
Date:
Subject: Re: default child of partition master