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

Unknown type OID: 116 #74

Open
santosh-1987 opened this issue Sep 8, 2020 · 1 comment
Open

Unknown type OID: 116 #74

santosh-1987 opened this issue Sep 8, 2020 · 1 comment

Comments

@santosh-1987
Copy link

santosh-1987 commented Sep 8, 2020

Vertica raises an exception for GEOM datatype

Screenshot 2020-09-08 at 2 12 10 PM

Screenshot 2020-09-08 at 2 17 16 PM

@wvanbergen
Copy link
Owner

Pretty sure this library has never been used before with any geometry type. I don't know enough about geometry types, not do I have a testing database available to me anymore, so I don't really know, not can I figure out, what the best way to handle this type is. Happy to accept PRs though.

What needs to happen is that this type needs to be translated to a Ruby type. Types and how they are converted is defined here: https://github.com/wvanbergen/vertica/blob/master/lib/vertica/data_type.rb#L133-L146. You can add something like

Vertica::DataType.register 116, 'geom', :converter_func

Where :converted_func is the function you want to use to convert the data into a Ruby type. You can either use an existing (e.g. :binary_string) or add a new one)

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

2 participants