Menu ▾ ▴

Home

Thiemo Kellner

pgutils

pgutils provides very basic functionality for PostgreSQL so even pglogger is relying on them.

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

  • get_caller_function: Returns the name of the x-th function of the call
    stack before this function.
    Setting I_N°_OF_FUNCTIONS_BEFORE_THIS to 2 gives the caller of the caller of
    this function what usually is what one wants.
  • get_default_entry_process_id: Returns text for the default of the entry
    process id columns.
  • get_formatted_exception_message: Returns a formatted string for exception
    information.

$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. Create your utils user <UTILSUSER> with the create and login privilege onto your application database, e.g
    create role <UTILSUSER> with password 'Do change this silly password' createdb login;

  4. Create your utils schema <UTILS> that is owned by <UTILSUSER>.
    create schema <UTILS> authorization <UTILSUSER>;

  5. Unpack the pgutils package

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

  7. 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 pgutils function into your code. If you do not
    provide the schema information utils.<function you awant to call>, you
    need to set the search_path appropriately either in the session or in
    functions/procedures where you use pgutils.

$Header$

Code Documentation

The documentation of the code is generated by HyperSQL.

Change log

to 20220512

Improvements

  • Improvements on installation description
  • Bug in the installer fixed

to 20191011

Improvements

  • Improvements on documentation especially on installation description

to 20191008

Improvements

  • License mess cleaned up.

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

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

Project Members

Project Members:

Miscelaneous

$Header$