-
Notifications
You must be signed in to change notification settings - Fork 3
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
does not handle array types #86
Comments
@SamGrisey Hello! |
Ignore what I said above, the error seems to be with empty array values, not my old db instance.
SELECTING all within psql terminal yields:
so as you can see, all rows have arrays (neither are NULL), yet id 2 was auto-populated by its default value and 3 was explicitly set empty. now on psqlpy, running |
@SamGrisey Okay, I know what’s the problem here, I’ll fix it as soon as I come to my laptop |
@SamGrisey Please check new version - https://github.com/psqlpy-python/psqlpy/releases/tag/0.7.11 |
It would seem that array types are not being recognized properly. If I create a simple table:
then add some rows and do a
the
return res.result()
line causes a crash:The rust code looks like its expecting a postgres type "TEXT ARRAY" but the type is really "text[]". Even if I declare the table column as having type "TEXT ARRAY" instead of "TEXT[]", \d still reports it as "text[]"
EDIT:
It actually works fine with the same simple table on a fresh database, there must be something different with the existing database... but the array column does indeed crash with that error with fetched on the old database, just no idea why now...
The text was updated successfully, but these errors were encountered: