CODEWITHSUNDEEP
sqlrpostgresqlplr
khajlk
khajlk

Reputation: 861

PostgreSQL: PL/R does not work as expected

Using this tutorial of BostonGIS, I installed PL/R as an extension in my PostgreSQL 9.5 (x64) DB at Windows 7 Enterprise (x64) machine. After installation, I tested PL/R by running:

SELECT * FROM plr_environ();

and it returned environment information. Then, I ran:

SELECT load_r_typenames();

and the command took 5 minutes (and counting..) and never executed completely. I was unsure that if something is messed up or how long this query should take. Thus, in another SQL editor, I tried following piece of code (source: here):

CREATE OR REPLACE FUNCTION plr_fn()
RETURNS float8 AS
$BODY$
  x <- 10
  4/3*pi*x^3
$BODY$
LANGUAGE 'plr'

Then, I called this function using:

SELECT plr_fn();

Again, the query took forever and was never completed. I am bit puzzled that what went wrong in PL/R installation as I followed all steps and set the environment variables. Can someone help me to understand what is wrong with my PL/R installation?

Upvotes: 1

Views: 101

Answers (0)

Related Questions