Re: [GENERAL] trouble inserting into new partitions of partitioned

2006-12-04 Thread Richard Huxton
[EMAIL PROTECTED] wrote: = 6. thinking it might be the prepared stmt causing the problem I tried a direct call to the stored proc, to no avail: pg> SELECT silly_insert('','va',999) ; ERROR: inserts only allowed into silly partition tables (state was v

[GENERAL] trouble inserting into new partitions of partitioned tables

2006-12-03 Thread [EMAIL PROTECTED]
I'm having some trouble inserting into newly-created partitions of a partitioned table scheme. My main question is whether the following constitutes a bug, or (more likely) a gap in my understanding of what should happen? Production problem observed on 8.1.3, this test case was on 8.2RC1. (I poste