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

Problem with Array and Geometry #436

Closed
gustaflindqvist opened this Issue Sep 24, 2017 · 2 comments

Comments

Projects
None yet
2 participants
@gustaflindqvist

gustaflindqvist commented Sep 24, 2017

Using ARRAY with two GEOMETRY Linestring geometry(LineString)[] in Postgres via GIS extension and getting query failed:

Could not load table rows.
Query failed
PostgreSQL said: function st_asewkt(geometry[]) does not exist
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
@jakob

This comment has been minimized.

Show comment
Hide comment
@jakob

jakob Sep 25, 2017

Owner

Thanks for the bug report! There was a bug in the typ checking code, so Postico thought it was a geometry type, and wrapped the value in st_asewkt for more readable output -- but of course this doesn't work with arrays.

I've now fixed the type checking code.

The newest build now works with columns of this type. Please download build 1858 from https://eggerapps.at/postico/builds/

Unfortunately however, these columns then only show up as binary gibberish in Postico...

Owner

jakob commented Sep 25, 2017

Thanks for the bug report! There was a bug in the typ checking code, so Postico thought it was a geometry type, and wrapped the value in st_asewkt for more readable output -- but of course this doesn't work with arrays.

I've now fixed the type checking code.

The newest build now works with columns of this type. Please download build 1858 from https://eggerapps.at/postico/builds/

Unfortunately however, these columns then only show up as binary gibberish in Postico...

@gustaflindqvist

This comment has been minimized.

Show comment
Hide comment
@gustaflindqvist

gustaflindqvist Sep 25, 2017

@jakob Awesome work! Nice to resolve bugs in speed sometimes! 👍

Yeah. A lot of work needs to be done for not having binary gibberish, I guess.

gustaflindqvist commented Sep 25, 2017

@jakob Awesome work! Nice to resolve bugs in speed sometimes! 👍

Yeah. A lot of work needs to be done for not having binary gibberish, I guess.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment