Postgresql transaction id not found

Question

Whenever I execute a request in postgresql, this is the error message I get

Transaction ID not found in the session.

Does anyone know how to solve this? I recently created a new user, but I could not find the documentation that even shows this as a valid error.

Additional Information: I was able to resolve the error by reconnecting to the administrator credentials.

I used PG Admin V4 with Postgres V9.6, and this was the only message that appeared in any query that I executed, even if it was a basic query, such as "SELECT NOW ()".

At the same time, this error message was received by the client device (iOS device with AWMS Lambda / NodeJS backend):

'message' : {
  'name' : 'error',
  'length' : 114,
  'severity' : 'fatal',
  'code' : '28000',
  'file' : 'miscinit.c',
  'line' : '587',
  'routine' : 'InitializeSessionUserId'
}

Answer 1

, , , , , PG Admin 4 , .

Answer 2

, , , , :

1) Reconnect to the database

2) Open a new Query Tab. (Run your query here)

.

Answer 3

PostgreSQL. - - , ORM ..

, , .

Answer 4

, :

• .
• .

I'm still not quite sure that I have found a solution to the root problem, but if others have the same scenario, this can help eliminate it. If any of these three are not used, I have never encountered a problem.

Answer 5

Disconnecting and reconnecting to the database solved this problem for me; there was no need to completely exit / open PGAdmin 4.