I'm using pgAdmin 4 version 1.0 (release) on Apple Mac, Macos 10.12 (sierra).

I have used the 'view data' of the last 100 rows, and have the Query pane with the Data Output sub-pane showing.

I double-click on a column / row instance, and up comes a dialog box. I remove the value that's shown, and hit 'save', then, click on the 'save' icon at the top of the query pane in order to persist the change.

in this case, the column happens to be a timestamp, with nulls allowed.

the complaint shows up indicating that it appears to be trying to set the value to be an empty string rather than a null.

how is this done please?

Of course, I know how to do this using sql, but, shouldn't I be able to do this via the graphical gui too?

thank you!


This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. If you are not the intended recipient and have received this email in error, please notify BroadSoft, Inc. immediately by replying to this message, and destroy all copies of this message, along with any attachment, prior to reading, distributing or copying it.

Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:

Reply via email to