Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Insert (or update) to a partitioned table returns 0 rows updated
- From: Kris Jurka <books(at)ejurka(dot)com>
- To: Vincent Lasmarias <vlasmarias(at)guardianmms(dot)com>
- Cc: pgsql-jdbc(at)postgresql(dot)org
- Subject: Re: Insert (or update) to a partitioned table returns 0 rows updated
- Date: Mon, 21 May 2007 12:27:48 -0400 (EDT)
On Thu, 17 May 2007, Vincent Lasmarias wrote:
When I insert to (or update) the master table of partitioned tables, the method's returning 0 (which indicates that 0 rows are updated). I then checked the DB and verified that it actually did successfully insert one entry. My guess for this behavior is that it's because the updated table is the child table and not the master table. Is that expected?
Yes. See http://www.postgresql.org/docs/8.2/static/rules-status.html Kris Jurka
- References:
- Insert (or update) to a partitioned table returns 0 rows updated
- From: Vincent Lasmarias
- Insert (or update) to a partitioned table returns 0 rows updated
- Prev by Date: Re: JDBC and composite types
- Next by Date: question about AbstractJdbc2Statement
- Previous by thread: Insert (or update) to a partitioned table returns 0 rows updated
- Next by thread: JDBC and composite types
- Indexes: