pgAdmin4: how to set row value to NULL using query data output pane?

From: Peter Belbin <pbelbin(at)broadsoft(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: pgAdmin4: how to set row value to NULL using query data output pane?
Date: 2016-10-12 22:33:28
Message-ID: db681d6c-19bb-87ea-4995-074c5c344e47@broadsoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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!
peter

--

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.

Browse pgadmin-support by date

  From Date Subject
Next Message Oscar 2016-10-13 06:53:04 SQL window bracket control
Previous Message Terry Schmitt 2016-10-12 14:57:25 Re: Server status report in PGAdmin 4