Re: [GENERAL] Unexplained lock creating table

2006-04-22 Thread Wes
> If this is the first child table of "header", which it presumably is, then > the pg_class row for "header" has to be updated to set relhassubclass. Since > you do not commit the create before continuing, this backend continues to > hold a row lock on the updated, uncommitted pg_class row while yo

Re: [GENERAL] Unexplained lock creating table

2006-04-22 Thread Andrew - Supernews
On 2006-04-22, Wes <[EMAIL PROTECTED]> wrote: > I have a C application (libpq) that uses partitioning. I create parent > tables 'header' and 'detail'. The application reads opens multiple > connections, creates the child tables, and uses COPY to import the data: > > open connection 1 > begin