databases/pgsphere: Remove expired port

2024-04-30 databases/pgsphere: The repository has been archived by the owner on
2023-08-09 and is inactive for almost 4.5 years

databases/pgsphere: Mark DEPRECATED and set EXPIRATION_DATE to 2024-04-30

Reference:	https://github.com/pgsphere/pgsphere/commit/e0b303d0bff6a5f6596d3f48b4d9fb2e0f7bf160

Remove WWW entries moved into port Makefiles

Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.

This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.

Approved by:		portmgr (tcberner)

Add WWW entries to port Makefiles

It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.

Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.

There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.

databases: remove 'Created by' lines

A big Thank You to the original contributors of these ports:

  *  "Choe, Cheng-Dae" whitekid
  *  "Mahdi Mokhtari <mokhi64@gmail.com>"
  *  "Meikel Brandmeyer" <ocaml-sqlite3-port@kotka.de>
  *  <hvo.pm@xs4all.nl>
  *  <jsmith@resonatingmedia.com>
  *  <ports@c0decafe.net>
  *  Aaron Dalton <aaron@FreeBSD.org>
  *  Adam Weinberger <adamw@FreeBSD.org>
  *  Ade Lovett <ade@FreeBSD.org>
  *  Akinori MUSHA aka knu <knu@idaemons.org>
  *  Alan Snelson <Alan@Wave2.org>

Remove # $FreeBSD$ from Makefiles.

databases/pgsphere: stop using VLAs to fix PG12 compilation

PR:		248657
Reported by:	vvd@unislabs.com
Obtained from:	https://github.com/akorotkov/pgsphere/pull/14
Sponsored by:	BBOX.io

databases/pgsphere: Update to support PG12

PR:		248657
Submitted by:	VVD@unislabs.com
Approved by:	sunpoet (maintainer timeout)
Sponsored by:	BBOX.io

Bump PORTREVISION for ports depending on the canonical version of GCC
as defined in Mk/bsd.default-versions.mk which has moved from GCC 8.3
to GCC 9.1 under most circumstances now after revision 507371.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, everything INDEX-11 shows with a dependency on lang/gcc9 now.

PR:		238330

Bump PORTREVISION for ports depending on the canonical version of GCC
defined via Mk/bsd.default-versions.mk which has moved from GCC 7.4 t
GCC 8.2 under most circumstances.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, as a double check, everything INDEX-11 showed depending on lang/gcc7.

PR:		231590

Workaround the following problem on aarch64 by setting LLD_UNSAFE=yes:

  cc: error: invalid linker name in argument '-fuse-ld=bfd'

Neither emaste nor I can figure out exactly where the offending stanza is
coming in.  It will take someone with more knowledge of gmake debug flags,
and possibly the src build infrastructure, to figure it out.

While here, pet portlint.

Approved by:	portmgr (tier-2 blanket)

Update to 1.1.5

- Add LICENSE_FILE
- Move PLIST_FILES to PLIST
- Update pkg-descr
- Update WWW

Changes:	https://github.com/pgsphere/pgsphere/commits/master

- Convert to new test framework

Cleanup plist

- Use PLIST_DIRS instead of deprecated PLIST_DIRSTRY

- Fix build
- Strip shared library

Convert to USES=pgsql

- Convert to new options helper

- Use MAKE_CMD
- Reenable regression-test:
- Support STAGEDIR

- Update LICENSE

Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)

- Add LICENSE
- Convert to new options framework
- Cosmetic change
- Use single space after WWW:

- Cleanup Makefile header

- Use USES=gmake

- Get Rid MD5 support

- Since PLIST_DIRSTRY is available now, use it for %%DATADIR%%/contrib
- Bump PORTREVISION

- Revert previous commit due to a broken PLIST_DIRSTRY
- Bump PORTREVISION

Approved by:    pgollucci (mentor, implicit)

- Use dirrmtry on %%DATADIR%%/contrib
- Bump PORTREVISION

Approved by:    pgollucci (mentor, implicit)

- Use LOCAL/sunpoet as backup MASTER_SITES

Approved by:    pgollucci (mentor)

- Update MAINTAINER to my FreeBSD.org address

Approved by:    pgollucci (mentor)

- Fix deinstallation when NOPORTDOCS is set.

PR:             ports/148135
Submitted by:   Sunpoet Po-Chuan Hsieh <sunpoet@sunpoet.net> (maintainer)
Feature safe:   yes

Changes:
- Unbreak make package when NOPORTDOCS was defined
- Make portlint happier

PR:             144009
Submitted by:   Sunpoet Po-Chuan Hsieh (maintainer)
Feature safe:   yes

pgSphere provides spherical data types, functions, and operators for PostgreSQL.

WWW:    http://pgsphere.projects.postgresql.org/

PR:             ports/143687
Submitted by:   Sunpoet Po-Chuan Hsieh <sunpoet at sunpoet.net>