Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Database migration does not work with PostgreSQL #982

Open
vlaborie opened this issue Apr 17, 2024 · 0 comments
Open

Database migration does not work with PostgreSQL #982

vlaborie opened this issue Apr 17, 2024 · 0 comments

Comments

@vlaborie
Copy link

Hello,

2024-04-16 23:27:44.837 CEST [277613] warpgate@warpgate ERROR:  syntax error at or near "`" at character 13
2024-04-16 23:27:44.837 CEST [277613] warpgate@warpgate STATEMENT:  ALTER TABLE `tickets` MODIFY COLUMN `expiry` TIMESTAMP NULL DEFAULT NULL

Caracter ` (backtick) is not supported by PostgreSQL.

This request is hardcoded in warpgate-db-migrations/src/m00001_create_ticket.rs but is not compatible with PostgreSQL.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant