PL/R - R Procedural Language for PostgreSQL
PL/R is a loadable procedural language that enables you to write PostgreSQL functions and triggers in the R programming language. PL/R offers most (if not all) of the capabilities a function writer has in the R language.
Commands are available to access the database via the PostgreSQL Server Programming Interface (SPI) and to raise messages via elog() . There is no way to access internals of the database backend. However the user is able to gain OS-level access under the permissions of the PostgreSQL user ID, as with a C function. Thus, any unprivileged database user should not be permitted to use this language. It must be installed as an untrusted procedural language so that only database superusers can create functions in it. The writer of a PL/R function must take care that the function cannot be used to do anything unwanted, since it will be able to do anything that could be done by a user logged in as the database administrator.
An implementation restriction is that PL/R procedures cannot be used to create input/output functions for new data types.
- Developed at server:database:postgresql
- Sources inherited from project openSUSE:Factory
-
1
derived packages
- Download package
-
Checkout Package
osc -A https://api.opensuse.org checkout openSUSE:Factory:RISCV/postgresql-plr && cd $_
- Create Badge
Source Files
Filename | Size | Changed |
---|---|---|
REL8_3_0_17.tar.gz | 0000074017 72.3 KB | |
_multibuild | 0000000197 197 Bytes | |
patch-Makefile-ldflags.patch | 0000000839 839 Bytes | |
plr-US.pdf | 0000167371 163 KB | |
postgresql-plr.changes | 0000006785 6.63 KB | |
postgresql-plr.spec | 0000005065 4.95 KB | |
readme.SUSE | 0000001847 1.8 KB |
Revision 1 (latest revision is 7)
- use _multibuild As such it should replace any variant of postgresql-plr we have in factory. - Packaging + Make comment versionable + Remove obsoleted macro (mkdir, install) + Fix copyright line - Remove non maintained postgresql version 9.1 9.2 - Undo the rename of postgresql-plr.changes.in to make happy factory auto-bot - Update to 08.03.00.17 version - Bring support to postgresql96 - Packaging + Move source to github and adapt packaging for that + Add plr-US.pdf as documentation, html being not delivered Documentation is build outside of the package to avoid texlive + Redone patch-Makefile-ldflags.patch to current sources + Rename postgresql-plr.changes.in to postgresql-plr.changes to ease osc vc edition, adapt pre_checking.sh to this change. Fri Dec 21 07:35:00 UTC 2015 - bruno@ioda-net.ch - Fix postun/postin ldconfig call (see comment in sr#345782) Fri Feb 13 13:13:13 UTC 2015 - bruno@ioda-net.ch - Update to last upstream tar.gz Due to missing root plr, and documentation (Conway) - Removed upgrade alter extension, this doesn't work yet - Update to upstream 8.3.0.16 Update for PostgreSQL 9.5dev compatibility Update copyrights Add check and throw an error when don't have an expectedDesc. Remove autocommit setting -- it has been removed in PostgreSQL 9.5, and it has been ineffective for a long time. Reported by Peter E. Fix RPM spec file (redhat) - Added support to postgresql94 packages - modified patches: redone for 8.0.16 * patch-Makefile-ldflags.patch - Revised year - Added pre_checkin.sh methode to create variant packages - Update to upstream 8.0.15 Update for PostgreSQL 9.3 compatibility Ensure certain errors in R code do not crash postgres Unbreak compilation with older versions of postgres not having rangetypes Allow use of OUT parameters - modified patches: redone for 8.0.15 * patch-Makefile-ldflags.patch - Packaging postgresql-plr Added postgresql-server as BuildRequires so rpmlint doesn't complain about owner of postgresql base install directory - split postgresql-plr to postgresql version aligned postgresql91-plr linked to postgresql91 postgresql92-plr linked to postgresql92 postgresql93-plr linked to postgresql93 - Upgrade to 8.3.0.14 Update copyright for 2013 Remove hack to take signal back from R interpreter (Mark Kirkwood) Set R_SignalHandlers = 0, the proper way to prevent R from taking signals in the first place (Mark Kirkwood) Adjust RPM spec file As of pg9.2 the syntax "LANGUAGE 'C'" no longer works. Use "LANGUAGE C" instead. The MacPorts installation has the header filed distributed across two different directories, so there is no single "rincludedir" to query from pkg-config. Instead, do it the proper way and ask pkg-config for the cflags, which should work for all installation variants. (Peter Eisentraut) * Upgrade to 8.3.0.13.1 - Fix CREATE FUNCTION statements so that they work with PostgreSQL 9.2.x - Make factory happy added R-base as Build-Require - Fix formatting & licence scheme - Fix installation directory : goes to extension now - Added missing expected plr.out to doc as sample howto - Split documentation to postgresql-plr - Add more informations (first step and test to readme.SUSE) - Try to use -rpath (following darix advise) but no success * Upgrade to 8.3.0.13 - Fix Makefile so that msvc scripts can process it successfully - Add support for pgsql 9.1 CREATE EXTENSION - Put in safeguard to prevent attempted return of non-data (e.g. closure) types from R unless the pg return type is BYTEA - Correct thinko from earlier pass-by-val array optimization - Fix crashbug related to conversion of R data.frame to Postgres array on function return - Add plr_version() function: outputs a version string - New feature: allow PL/R functions to be declared and used as WINDOW functions - Minor fixes for compiler warnings by updated gcc - Fix missing calls to UNPROTECT. Report and patch by Ben Leiting. - Take SIGINT back into Postgres control from R. Report and test case by Terry Schmitt. - Don't try to free an array element value when the array element is NULL - Allow pg.spi.prepare/pg.spi.execp to use parameters which are 1D arrays- - Fixed spurious perms - Try to fix folders installation - First spec version for obs
Comments 0