[BUG] Import fails on casting of a regex (Postgres SQL file)

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.7k stars 1.58k forks source link

Open m-thomson opened 2 months ago

m-thomson commented 2 months ago

Describe the bug A Postgres SQL import fails at the location shown in the screenshot.

Screenshots Screencap2024 09 17 1548

Desktop (please complete the following information):

Additional context I'm not sure why PGAdmin4 generates this ::TEXT cast on a regex CHECK but it causes the importer to fail.

rritik772 commented 4 weeks ago

I guess this is the issue with the node-sql-parser.