Group :: Databases
RPM: postgresql15-iplike
Main Changelog Spec Patches Sources Download Gear Bugs and FR Repocop
%define pg_ver 15
%define prog_name iplike
Name: postgresql%pg_ver-%prog_name
Version: 2.3.0
Release: alt2
License: GPL
Group: Databases
Summary: PostgreSQL complex IP Address text field query
Source: %prog_name-%version.tar.gz
URL: http://www.opennms.org
# Automatically added by buildreq on Thu Jun 21 2007
#BuildRequires: gcc-c++ postgresql%pg_ver-server-devel
BuildRequires: postgresql%pg_ver-server-devel
Requires: postgresql%pg_ver-server
Conflicts: iplike
Conflicts: libiplike
%description
PostgreSQL function for doing complex IP address queries
on a text field.
%prep
%setup -n %prog_name-%version
%build
%autoreconf
%configure --with-pgsql=%_bindir/pg_server_config
%make
%install
%makeinstall_std
%post
echo "Execute the following psql command inside any database that you want to install or update:"
echo "CREATE OR REPLACE FUNCTION iplike(i_ipaddress text,i_rule text) RETURNS bool AS '$$libdir/iplike.so' LANGUAGE 'c' RETURNS NULL ON NULL INPUT;"
%files
%_libdir/pgsql/*.so
%changelog
…
Full changelog you can see here
%define prog_name iplike
Name: postgresql%pg_ver-%prog_name
Version: 2.3.0
Release: alt2
License: GPL
Group: Databases
Summary: PostgreSQL complex IP Address text field query
Source: %prog_name-%version.tar.gz
URL: http://www.opennms.org
# Automatically added by buildreq on Thu Jun 21 2007
#BuildRequires: gcc-c++ postgresql%pg_ver-server-devel
BuildRequires: postgresql%pg_ver-server-devel
Requires: postgresql%pg_ver-server
Conflicts: iplike
Conflicts: libiplike
%description
PostgreSQL function for doing complex IP address queries
on a text field.
%prep
%setup -n %prog_name-%version
%build
%autoreconf
%configure --with-pgsql=%_bindir/pg_server_config
%make
%install
%makeinstall_std
%post
echo "Execute the following psql command inside any database that you want to install or update:"
echo "CREATE OR REPLACE FUNCTION iplike(i_ipaddress text,i_rule text) RETURNS bool AS '$$libdir/iplike.so' LANGUAGE 'c' RETURNS NULL ON NULL INPUT;"
%files
%_libdir/pgsql/*.so
%changelog
…
Full changelog you can see here