Hi,

The documentation about the LOCKED modifier for COPY INTO mentions:

When using the LOCKED mode, it is the responsibility of the database user to make sure that there is currently only a single client connection accessing the database

I was assuming (and the syntax suggests, I think) that the LOCKED refers to the table being copied into, not to the entire database. That is, only that table is updated without the overhead of logging.

But the documentation imposes the very restrictive condition that only one connection is active on the database. That seems to suggest that the entire database is being updated without logging, not only that table.

Could you please clarify? Can I do COPY INTO LOCKED safely with more than one connection, as long as only 1 connection touches that table?

Roberto