Re: ClientRead on ROLLABACK - Mailing list pgsql-hackers

From Simone G.
Subject Re: ClientRead on ROLLABACK
Date
Msg-id 0F3BC6D3-65A6-445C-849C-B836A918E141@gmail.com
Whole thread Raw
In response to Re: ClientRead on ROLLABACK  (Jelte Fennema-Nio <postgres@jeltef.nl>)
List pgsql-hackers
Oh, I see. So the ROLLBACK command was executed! So I suppose the client was waiting just for the ACK and the
connectionhas been left open. 

> I think this is a super common confusion among users. Maybe we should
> consider making it clearer that no query is currently being executed.
> Something like
>
> IDLE: last query: SELECT * FROM mytable;

I think the clearest option would be leave the query column empty and add a new column last_query. But this suggestion
maystill do its job in clarifying that the query is not running.  


pgsql-hackers by date:

Previous
From: Jelte Fennema-Nio
Date:
Subject: Re: ClientRead on ROLLABACK
Next
From: Marthin Laubscher
Date:
Subject: Re: Custom type's modifiers