BSD Ports

databases/postgresql-prefix 1.2.10_1 MidnightBSD

Prefix Range module for PostgreSQL

System
MidnightBSD
Repository
mports
Maintainer
[email protected]
Port added
Last update
Commit
1bb90fba00
License
pgsql
Categories
databases

Description

Prefix matching is both very common and important in telephony applications, where call routing and costs depend on matching caller/callee phone number to an operator prefix.

Let's say the prefixes table is called prefixes, a typical query will try to match a phone number to the longest prefix in the table:

SELECT * FROM prefixes WHERE prefix @> '0123456789' ORDER BY length(prefix) DESC LIMIT 1;

In the other systems

SystemPortVersion
MidnightBSDdatabases/postgresql-prefix1.2.10_1
FreeBSDdatabases/postgresql-prefix1.2.10
DragonFlydatabases/postgresql-prefix1.2.10
HardenedBSDdatabases/postgresql-prefix1.2.10
GhostBSDdatabases/postgresql-prefix1.2.10

Install

Binary package:

mport install postgresql${PGSQL_VER:S/.//}-prefix

From mports:

cd /usr/mports/databases/postgresql-prefix && make install clean

To depend on this port in another port's Makefile:

RUN_DEPENDS=	postgresql${PGSQL_VER:S/.//}-prefix>0:databases/postgresql-prefix

Dependencies

No port depends on this one.

Configuration

Options name: databases_prefix

OptionDefaultDescription
DOCSoff
USES
gmake pgsql:11+
Service scripts
none

Files

pkg-plist 7
  • lib/postgresql/prefix.so
  • share/doc/postgresql${PGSQL_VER:S/.//}-prefix/README.md
  • share/doc/postgresql${PGSQL_VER:S/.//}-prefix/TESTS.md
  • share/postgresql/extension/prefix--1.1--1.2.0.sql
  • share/postgresql/extension/prefix--1.2.0.sql
  • share/postgresql/extension/prefix--unpackaged--1.2.0.sql
  • share/postgresql/extension/prefix.control
distinfo 1
FileSizeSHA256
dimitri-prefix-v1.2.10_GH0.tar.gz756544342f251432a5f6fb05b8597139d3ccde8dcf87e8ca1498e7ee931ca057a8575

Commit history 2

DateCommitCreditsLog message
1bb90fba00 Lucas Holt databases/postgresql-prefix: fix the staging path in the option install targets
The option helper targets (post-install-DOCS-on and friends) are entries in _FAKE_SEQ and run in the main make, not in the sub-make that fake-post-install starts with FAKE_SETUP. There PREFIX is not stage-prefixed and STAGEDIR is empty, so ${STAGEDIR}${DOCSDIR} resolved to the live /usr/local: the build wrote outside the stage directory and the file was then reported missing, e.g. install ... README.rst /usr/local/share/doc/py312-webcolors /usr/local/share/doc/py312-webcolors/README.rst not installed. Fake failed. Use ${FAKE_DESTDIR} in these targets, as x11-wm/icewm already does. AI-Assisted-by: Claude Opus 5 (1M context) <[email protected]> Signed-off-by: Lucas Holt <[email protected]>
43c28f8bd0 Lucas Holt Add PostgreSQL 15-18 ports and update database ports
Import the missing PostgreSQL version families and extensions, extend pgsql version selection, and update PostgreSQL 14, JDBC, and libpqxx. AI-Assisted-by: OpenAI Codex <[email protected]> Signed-off-by: Lucas Holt <[email protected]>