Partitioned Tables - Mailing list pgsql-sql

From Wayne Cuddy
Subject Partitioned Tables
Date
Msg-id 20120613000545.GM19474@slacker.ja10629.home
Whole thread Raw
Responses Re: Partitioned Tables  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-sql
I'm using partitioned tables where a child table is chosen based on a
time stamp. One child table exists for each month.

I move records from a temp table to the partitioned table via something like
this:

INSERT INTO parent_table SELECT * FROM temp_table;

All works well but with when inserting to standard tables the insert
result contains the number of records inserted. I've found that when I
insert into partitioned tables the result is always zero.

I'm using the TCL binding (pgintcl) but psql behaves the same way. Is
there any way to determine the number of rows actually inserted?

Thanks,
Wayne 


pgsql-sql by date:

Previous
From: Igor Neyman
Date:
Subject: Re: using ordinal_position
Next
From: John Fabiani
Date:
Subject: how to use schema with data type