How to Install and Uninstall postgresql16-plr Package on openSuSE Tumbleweed

Last updated: November 15,2024

1. Install "postgresql16-plr" package

Please follow the guidelines below to install postgresql16-plr on openSuSE Tumbleweed


    
        
            $
        

        
            
                sudo zypper refresh
            
                    
    
    Copied


    
        
            $
        

        
            
                sudo zypper install
            
                        
                postgresql16-plr
            
                    
    
    Copied

2. Uninstall "postgresql16-plr" package

Please follow the step by step instructions below to uninstall postgresql16-plr on openSuSE Tumbleweed:


    
        
            $
        

        
            
                sudo zypper remove
            
                        
                postgresql16-plr
            
                    
    
    Copied

3. Information about the postgresql16-plr package on openSuSE Tumbleweed

Information for package postgresql16-plr:
-----------------------------------------
Repository : openSUSE-Tumbleweed-Oss
Name : postgresql16-plr
Version : 8.4.6-2.1
Arch : x86_64
Vendor : openSUSE
Installed Size : 99.5 KiB
Installed : No
Status : not installed
Source package : postgresql16-plr-8.4.6-2.1.src
Upstream URL : https://github.com/postgres-plr/plr/
Summary : PL/R - R Procedural Language for PostgreSQL
Description :
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.