From: | Polgár Benedek <polgar(dot)benedek(at)otpmobil(dot)com> |
---|---|
To: | Ray O'Donnell <ray(at)rodonnell(dot)ie>, "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org> |
Subject: | Re: query tool - current_timestamp |
Date: | 2022-09-03 09:24:18 |
Message-ID: | AS4PR01MB92315AAB60E2C08B0058A3C9F47D9@AS4PR01MB9231.eurprd01.prod.exchangelabs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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.
Is there a way to use "UTF-8 with BOM" format for pgadmin data export?
____________________________________________________________
Best Regards:
Benedek Polgár
System administrator
________________________________
From: Ray O'Donnell <ray(at)rodonnell(dot)ie>
Sent: 03 September 2022 11:06
To: Polgár Benedek <polgar(dot)benedek(at)otpmobil(dot)com>; pgadmin-support(at)lists(dot)postgresql(dot)org <pgadmin-support(at)lists(dot)postgresql(dot)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(at)rodonnell(dot)ie
From | Date | Subject | |
---|---|---|---|
Next Message | Rasiklal Limbani | 2022-09-05 12:57:41 | Port 5432 failed password authentication failed |
Previous Message | Ray O'Donnell | 2022-09-03 09:06:49 | Re: query tool - current_timestamp |