Postgresql 9.5 support

[davecramer]

beta version 64bit plr.dll build on win10 using VC 2013

plr-8.3.0.16-pg9.5-win32.zip

[AndreMikulec]

David Cramer,

I tried, but I seemed to have received back errors.:

plr-8.3.0.16-pg9.5-win32
Windows 7 64 bit
R 3.2.4 64 bit(exe)
PostreSQL 9.5.1 64 bit

beta version 64bit plr.dll build on win10 using VC 2013
plr-8.3.0.16-pg9.5-win32.zip
https://github.com/postgres-plr/plr/issues/1

"win32" is in the name. Did you mean this to be tested on "PostgreSQL 9.5.1 32 bit"?

postgres=# select version();

                           version
-------------------------------------------------------------
 PostgreSQL 9.5.1, compiled by Visual C++ build 1800, 64-bit
(1 row)

CREATE OR REPLACE FUNCTION my_function()
  RETURNS text AS
$BODY$ 
    return("done")
$BODY$
  LANGUAGE plr VOLATILE
  COST 100;
ALTER FUNCTION my_function()
  OWNER TO postgres;

postgres=# select my_function();
ERROR:  could not open file "base/12373/2663": No such file or directory
LINE 1: SELECT NULL FROM pg_catalog.pg_class WHERE relname = 'plr_mo...
                         ^
QUERY:  SELECT NULL FROM pg_catalog.pg_class WHERE relname = 'plr_modules' AND relnamespace = 2200
postgres=#

postgres=# select r_version();
ERROR:  could not open file "base/12373/2659": No such file or directory
postgres=#

postgres=# select plr_environ();
ERROR:  could not open file "base/12373/2659": No such file or directory
postgres=#

David Cramer,
In compare and contrast,

Windows 7 64 bit
R 3.1.2 64 bit(exe)
PostreSQL 9.4.1 64 bit
plr-8.3.0.16-pg9.4-win64.zip

CREATE OR REPLACE FUNCTION my_function()
  RETURNS text AS
$BODY$ 
    return("done")
$BODY$
  LANGUAGE plr VOLATILE
  COST 100;
ALTER FUNCTION my_function()
  OWNER TO postgres;

postgres=#
postgres=# select my_function();
 my_function
-------------
 done
(1 row)

postgres=# select r_version();
                    r_version
-------------------------------------------------
 (platform,x86_64-w64-mingw32)
 (arch,x86_64)
 (os,mingw32)
 (system,"x86_64, mingw32")
 (status,"")
 (major,3)
 (minor,1.2)
 (year,2014)
 (month,10)
 (day,31)
 ("svn rev",66913)
 (language,R)
 (version.string,"R version 3.1.2 (2014-10-31)")
 (nickname,"Pumpkin Helmet")
(14 rows)

postgres=# select plr_environ();

...
 (PGDATA,C:/Users/AnonymousUser/Desktop/PostgreSQL.9.4.1/Data/data)
 (PGDATABASE,postgres)
 (PGLOCALEDIR,"C:\\Users\\AnonymousUser\\Desktop\\PostgreSQL.9.4.1\\App\\PgSQL\\share\\")
 (PGLOG,"C:\\Users\\AnonymousUser\\Desktop\\PostgreSQL.9.4.1\\Data\\log.txt")
 (PGSQL,"C:\\Users\\AnonymousUser\\Desktop\\PostgreSQL.9.4.1\\App\\PgSQL")
 (PGSYSCONFDIR,C:/Users/AnonymousUser/Desktop/PostgreSQL.9.4.1/App/PgSQL/etc)
 (PGUSER,postgres)
...
 (R_ARCH,/x64)
 (R_HOME,C:/Users/AnonymousUser/Desktop/R.3.1.2/App/R-Portable)
 (R_LIBS_USER,"C:\\Users\\AnonymousUser\\Documents/R/win-library/3.1")
...

postgres=#

Andre Mikulec
Andre_Mikulec@Hotmail.com

[davecramer]

Hi Andre,

No this is built for 64 bit system. I saw your email to Joe. It uses
R3.2.4, which I see you are using.

I'm kinda thinking your database is corrupt. Any chance you could
re-initialize the cluster ?

Dave

Dave Cramer

On 28 March 2016 at 18:44, AndreMikulec notifications@github.com wrote:

David Cramer,

I tried, but I seemed to have received back errors.:

plr-8.3.0.16-pg9.5-win32
Windows 7 64 bit
R 3.2.4 64 bit(exe)
PostreSQL 9.5.1 64 bit

beta version 64bit plr.dll build on win10 using VC 2013
plr-8.3.0.16-pg9.5-win32.ziphttps://github.com//issues/1

"win32" is in the name. Did you mean this to be tested on "PostgreSQL
9.5.1 32 bit"?

postgres=# select version();

                       version

---

PostgreSQL 9.5.1, compiled by Visual C++ build 1800, 64-bit
(1 row)

CREATE OR REPLACE FUNCTION my_function()
RETURNS text AS
$BODY$
return("done")
$BODY$
LANGUAGE plr VOLATILE
COST 100;ALTER FUNCTION my_function()
OWNER TO postgres;

postgres=# select my_function();
ERROR: could not open file "base/12373/2663": No such file or directory
LINE 1: SELECT NULL FROM pg_catalog.pg_class WHERE relname = 'plr_mo...
^
QUERY: SELECT NULL FROM pg_catalog.pg_class WHERE relname = 'plr_modules' AND relnamespace = 2200
postgres=#

postgres=# select r_version();
ERROR: could not open file "base/12373/2659": No such file or directory
postgres=#

postgres=# select plr_environ();
ERROR: could not open file "base/12373/2659": No such file or directory
postgres=#

David Cramer,
In compare and contrast,

Windows 7 64 bit
R 3.1.2 64 bit(exe)
PostreSQL 9.4.1 64 bit
plr-8.3.0.16-pg9.4-win64.zip

CREATE OR REPLACE FUNCTION my_function()
RETURNS text AS
$BODY$
return("done")
$BODY$
LANGUAGE plr VOLATILE
COST 100;ALTER FUNCTION my_function()
OWNER TO postgres;

postgres=#
postgres=# select my_function();

my_function

done
(1 row)

postgres=# select r_version();

r_version

(platform,x86_64-w64-mingw32)
(arch,x86_64)
(os,mingw32)
(system,"x86_64, mingw32")
(status,"")
(major,3)
(minor,1.2)
(year,2014)
(month,10)
(day,31)
("svn rev",66913)
(language,R)
(version.string,"R version 3.1.2 (2014-10-31)")
(nickname,"Pumpkin Helmet")
(14 rows)

postgres=# select plr_environ();

...
(PGDATA,C:/Users/AnonymousUser/Desktop/PostgreSQL.9.4.1/Data/data)
(PGDATABASE,postgres)
(PGLOCALEDIR,"C:\Users\AnonymousUser\Desktop\PostgreSQL.9.4.1\App\PgSQL\share")
(PGLOG,"C:\Users\AnonymousUser\Desktop\PostgreSQL.9.4.1\Data\log.txt")
(PGSQL,"C:\Users\AnonymousUser\Desktop\PostgreSQL.9.4.1\App\PgSQL")
(PGSYSCONFDIR,C:/Users/AnonymousUser/Desktop/PostgreSQL.9.4.1/App/PgSQL/etc)
(PGUSER,postgres)
...
(R_ARCH,/x64)
(R_HOME,C:/Users/AnonymousUser/Desktop/R.3.1.2/App/R-Portable)
(R_LIBS_USER,"C:\Users\AnonymousUser\Documents/R/win-library/3.1")
...

postgres=#

Andre Mikulec
Andre_Mikulec@Hotmail.com

—
You are receiving this because you authored the thread.
Reply to this email directly or view it on GitHub
#1 (comment)

[AndreMikulec]

Dave Cramer,

Something different and better happened.
After initializing, the following does work.

select plr_environ();

However,

my_function() and r_version()

still do not work

Using: 64bit everything . . .

Windows 7 & 
R3.2.4 & 
PostgreSQL.9.4.1 &
plr-8.3.0.16-pg9.5-win32.zip

Initializing

C:\Users\AnonymousUser\Desktop\PostgreSQL.9.5.1>chcp 1252  1>nul

C:\Users\AnonymousUser\Desktop\PostgreSQL.9.5.1>if not exist "C:\Users\AnonymousUser\Desktop\PostgreSQL.9.5.1\Data\data" (
echo.
 echo Initialising database for first use, please wait...
 "C:\Users\AnonymousUser\Desktop\PostgreSQL.9.5.1\App\PgSQL\bin\initdb" -U postgres -A trust -E utf8 --locale=C  1>nul
)

Initialising database for first use, please wait...

Then I create the extension.

postgres=# create extension plr;
CREATE EXTENSION
postgres=#

Then I try . . .

postgres=# select version();
                           version
-------------------------------------------------------------
 PostgreSQL 9.5.1, compiled by Visual C++ build 1800, 64-bit
(1 row)

CREATE OR REPLACE FUNCTION my_function()
  RETURNS text AS
$BODY$ 
    return("done")
$BODY$
  LANGUAGE plr VOLATILE
  COST 100;
ALTER FUNCTION my_function()
  OWNER TO postgres;

postgres=# select my_function();
ERROR:  could not open file "base/12373/2689": No such file or directory
CONTEXT:  SQL statement "SELECT NULL FROM pg_catalog.pg_class WHERE relname = 'plr_modules' AND relnamespace = 2200"
postgres=#

postgres=# select r_version();
ERROR:  could not open file "base/12373/2689": No such file or directory
CONTEXT:  SQL statement "SELECT NULL FROM pg_catalog.pg_class WHERE relname = 'plr_modules' AND relnamespace = 2200"
postgres=#

Now, this works ( before database re-initializaton, this did not work. )

postgres=#
postgres=# select plr_environ();

------------------------------
------------------------------
...
 (PGDATA,C:/Users/AnonymousUser/Desktop/PostgreSQL.9.5.1/Data/data)
 (PGDATABASE,postgres)
 (PGLOCALEDIR,"C:\\Users\\AnonymousUser\\Desktop\\PostgreSQL.9.5.1\\App\\PgSQL\\share")
 (PGLOG,"C:\\Users\\AnonymousUser\\Desktop\\PostgreSQL.9.5.1\\Data\\log.txt")
 (PGPORT,5432)
 (PGSQL,"C:\\Users\\AnonymousUser\\Desktop\\PostgreSQL.9.5.1\\App\\PgSQL")
 (PGSYSCONFDIR,C:/Users/AnonymousUser/Desktop/PostgreSQL.9.5.1/App/PgSQL/etc)
 (PGUSER,postgres)
 ...
 (R_ARCH,/x64)
 (R_HOME,C:/Users/AnonymousUser/Desktop/R-3.2.4)
 (R_KEEP_PKG_SOURCE,yes)
 (R_LIBS_USER,"C:\\Users\\AnonymousUser\\Documents/R/win-library/3.2")
 (R_USER,"C:\\Users\\AnonymousUser\\Documents")
...
(153 rows)

Thank you,
Andre Mikulec
Andre_Mikulec@Hotmail.com

[davecramer]

Hi Andre,

Well that's sort of good news ;)

Did you create the modules table in the database you are connecting to ?

Dave Cramer

On 29 March 2016 at 01:21, AndreMikulec notifications@github.com wrote:

Dave Cramer,

Something different and better happened.
After initializing, the following does work.

select plr_environ();

However,

my_function() and r_version()

still do not work

Using: 64bit everything . . .

Windows 7 &
R3.2.4 &
PostgreSQL.9.4.1 &
plr-8.3.0.16-pg9.5-win32.zip

Initializing

C:\Users\AnonymousUser\Desktop\PostgreSQL.9.5.1>chcp 1252 1>nul

C:\Users\AnonymousUser\Desktop\PostgreSQL.9.5.1>if not exist "C:\Users\AnonymousUser\Desktop\PostgreSQL.9.5.1\Data\data" (
echo.
echo Initialising database for first use, please wait...
"C:\Users\AnonymousUser\Desktop\PostgreSQL.9.5.1\App\PgSQL\bin\initdb" -U postgres -A trust -E utf8 --locale=C 1>nul
)

Initialising database for first use, please wait...

Then I create the extension.

postgres=# create extension plr;
CREATE EXTENSION
postgres=#

Then I try . . .

postgres=# select version();

version

PostgreSQL 9.5.1, compiled by Visual C++ build 1800, 64-bit
(1 row)

CREATE OR REPLACE FUNCTION my_function()
RETURNS text AS
$BODY$
return("done")
$BODY$
LANGUAGE plr VOLATILE
COST 100;ALTER FUNCTION my_function()
OWNER TO postgres;

postgres=# select my_function();
ERROR: could not open file "base/12373/2689": No such file or directory
CONTEXT: SQL statement "SELECT NULL FROM pg_catalog.pg_class WHERE relname = 'plr_modules' AND relnamespace = 2200"
postgres=#

postgres=# select r_version();
ERROR: could not open file "base/12373/2689": No such file or directory
CONTEXT: SQL statement "SELECT NULL FROM pg_catalog.pg_class WHERE relname = 'plr_modules' AND relnamespace = 2200"
postgres=#

Now, this works ( before database re-initializaton, this did not work. )

postgres=#
postgres=# select plr_environ();

---

---

...
(PGDATA,C:/Users/AnonymousUser/Desktop/PostgreSQL.9.5.1/Data/data)
(PGDATABASE,postgres)
(PGLOCALEDIR,"C:\Users\AnonymousUser\Desktop\PostgreSQL.9.5.1\App\PgSQL\share")
(PGLOG,"C:\Users\AnonymousUser\Desktop\PostgreSQL.9.5.1\Data\log.txt")
(PGPORT,5432)
(PGSQL,"C:\Users\AnonymousUser\Desktop\PostgreSQL.9.5.1\App\PgSQL")
(PGSYSCONFDIR,C:/Users/AnonymousUser/Desktop/PostgreSQL.9.5.1/App/PgSQL/etc)
(PGUSER,postgres)
...
(R_ARCH,/x64)
(R_HOME,C:/Users/AnonymousUser/Desktop/R-3.2.4)
(R_KEEP_PKG_SOURCE,yes)
(R_LIBS_USER,"C:\Users\AnonymousUser\Documents/R/win-library/3.2")
(R_USER,"C:\Users\AnonymousUser\Documents")
...
(153 rows)

Thank you,
Andre Mikulec
Andre_Mikulec@Hotmail.com

—
You are receiving this because you authored the thread.
Reply to this email directly or view it on GitHub
#1 (comment)

[AndreMikulec]

Dave Cramer,

I just tried. The result is the same.

psql (9.5.1)
Type "help" for help.

postgres=# CREATE TABLE plr_modules (
postgres(#   modseq int4 primary key,
postgres(#   modsrc text
postgres(# );
CREATE TABLE
postgres=#
postgres=# select my_function();
ERROR:  could not open file "base/12373/2689": No such file or directory
CONTEXT:  SQL statement "SELECT NULL FROM pg_catalog.pg_class WHERE relname = 'plr_modules' AND relnamespace = 2200"
postgres=#
postgres=# select r_version();
ERROR:  could not open file "base/12373/2689": No such file or directory
CONTEXT:  SQL statement "SELECT NULL FROM pg_catalog.pg_class WHERE relname = 'plr_modules' AND relnamespace = 2200"
postgres=#

Thank you,
Andre Mikulec
Andre_Mikulec@Hotmail.com

[davecramer]

Andre,

I'm not sure what's going on here. I presume if you look on the filesystem
you will find the files mentioned.

I also seem to recall that if you execute the query "SELECT NULL FROM
pg_catalog.pg_class WHERE relname = 'plr_modules' AND relnamespace = 2200"

in psql it works fine.

That leaves us with permissions problems ( I think ). Have you ever
tried this in a database other than postgres ?

Sorry, but I am grasping at straws. You could modify the
postgresql.conf file and set log_min_messages to DEBUG1 to get more
logging info.

Dave

Dave Cramer

On 29 March 2016 at 18:52, AndreMikulec notifications@github.com wrote:

Dave Cramer,

I just tried. The result is the same.

psql (9.5.1)
Type "help" for help.

postgres=# CREATE TABLE plr_modules (
postgres(# modseq int4 primary key,
postgres(# modsrc text
postgres(# );
CREATE TABLE
postgres=#
postgres=# select my_function();
ERROR: could not open file "base/12373/2689": No such file or directory
CONTEXT: SQL statement "SELECT NULL FROM pg_catalog.pg_class WHERE relname = 'plr_modules' AND relnamespace = 2200"
postgres=#
postgres=# select r_version();
ERROR: could not open file "base/12373/2689": No such file or directory
CONTEXT: SQL statement "SELECT NULL FROM pg_catalog.pg_class WHERE relname = 'plr_modules' AND relnamespace = 2200"
postgres=#

Thank you,
Andre Mikulec
Andre_Mikulec@Hotmail.com

—
You are receiving this because you authored the thread.
Reply to this email directly or view it on GitHub
#1 (comment)

[AndreMikulec]

David Cramer,

Working out of here.  I (AnonoymousUser) already had full control:
C:\\Users\\AnonymousUser\\Desktop\\PostgreSQL.9.5.1  
I added full control to Users and Everyone.  That still did not help.

Have you ever tried this in a database other than postgres ?

These error are unique to the combination of PostgreSQL with plr.

set log_min_messages to DEBUG1

O.K. I have done that.  I am not seeing any useful information.  
It seem to be mostly just repeating what I see on the console.

If any ideas come up. I am all ears.
Email me back. I will be happy to try.

Thank you,
Andre Mikulec
Andre_Mikulec@Hotmail.com

[davecramer]

Andre,

I believe the messages should be in the EventViewer.

You may also have to set log_min_duration_statement to 0 to log everything.

Dave Cramer

On 29 March 2016 at 20:26, AndreMikulec notifications@github.com wrote:

David Cramer,

Working out of here. I (AnonoymousUser) already had full control:
C:\Users\AnonymousUser\Desktop\PostgreSQL.9.5.1
I added full control to Users and Everyone. That still did not help.

Have you ever tried this in a database other than postgres ?

These error are unique to the combination of PostgreSQL with plr.

set log_min_messages to DEBUG1

O.K. I have done that. I am not seeing any useful information.
It seem to be mostly just repeating what I see on the console.

If any ideas come up. I am all ears.

Email me back. I will be happy to try.

Thank you,
Andre Mikulec
Andre_Mikulec@Hotmail.com

—
You are receiving this because you authored the thread.
Reply to this email directly or view it on GitHub
#1 (comment)