Re: Partitioning option for COPY - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Partitioning option for COPY
Date
Msg-id 19645.1259166647@sss.pgh.pa.us
Whole thread Raw
In response to Re: Partitioning option for COPY  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Partitioning option for COPY
Re: Partitioning option for COPY
List pgsql-hackers
It seems like the easiest way to resolve this without weird corner
cases is to say that we fire triggers belonging to the parent table.
The individual partition child tables either shouldn't have triggers
at all, or we should restrict the cases in which those are considered
applicable.

As an example, what are you going to do with statement-level triggers?
Fire them for *every* child whether it receives a row or not?  Doesn't
seem like the right thing.

Again, this solution presupposes an explicit concept of partitioned
tables within the system...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Hot Standby and cancelling idle queries
Next
From: "Florian G. Pflug"
Date:
Subject: ALTER TABLE, find_composite_type_dependencies and locking