pg_backend_pid() inconsistent with BackendKeyData

[dvarrazzo]

As of 22.1, CRDB sends the client the backend pid at connection, in the BackendKeyData message.

The pg_backend_pid() function, however, returns the constant -1 (#13097).

It would be useful if the function returned data consistent with the info sent at connection.

Jira issue: CRDB-16513

[blathers-crl]

Hello, I am Blathers. I am here to help you get the issue triaged.

It looks like you have not filled out the issue in the format of any of our templates. To best assist you, we advise you to use one of these templates.

I have CC'd a few people who may be able to assist you:

• @jordanlewis (author of sql: implement pg_backend_pid builtin #13097)
• @cockroachdb/sql-experience (found keywords: pg_)

If we have not gotten back to your issue within a few business days, you can try the following:

• Join our community slack channel and ask on #cockroachdb.
• Try find someone from here if you know they worked closely on the area and CC them.

_{🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan.}