Add feature to install q3c extension in RDS PostgreSQL via pg_tle

[amuthiar]

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]

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]

@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.