Обсуждение: query tool - current_timestamp
Dear Support Team!
I noticed that in pgadmin4 version 6.13 the current_timestamp and now functions are not updated within the query tool.
So when I issue the command several times at later times in same query tool pane,
it always returns the same time (when the query tool was opened).
In older versions, as I remember, only the now command worked like this, the current_timestamp was always updated.
Or perhaps some setting or other workaround for this, without having to open a new query tool pane?
Thanks in advance!
____________________________________________________________
Best Regards:
Benedek Polgár
System administrator
Вложения
On 03/09/2022 09:57, Polgár Benedek wrote: > Dear Support Team! > > I noticed that in pgadmin4 version 6.13 the current_timestamp and now > functions are not updated within the query tool. > So when I issue the command several times at later times in same query > tool pane, > it always returns the same time (when the query tool was opened). It works OK for me - repeatedly clicking the "Execute" button with select current_timestamp, now() in the query tool returns an updated result every time. Ray. -- Raymond O'Donnell // Galway // Ireland ray@rodonnell.ie
Dear Ray!
Thanks for the quick response!
I'm so sorry, I found the problem!
I turned off autocommit.
Because of this, after running the command, I need to run the rollback so that the current_timestamp and the now command are updated.
I'm sorry to bothered you!
However, they might be able to help with another question.
____________________________________________________________
Best Regards:
Benedek Polgár
System administrator
From: Ray O'Donnell <ray@rodonnell.ie>
Sent: 03 September 2022 11:06
To: Polgár Benedek <polgar.benedek@otpmobil.com>; pgadmin-support@lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Subject: Re: query tool - current_timestamp
Sent: 03 September 2022 11:06
To: Polgár Benedek <polgar.benedek@otpmobil.com>; pgadmin-support@lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Subject: Re: query tool - current_timestamp
On 03/09/2022 09:57, Polgár Benedek wrote:
> Dear Support Team!
>
> I noticed that in pgadmin4 version 6.13 the current_timestamp and now
> functions are not updated within the query tool.
> So when I issue the command several times at later times in same query
> tool pane,
> it always returns the same time (when the query tool was opened).
It works OK for me - repeatedly clicking the "Execute" button with
select current_timestamp, now()
in the query tool returns an updated result every time.
Ray.
--
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie
> Dear Support Team!
>
> I noticed that in pgadmin4 version 6.13 the current_timestamp and now
> functions are not updated within the query tool.
> So when I issue the command several times at later times in same query
> tool pane,
> it always returns the same time (when the query tool was opened).
It works OK for me - repeatedly clicking the "Execute" button with
select current_timestamp, now()
in the query tool returns an updated result every time.
Ray.
--
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie