databases/postgresql-libpqxx: Convert to CMake and modernize

* Switch to CMake as it cleans up Makefile, builds faster and adds
  .cmake files to port
* Modernize port Makefile
* Remove ancient CONFLICTS entry

PR:		281022
Approved by:	pgsql (girgen)

databases/postgresql-libpqxx: Update to 7.9.2

Release notes:	https://github.com/jtv/libpqxx/releases/tag/7.9.2

databases/postgresql-libpqxx: Update to 7.9.1

Release notes:	https://github.com/jtv/libpqxx/releases/tag/7.9.1

databases/postgresql-libpqxx: Update to 7.9.0

Release notes:	https://github.com/jtv/libpqxx/releases/tag/7.9.0

databases/postgresql-libpqxx: update to 7.8.1

Release notes:	https://github.com/jtv/libpqxx/releases

databases/postgresql-libpqxx: update to 7.7.5

Release notes:	https://github.com/jtv/libpqxx/tree/7.7.5

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.

Upgrade to version 7.2.0

Release notes:	http://www.pqxx.org/development/libpqxx/#news

Upgrade to version 7.1.2

This fixes a problem reported by several, where
include/pqxx/internal/transaction_focus.hxx was missing.

Upgrade to 7.1.0

Release notes:	https://pqxx.org/development/libpqxx/

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

Bump PORTREVISION for ports depending on the canonical version of GCC
in the ports tree (via Mk/bsd.default-versions.mk and lang/gcc) which
has now moved from GCC 6 to GCC 7 by default.

This includes ports
 - featuring USE_GCC=yes or USE_GCC=any,
 - featuring USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and those
 - with USES=compiler specifying one of openmp, nestedfct, c11, c++0x,
   c++11-lib, c++11-lang, c++14-lang, c++17-lang, or gcc-c++11-lib.

PR:		222542

Adjust USES to fix builds on gcc-based architectures.

While here, pet portlint.

Tested for no regression on amd64.

Approved by:	portmgr (tier-2 blanket)

Update to version 6.1.0

Update postgresql-libpqxx to latest version 6

Keep version 4 as a separate port
Set license for the old version 3 port

PR:		225109
Submitted by:	Yuri Victorovich

- Those ports fail to build with python3
- Add some explicit FLAVOR to dependencies where needed

Use USES=pathfix where applicable.

PR:		213195
Submitted by:	mat
Exp-run by:	antoine
Sponsored by:	Absolight
Differential Revision:	https://reviews.freebsd.org/D8093

Switch default python_CMD used by shebangfix to ${PYTHON_CMD} for ports
using python

PR:		201077
Reviewed by:	mat
With hat:	portmgr
Differential Revision:	https://reviews.freebsd.org/D2955

Cleanup plist

- Convert ports from databases/ and deskutils/ to new USES=python

Approved by:	portmgr (implicit)

Convert pgsql ports to use USES+=pgsql

Reviewed by:	bapt

Convert to USES=pgsql

While here:
databases/pg_reorg
- stagify

databases/iplike
- convert to USES=libtool
- strip binarie

databases/ip4r
- strip binaries

databases/postgresql-libpgeasy
- convert to USES=libtool
- strip binaries
- stagify

databases/postgresql-libpqxx
- convert to USES=libtool
- strip binaries

databases/postgresql-libpqxx3
- convert to USES=libtool
- strip binaries

fix building when python meta port is not installed

Update to 4.0.1

Stage

PR:		ports/185591
Submitted by:	Bartek Rutkowski <ports@robakdesign.com>

Update CONFLICTS given the PKGNAME change of pqxx-3

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

- convert from USE_GMAKE to USES=gmake
- trim historical headers

With hat: pgsql@

- restore databases/postgresql-libpqxx, distfiles are now available
- maintainership over to pgsql@ (with hat pgsql@)

Reported by: kjedruczyk@fastmail.net

2012-11-26 databases/postgresql-libpqxx: No more public distfiles
2012-10-20 devel/portlet-api: No more public distfiles

Feature safe:	yes

Deprecate a bunch of ports that are either abandonware and/or for which no more
public distfiles are available, or for which are -devel version with a more
recent stable version for long

Feature safe:	yes

- Update libpqxx to 4.0. [1]
- Update CONFLICTS in libpqxx30.
- Add instructions to UPDATING for people willing to stick with
  version 3.

Submitted by:   arrowdodger via IRC [1]

- Reset ports due to maintainer timeouts and lack of response to emails

With hat:       portmgr

Update to version 3.1

- Get Rid MD5 support

Mark conflict with databases/postgresql-libpqxx30
set PORTSCOUT
Bump PORTREVISION

- Update download location

Reported by:    -fetch-original pointyhat run

- Remove conditional checks relevant only on FreeBSD 5.x and older

Bump portrevision due to upgrade of devel/gettext.

The affected ports are the ones with gettext as a run-dependency
according to ports/INDEX-7 (5007 of them) and the ones with USE_GETTEXT
in Makefile (29 of them).

PR:             ports/124340
Submitted by:   edwin@
Approved by:    portmgr (pav)

- Remove unneeded dependency from gtk12/gtk20 [1]
- Remove USE_XLIB/USE_X_PREFIX/USE_XPM in favor of USE_XORG
- Remove X11BASE support in favor of LOCALBASE or PREFIX
- Use USE_LDCONFIG instead of INSTALLS_SHLIB
- Remove unneeded USE_GCC 3.4+

Thanks to all Helpers:
        Dmitry Marakasov, Chess Griffin, beech@, dinoex, rafan, gahr,
        ehaupt, nox, itetcu, flz, pav

PR:             116263
Tested on:      pointyhat
Approved by:    portmgr (pav)

Updating to version 2.6.9:
  "Many things have changed. Bugs have been fixed, new features
  have been introduced. But most importantly, we're really retiring
  the old 1.x-style libpqxx API now. This API (where upper-case letters
  were still used in function names and such) has been supported for
  more than three years in the interest of backwards compatibility,
  but has been marked as obsolete all this time."

Update to 2.6.7

Update to 2.6.6.

Security:       http://thaiopensource.org/development/libpqxx/

Conversion to a single libtool environment.

Approved by:    portmgr (kris)

SHA256ify

Approved by:    krion@

Mass-conversion to the USE_AUTOTOOLS New World Order.  The code present
in bsd.autotools.mk essentially makes this a no-op given that all the
old variables set a USE_AUTOTOOLS_COMPAT variable, which is parsed in
exactly the same way as USE_AUTOTOOLS itself.

Moreover, USE_AUTOTOOLS has already been extensively tested by the GNOME
team -- all GNOME 2.12.x ports use it.

Preliminary documentation can be found at:
        http://people.FreeBSD.org/~ade/autotools.txt

which is in the process of being SGMLized before introduction into the
Porters Handbook.

Light blue touch-paper.  Run.

The gborg.postgresql.org distributions exist on the main postgresql
ftp stites, so let's use them

Updating to 2.5.5

Approved by: ade, seanc (implicit)

- libdata/pkgconfig is now included in mtree

Approved by:    marcus (portmgr hat)

Split the postgresql ports into a server and a client part.

All ports depending on postgresql shall use the USE_PGSQL=yes knob
defined in Mk/bsd.ports.mk. Bumping portrevisions where needed.

PR:             75344
Approved by:    portmgr@ (kris), ade & sean (mentors)

Add myself as committer, and use my @FreeBSD.org address.

Approved by: ade (mentor)

Fix configure checks for C++ headers on 4.x

PR: ????? (¹)
Submitted by: maintainer

(¹) PR was cc'd to me six hours ago, but hasn't made it into GNATS yet.
Assemble an away team, number one!

Update to 2.4.2

Submitted by: maintainer

- Mark BROKEN on 4.x

PR:             ports/73904
Submitted by:   Palle Girgensohn <girgen@pingpong.net> (maintainer)

Upgrade to 2.4.1

PR:             73641
Submitted by:   Steven Looman <steven@krx.nl>
                Palle Girgensohn <girgen@pingpong.net>

update to 2.2.7
fix a wrong pkg-config specification position

PR:             ports/69960
Submitted by:   Jie Gao <gaoj@cpsc.ucalgary.ca>
Approved by:    maintainer

Apply a big libtool patch to allow porters to use the libtool installed by
the libtoolX ports instead of the one included with each port.  Ports that
set USE_LIBTOOL_VER=X will now use the ports version of libtool instead of
the included version.  To restore previous behavior, use the new macro,
USE_INC_LIBTOOL_VER.  Both macros accept the same argument: a libtool version.

For example, to use the ports version of libtool-1.5, add the following to
your Makefile:

USE_LIBTOOL_VER=        15

To use the included version of libtool with extra hacks provided by
libtool-1.5, add the following to your Makefile:

USE_INC_LIBTOOL_VER=    15

With this change, ports that had to add additional libtool hacks to prevent
.la files from being installed or to fix certain threading issues can now
delete those hacks (after appropriate testing, of course).

PR:             63944
Based on work by:eik and marcus
Approved by:    ade (autotools maintainer)
Tested by:      kris on pointyhat
Bound to be hidden problems:    You bet

Unbreak on -STABLE.

PR:             ports/68217
Submitted by:   maintainer.

Upgrade to 2.2.3.

Warning: broken on 4.x.

PR:             68217
Submitted by:   maintainer.

SIZEify (maintainer timeout)

Bump PORTREVISION on all ports that depend on gettext to aid with upgrading.

(Part 2)

Introduce the world to PostgreSQL 7.4!  By and large this release is
regarded as a major release with features with interest to those with
large databases.  The updates are extensive and the best source of info
is in the release notes.  Enjoy and direct questions to database@!

Release notes:
http://www.postgresql.org/docs/7.4/static/release.html#RELEASE-7-4

PR:             ports/59403, ports/59404, ports/59393, ports/59394,
                ports/59395, ports/59397, ports/59398, ports/59402, &&
                ports/59401
Submitted by:   maintainer
Approved by:    marcus (portmgr@ hat)

USE_REINPLACE need be defined only when REINPLACE_CMD is used.

Update to 1.5.1
Add PKGNAMEPREFIX=postgresql

PR:             56336
Submitted by:   maintainer

De-pkg-comment.

Add libpqxx.  libpqxx is no longer hosted under the main PostgreSQL tree and
is now a project on gborg.  libpqxx is still a supported interface.

PR:             ports/45944
Submitted by:   Palle Girgensohn <girgen@pingpong.net>