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:Rebuild/postgresql-plr && cd $_ - Create Badge
Source Files
| Filename | Size | Changed |
|---|---|---|
| REL8_4_5.tar.gz | 0000273711 267 KB | |
| _multibuild | 0000000197 197 Bytes | |
| patch-Makefile-ldflags.patch | 0000001027 1 KB | |
| plr-US.pdf | 0000167371 163 KB | |
| postgresql-plr.changes | 0000010032 9.8 KB | |
| postgresql-plr.spec | 0000005156 5.04 KB | |
| readme.SUSE | 0000001847 1.8 KB | |
| series | 0000000029 29 Bytes |
Revision 5 (latest revision is 7)
Dominique Leuenberger (dimstar_suse)
accepted
request 1080340
from
Reinhard Max (rmax)
(revision 5)
- PostgreSQL 10 is EOL.
- refresh patch-Makefile-ldflags.patch
- enable pg 13 and 14
- update to 8.4.5
- added sql upgrade path to fix
- changes from 8.4.4
- changed files names to be consistent with extension version
- changes from 8.4.3
- reverted part of PR#88. postgres has reverted the changes to
hex_decode that made it necessary (#120)
- changes from 8.4.2
- Changed R version to 4.10.
- Added support for transactions in procedures. @petere
- Added support for pg custom type (tuple) arguments in window
functions
Comments 0