PostgreSQL: Display of nullable timestamp fields are NOT updated when using Set -> NOW()

[chipilov]

Please answer the questions below, it helps us to track the issue.

1. Which driver are you using and version of it (Ex: PostgreSQL 10.0): PostgreSQL 14.1

2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): 4.9.0, build 190

3. The steps to reproduce this issue:

4. Create a table with a nullable timestamp field (e.g. named 'ts') and add a row where the field is null

5. Display the added row by selecting all rows from the table

6. Right-click on the ts field set the value to the current timestamp by choosing Set -> NOW()

7. Commit the transaction

EXPECTED: As soon as the transaction is committed, the field of the row column is updated with the current timestamp (similar to changing columns of type integer, varchar, etc)

ACTUAL: The row column continues to display NULL even though it was updated (i.e. if the select statement is re-run, the timestamp is shown)

[sonswift]

Hi @chipilov, I could not reproduce this issue by following those steps. Everything worked fine! Could you please give me some videos or gif file explaining about this issue? It might help us a lot find out the problem. And thank you for your feedback.

[chipilov]

Sure, attached is a gif file showing the issue. The table in the video has a date field (named dt) and a timestamp field (named ts):

.