Hi,

A really quick 3 questions:

1. Is there any easy way to get the Postgres connection id so I can put it in my logs?

2. It appears that certain errors (I have mostly seen serialization errors do this) cause Postgres to close the socket for that connection. This results in an error like:

%DBConnection.ConnectionError{
  message: "transaction rolling back",
  reason: :error,
  severity: :error
}

Usually I would get a %Postgrex.Error{} as an exception. Is that a timing problem with Postgres closing the connection before the correct error code is sent or is it something else?

3. Is there a “maximum depth” for nested transactions?

Thanks