Add feature to install q3c extension in RDS PostgreSQL via pg_tle

aws / pg_tle

Framework for building trusted language extensions for PostgreSQL

Apache License 2.0

336 stars 31 forks source link

Add feature to install q3c extension in RDS PostgreSQL via pg_tle #182

Open amuthiar opened 1 year ago

amuthiar commented 1 year ago

Describe the problem

What are you trying to solve? I'm trying to install the q3c exntesion in RDS Aurora PostgreSQL using pg_tle, but it gives me the following error.

test => CREATE EXTENSION q3c; ERROR: permission denied for language c

Describe the proposal

What is the feature you are proposing? Add feature to support language c to install q3c extension.
How would it solve the problem? It helps the astronomical community where q3c extension is being mainly used for Spatial Index queries.

Describe alternatives

How would you solve the problem today if the feature is not built? PostGIS is the alternative in RDS for q3c.
What other alternatives are there? PostGIS is the alternative in RDS for q3c.

amuthiar commented 1 year ago

The above error "ERROR: permission denied for language c" has occurred after successfully completing the step in the attached file q3c_pg_tle.txt

jkatz commented 1 year ago

@amuthiar Thanks for your interest in pg_tle!

q3c will not work with pg_tle as written as there are functions that are defined in C. These functions would need to be ported to another procedural language (e.g. JavaScript). I took a quick look at the extension and it does seem like this would be doable based on what's written with the exception of the selectivity functions.

In summary, q3c could ultimately be used with pg_tle if the C functions are rewritten.