Re: Copy

John Coers <coers@intrinsity.com> writes:
> Does a COPY FROM block?  In case I am using the wrong terminology,
> what I need to know is if I have multiple clients performing COPY FROM...PQputline()
> using asynchronous connections, will I lose data?

No.

> Will the server simply execute them serially?

They'll be executed in parallel, just the same as if each client had
done a bunch of INSERTs wrapped in a BEGIN/END block.  You'd only see
problems if clients inserted conflicting data (eg, identical keys in
a column with a UNIQUE index).  You may care to read the documentation
about multi-version concurrency control and locking.

            regards, tom lane