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

LONGBLOB datatype is not supported on PostgreSQL #440

Closed
rodrigopv opened this issue Apr 11, 2021 · 0 comments
Closed

LONGBLOB datatype is not supported on PostgreSQL #440

rodrigopv opened this issue Apr 11, 2021 · 0 comments
Labels
bug An existing feature is not working as intended

Comments

@rodrigopv
Copy link
Contributor

Describe the bug
I'm re-creating an existing PostgreSQL database for my open-source project. I need to store small files, for which postgres uses the bytea data type. When looking into docs, the closes one we have is Binary, but it seems to try using a non-existent datatype for postgres when looking into the SQL output of masonite-orm migrate -s.

To Reproduce
Steps to reproduce the behavior:

  1. Create migration with a binary filetype when using PostgreSQL database.
  2. Execute or preview migration SQL to check the output
  3. Expect to see PostgreSQL error 2021-04-11 21:49:07.609 UTC [530] ERROR: type "longblob" does not exist at character 109 during migration

Expected behavior
ORM should try to create the column with bytea data type.

Screenshots or code snippets
Screenshots help a lot. If applicable, add screenshots to help explain your problem.
image

What database are you using?

  • Type: Postgres + TimescaleDB (docker image: timescale/timescaledb:2.1.1-pg13)
  • Version: 13
  • Masonite ORM masonite-orm==1.0.45
@rodrigopv rodrigopv added the bug An existing feature is not working as intended label Apr 11, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug An existing feature is not working as intended
Projects
None yet
Development

No branches or pull requests

1 participant