Hi.
We are switching a schema type's surrogate/primary key, from `uuid` to `int`.
That schema has parent-child relationships enforced with foreign-keys.
Our ingestion/schema-loading code uses COPY FROM STDIN BINARY.
Before, the SK/PK was generated client-side, as random uuid.
The ingestion code maintained client-side maps from NKs to uuids,
to be used for FK columns in child-tables COPY'd later.
But now that the SK/PK is an integer identity column generated server-side,
thanks to an implicitly-created sequence, we need that generated per-row `int` PK.
With a normal prepared statement, we'd use a RETURNING clause, to avoid
a separate round-trip to the server. Can the same somehow be achieved with COPY?
I'm afraid the answer is no, but I want to ask anyway, maybe there's a way or work-around?
At the end of the COPY, we do get a ResultSet, so API-wise it was be possible for it
to contain some rows, I guess, but I'm not sure the COPY protocol supports returning
rows, nor what the syntax would be to have a COPY RETURNING form of COPY.
Thanks for any insights. --DD