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
