Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 22 Oct 2015 23:47:45 +0000
From:      bugzilla-noreply@freebsd.org
To:        freebsd-ports-bugs@FreeBSD.org
Subject:   [Bug 203949] [new port] databases/pguri: uri datatype extension for PostgreSQL
Message-ID:  <bug-203949-13-T6je0NOX1r@https.bugs.freebsd.org/bugzilla/>
In-Reply-To: <bug-203949-13@https.bugs.freebsd.org/bugzilla/>
References:  <bug-203949-13@https.bugs.freebsd.org/bugzilla/>

next in thread | previous in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D203949

Chris Hutchinson <portmaster@bsdforge.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |portmaster@bsdforge.com

--- Comment #1 from Chris Hutchinson <portmaster@bsdforge.com> ---
(In reply to Torsten Z=C3=BChlsdorff from comment #0)
> Created attachment 162343 [details]
> shar with new port pguri
>=20
> Hello,
>=20
> i've created a port for this fine extension:
> https://github.com/petere/pguri
>=20
> It adds a datatype "uri" to PostgreSQL and allows storage of URIs. It also
> provides some handy functions for uri-handling.
>=20
> Some QA for the new port:
>=20
> /usr/ports/databases/pguri # portlint -AC
> WARN: Makefile: Consider defining LICENSE.
> 0 fatal errors and 1 warning found.
>=20
> /usr/ports/databases/pguri #  make && make stage-qa && make check-plist &&
> make install && make deinstall
> =3D=3D=3D>   pguri-1.20150415 depends on file: /usr/local/sbin/pkg - found
> =3D=3D=3D> Fetching all distfiles required by pguri-1.20150415 for buildi=
ng
> =3D=3D=3D>  Extracting for pguri-1.20150415
> =3D> SHA256 Checksum OK for petere-pguri-1.20150415_GH0.tar.gz.
> =3D=3D=3D>  Patching for pguri-1.20150415
> =3D=3D=3D>   pguri-1.20150415 depends on package: uriparser>=3D0.7.9 - fo=
und
> =3D=3D=3D>   pguri-1.20150415 depends on executable: gmake - found
> =3D=3D=3D>   pguri-1.20150415 depends on executable: pkgconf - found
> =3D=3D=3D>   pguri-1.20150415 depends on shared library: libpq.so.5 - fou=
nd
> (/usr/local/lib/libpq.so.5)
> =3D=3D=3D>  Configuring for pguri-1.20150415
> =3D=3D=3D>  Building for pguri-1.20150415
> [gmake output]
> =3D=3D=3D>  Staging for pguri-1.20150415
> =3D=3D=3D>   Generating temporary packing list
> gmake[1]: Verzeichnis =E2=80=9E/usr/ports/databases/pguri/work/pguri-1.20=
150415=E2=80=9C
> wird betreten
> /bin/mkdir -p
> '/usr/ports/databases/pguri/work/stage/usr/local/lib/postgresql'
> /bin/mkdir -p
> '/usr/ports/databases/pguri/work/stage/usr/local/share/postgresql/extensi=
on'
> /bin/mkdir -p
> '/usr/ports/databases/pguri/work/stage/usr/local/share/postgresql/extensi=
on'
> /usr/bin/install -c -m 755  uri.so
> '/usr/ports/databases/pguri/work/stage/usr/local/lib/postgresql/uri.so'
> /usr/bin/install -c -m 644 uri.control
> '/usr/ports/databases/pguri/work/stage/usr/local/share/postgresql/extensi=
on/'
> /usr/bin/install -c -m 644 uri--0.sql
> '/usr/ports/databases/pguri/work/stage/usr/local/share/postgresql/extensi=
on/'
> gmake[1]: Verzeichnis =E2=80=9E/usr/ports/databases/pguri/work/pguri-1.20=
150415=E2=80=9C
> wird verlassen
> /usr/bin/strip
> /usr/ports/databases/pguri/work/stage/usr/local/lib/postgresql/uri.so
> =3D=3D=3D=3D> Compressing man pages (compress-man)
> =3D=3D=3D=3D> Running Q/A tests (stage-qa)
> =3D=3D=3D=3D> Running Q/A tests (stage-qa)
> =3D=3D=3D=3D> Checking for pkg-plist issues (check-plist)
> =3D=3D=3D> Parsing plist
> =3D=3D=3D> Checking for items in STAGEDIR missing from pkg-plist
> =3D=3D=3D> Checking for items in pkg-plist which are not in STAGEDIR
> =3D=3D=3D> No pkg-plist issues found (check-plist)
> =3D=3D=3D>  Installing for pguri-1.20150415
> =3D=3D=3D>   pguri-1.20150415 depends on shared library: libpq.so.5 - fou=
nd
> (/usr/local/lib/libpq.so.5)
> =3D=3D=3D>  Checking if pguri already installed
> =3D=3D=3D>   Registering installation for pguri-1.20150415
> Installing pguri-1.20150415...
> In order to use the extension within database execute the following comma=
nd:
>=20
> CREATE EXTENSION uri;
>=20
> =3D=3D=3D>  Deinstalling for pguri
> =3D=3D=3D>   Deinstalling pguri-1.20150415
> Updating database digests format: 100%
> Checking integrity... done (0 conflicting)
> Deinstallation has been requested for the following 1 packages (of 0
> packages in the universe):
>=20
> Installed packages to be REMOVED:
>         pguri-1.20150415
>=20
> The operation will free 17 KiB.
> [1/1] Deinstalling pguri-1.20150415...
> [1/1] Deleting files for pguri-1.20150415: 100%

This looks great. But the copy of uriparser currently in the ports
tree is too old (0.79). pguri recommends at least version 0.8.0,
and for good reason - 0.80 Changelog:

2013-12-20 -- 0.8.0

  * Fixed: Resolution of relative URI "/" broken
      Thanks to Mo McRoberts for the patch!
  * Fixed: uriAddBaseUri produced uriUri objects with both host
      and the absolutePath flag set (while the absolutePath flag
      should only be true for URI objects without a host) when
      resolving absolute URIs like "/" or "/foo/bar".
      Now the absolutePath flag is set to URI_FALSE and an empty
      segment is added as necessary
  * Fixed: .errorCode could end up unset, previously
      Thanks to Radu Hociung for the patch!  (bug #16)
  * Fixed: Resolve use of non-POSIX "sed -r" used when building
     documentation  (bug #18)
     Thanks to Ryan Schmidt for reporting!
  * Fixed: Build DLL with -no-undefined on Windows
      Thanks to Michel Zou for the patch!  (bug #19)
  * Added: Command line tool "uriparse"
      Thanks to Radu Hociung for coding!  (feature request #3)
  * Soname: 1:15:0

Perhaps you should poke the uriparser maintainer. You might even
craft an svn diff to upgrade it. ;)

--Chris

--=20
You are receiving this mail because:
You are the assignee for the bug.=



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-203949-13-T6je0NOX1r>