Skip to content

CURRENT_DATE in data grid for data entry #9528

@marclinster

Description

@marclinster

When I put the function current_date into a date column in the data grid to add a new row, I get the message

invalid input syntax for type date: "current_date"
CONTEXT: unnamed portal parameter $2 = '...'

I also tried current_date(). NOW() works just fine.

To Reproduce

CREATE TABLE test (id INTEGER PRIMARY KEY, date_column DATE);
-- test via query tool
INSERT INTO test (id, date_column) VALUES (1, current_date);

-- same via data grid:
Image

** Environment **

  • MacOS 26.2
  • pgAdmin 9.11 (local install)
  • PostgreSQL 18

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions