search

drawdb-io / drawdb

Free, simple, and intuitive online database diagram editor and SQL generator.
https://drawdb.app
GNU Affero General Public License v3.0
22.74k stars 1.59k forks source link

[BUG] PostgreSQL Date/Time special values are marked as error #238

Closed maks00x closed 2 months ago

maks00x commented 2 months ago

Due to the official Postgres documentation there are several special values for Date/Time value types. But using them in Editor is marked as problem.

STR:

  1. Create a DB in editor
  2. Specify to use PostgreSQL for it
  3. Create a table
  4. Add a column
  5. Specify its type TIMESTAMP (probably others Date/Time types too).
  6. Press the ... button
  7. Set the default value infinity/now or another special value

Expected behavior Default value is set successfully

Actual behavior A problem message appears in the problems list

Screenshots Screenshot

Desktop:

1ilit commented 2 months ago

Feel free to reopen the issue if the problem still persists