Home

pgutilsL

pgutilsL provides common functionality for PostgreSQL that is being logged by pglogger.

• pgutilsL
  • Thanks
  • Features
  • Screenshots
  • Architecture
  • Installation
  • Usage
  • Code Documentation
  • Change log
  • Main Known Issues
  • Issue Tracking
  • Code Repository
  • License
  • Project Members
  • Miscelaneous

Thanks

Thanks is due to all the project members and to the folks developing
PostgreSQL and all its community.
Thanks to the providers of SourceForge so we can
publish our works to a broader audience. Hopefully it stays clean from add ware
and other nuisances or worse things.

Features

• execute_wo_return_logged: Executes given statement returning the number
  of affected rows and logs to pglogger facility.
  It is not supported to return arbitrary records from the statement execution so
  it is useless for selects. The try of selects will result in an exception.
  Given statement is executed as is, i. e. parametrisation is not supported.
  Please be aware that its search path is restricted to the calling user and the schemata needed for the logging.
  It can be decided whether to only report or to pass on an occurring exception.

$Header$

Screenshots

Architecture

Installation

Full

1. Provide a fairly recent z-shell (5.5.1) or a Windows command line if you do
   not want to run full_install.pg_sql by means of psql against your database
   (only for installation)

2. Provide a PostgreSQL database ;-) (the most recent package has been developed against
   version 11.4)

   • Connect to template1 with postgres.
   • Execute create database <YOUR_APPLICATION_DATABASE>;.

3. Install pglogger -
   pg_scd has been developed against pglogger release 2019-10-08

4. Create your utilsL user <UTILSLUSER> with the create and login privilege onto your application database, e.g
   create role <UTILSLUSER> with password 'Do change this silly password' createdb login;

5. Create your schema <UTILSL> that is owned by <UTILSLUSER>. create schema <UTILSL> authorization <UTILSLUSER>;

6. Unpack the pgutilsL package

7. Adapt set_parameters.pg_sql, full_install.zsh or full_install.bat to
   your setup

8. Run full_install.zsh or full_install.bat or full_install.pg_sql against
   your database

Delta

Deltas are not supported. Please whipe the schema of your last installation
clean and install the full package.

$Header$

Usage

1. Place desired calls to the pgutilsL function into your code. If you do not
   provide the schema information utilsl.<function you awant to call>, you
   need to set the search_path appropriately either in the session or in
   functions/procedures where you use pgutilsL.

$Header$

Code Documentation

The documentation of the code is generated by HyperSQL.

Change log

to 20220512

Improvements

• Improvements on installation description

to 20191011

Improvements

• Improvements on documentation especially on installation description

Main Known Issues

Issue Tracking

For issue tracking the SourceForge Tracker is employed.

Code Repository

As code repository the Subversion installation of SourceForge is used.

License

pgutilsL is under the GNU Affero General Public License v3 (AGPLv3) or later.

Project Members

Project Members:

• Thiemo Kellner (admin)

Miscelaneous

$Header$