diff options
| author | G.J.R. Timmer <gjr.timmer@gmail.com> | 2017-01-31 09:12:47 +0100 |
|---|---|---|
| committer | Jakub Jirutka <jakub@jirutka.cz> | 2017-02-07 11:53:35 +0100 |
| commit | 8aa674ad330af521c81be36fe7e9d7b46308ac5d (patch) | |
| tree | eee73efe83d15fd43d8efdc2e9750bbb3fc0fc01 /main | |
| parent | e528cf1d7e35ba116384c8ebf94391657821efbb (diff) | |
| download | aports-8aa674ad330af521c81be36fe7e9d7b46308ac5d.tar.bz2 aports-8aa674ad330af521c81be36fe7e9d7b46308ac5d.tar.xz | |
main/postgresql: add script for creating pltcl_* tables
Diffstat (limited to 'main')
| -rw-r--r-- | main/postgresql/APKBUILD | 15 | ||||
| -rw-r--r-- | main/postgresql/pltcl_create_tables.sql | 13 |
2 files changed, 24 insertions, 4 deletions
diff --git a/main/postgresql/APKBUILD b/main/postgresql/APKBUILD index 6a53518840..0ea54a2d53 100644 --- a/main/postgresql/APKBUILD +++ b/main/postgresql/APKBUILD @@ -27,6 +27,7 @@ source="ftp://ftp.$pkgname.org/pub/source/v$pkgver/$pkgname-$pkgver.tar.bz2 $pkgname.confd pg-restore.initd pg-restore.confd + pltcl_create_tables.sql " builddir="$srcdir/$pkgname-$pkgver" @@ -164,7 +165,10 @@ pltcl() { _submv usr/bin/pltcl* \ usr/lib/postgresql/pltcl.so \ usr/share/postgresql/unknown.pltcl \ - usr/share/postgresql/extension/pltcl* + usr/share/postgresql/extension/pltcl* || return 1 + + install -m 644 "$srcdir"/pltcl_create_tables.sql \ + "$subpkgdir"/usr/share/postgresql/ } plperl() { @@ -242,18 +246,21 @@ md5sums="92ae6d7cdf18e648b3c22d0aa015565d postgresql-9.6.1.tar.bz2 a7a193cce4443998e3a47fde4f10723e postgresql.initd e63ec8cd30cb33e812f79f06892b6dc4 postgresql.confd 140ed427fe54b435064f0e3c6f683aea pg-restore.initd -bf45384752b320b369f1425939763178 pg-restore.confd" +bf45384752b320b369f1425939763178 pg-restore.confd +fc1d0f757dde9386edfe5be9c44c420e pltcl_create_tables.sql" sha256sums="e5101e0a49141fc12a7018c6dad594694d3a3325f5ab71e93e0e51bd94e51fcd postgresql-9.6.1.tar.bz2 abd3761ecb47e41625d21bfda6a36badb047b0bedfd7cf0b1fbe61914fb3c9bc initdb.patch 83e79ccc98b12d68a9620ae528d6ac37012841a7c120477e05e327fb52eadb38 perl-rpath.patch af57a4190b1f5019290d26429b973d31465a8224a2e552fc3ecaf4fb4e471d7f postgresql.initd 5ad3d9d0cd9d361ce453e5ec28ee04c9a17969842abd0150b5b65bc1967d4ee6 postgresql.confd e509cdb77a4be8a74381b039bb8e5dc3a7b7ef3375785acf967092e4e6a34215 pg-restore.initd -31414d8b57c4cd2116b6014de3f1329875151910753fbd616daec4554866d02f pg-restore.confd" +31414d8b57c4cd2116b6014de3f1329875151910753fbd616daec4554866d02f pg-restore.confd +6ea28d7e0ff2078bc5f307c6cc6d474c759d5f5c543e09bf9ca8e67d992783b0 pltcl_create_tables.sql" sha512sums="f27af67f9a96f6327150330bf091a803e10eabbac4e488cf5e4d72907e2eb1dbde7282fe0b89fd75711fd8bdcdb3688b5a9eac1e4d6871f4e8681c9c8b0e7c45 postgresql-9.6.1.tar.bz2 0b88eee78380ed6cf543c851ac1cea5fc50bb6ef1bb51e03694003f43d2bf4e117ff06657f958d0e9c00ace3b8a6bab6ed0bd017d23f80cfd203dab33da81d46 initdb.patch 5f9d8bb4957194069d01af8ab3abc6d4d83a7e7f8bd7ebe1caae5361d621a3e58f91b14b952958138a794e0a80bc154fbb7e3e78d211e2a95b9b7901335de854 perl-rpath.patch af37b100cc67769817e4c9e997abecf50475d7f0bf9b0f1d51bf8454d45abd6c87d5d315ed6cafd14e0dd059e96723a6203b756236070d12968816666e63e522 postgresql.initd 5b2fe18e38b5bef6fc289ff7701148dd5608d98002db046b183d715b718f96e22c01ba0adc5b590c386694c3eefae1a0a30425b985965ed2238e3858923b91ec postgresql.confd f5a1cba051e7d846c2d16703514601cb25729ed96b677c9bd0c199d64552120a8b14b238af01917fdb87106681e12dee6fff7447558155ba273e4f96be5e2892 pg-restore.initd -c14a5684e914abb3b0ee71bbf15eed71a9264deacaa404a6e3af6bfc330d93e7598624d0ed11a94263106cc660f7f54c8ff57e759033cf606a795f69ff6c1c7c pg-restore.confd" +c14a5684e914abb3b0ee71bbf15eed71a9264deacaa404a6e3af6bfc330d93e7598624d0ed11a94263106cc660f7f54c8ff57e759033cf606a795f69ff6c1c7c pg-restore.confd +5c9bfd9e295dcf678298bf0aa974347a7c311d6e7c2aa76a6920fcb751d01fd1ab77abbec11f3c672f927ad9deaa88e04e370c0b5cd1b60087554c474b748731 pltcl_create_tables.sql" diff --git a/main/postgresql/pltcl_create_tables.sql b/main/postgresql/pltcl_create_tables.sql new file mode 100644 index 0000000000..76c7a954af --- /dev/null +++ b/main/postgresql/pltcl_create_tables.sql @@ -0,0 +1,13 @@ +-- Create tables needed for PL/Tcl autoloading. This script should be run by +-- the database administrator only. +-- +-- Statements in this script are extracted from pltcl_loadmod script. +-- +-- Author: G.J.R. Timmer +-- Date: 2017-01-28 + +create table pltcl_modules (modname name, modseq int2, modsrc text); +create index pltcl_modules_i on pltcl_modules using btree (modname name_ops); + +create table pltcl_modfuncs (funcname name, modname name); +create index pltcl_modfuncs_i on pltcl_modfuncs using hash (funcname name_ops); |