> 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
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
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
create table header_1
COPY into header_1
open conn
