databases/pgloader3 3.6.9_10

databases/pgloader3: Fix crash during "reset sequences"

Column names that need to be quoted, will already be so quoting them
again results in sql errors.

Patch taken from:
https://github.com/codereverser/pgloader/commit/aba754a759f28701d94551e85c6b9c369e63698c
Upstreaming is of no use as upstream rewrote pgloader in java and is not
accepting patches for v3 anymore.

While at it:
- Replace PORTVERSION with DISTVERSION.
- Add libzstd to LIB_DEPENDS.
- Fix warnings from portclippy.
- Refresh patch.

PR:		298832
Approved by:	freebsd-washroom@duhanic.com (maintainer, timeout 1 month)
Sponsored by:	UNIS Labs (vvd)
Co-authored-by:	Vladimir Druzenko <vvd@FreeBSD.org>
MFH:		2026Q4

*/*: Bump PORTREVISION on *-sbcl ports after lang/sbcl upgrade.

*/*: Bump PORTREVISION on *-sbcl ports after lang/sbcl upgrade.

*/*: Bump PORTREVISION on *-sbcl ports after lang/sbcl upgrade.

*/*: Bump PORTREVISION on *-sbcl ports after lang/sbcl upgrade.

*/*: Bump PORTREVISION on *-sbcl ports after lang/sbcl upgrade.

*/*: Bump PORTREVISION on *-sbcl ports after lang/sbcl upgrade.

*/*: Bump PORTREVISION on *-sbcl ports after lang/sbcl upgrade.

*/*: Bump PORTREVISION on *-sbcl ports after lang/sbcl upgrade.

databases/pgloader3: Unbreak with SBCL >= 2.5.11

PR:		293478
Reported by:	bob@vesterman.com

*/*: Bump PORTREVISION on *-sbcl ports after lang/sbcl upgrade.

databases/pgloader3: Update to 3.6.9

Submitted by:	     fax@nohik.ee
PR:	  270022

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.

This commit implements such a proposal and moves one of the WWW: entries
of each pkg-descr file into the respective port's Makefile. A heuristic
attempts to identify the most relevant URL in case there is more than
one WWW: entry in some pkg-descr file. URLs that are not moved into the
Makefile are prefixed with "See also:" instead of "WWW:" in the pkg-descr
files in order to preserve them.

There are 1256 ports that had no WWW: entries in pkg-descr files. These
ports will not be touched in this commit.

The portlint port has been adjusted to expect a WWW entry in each port
Makefile, and to flag any remaining "WWW:" lines in pkg-descr files as
deprecated.

Approved by:		portmgr (tcberner)

databases/pgloader3: update to 3.6.3

https://github.com/dimitri/pgloader/releases/tag/v3.6.3

PR:		263100
Approved by:	maintainer-timeout

databases/pgloader3: update esrap package to 2021-10-20

the older esrap package cannot be built with a recent sbcl compiler,
thus rendering pgloader3 unbuildable. this update bumps esrap to
a recent version which is compatible with our current sbcl compiler.

PR:		261319
Approved by:	maintainer-timeout

One more small cleanup, forgotten yesterday. Reported by:	lwhsu

Remove # $FreeBSD$ from Makefiles.

allow pgloader3 to build on 32bit platforms

guess if we're on a 32bit platform and set a reduced DYNSIZE - else
sbcl may hit it's adress space limits.

PR:		253766
Submitted by:	maintainer

pgloader3: unbreak and update to 3.6.2

submitter becomes maintainer

PR:		252716
Submitted by:	Mario Duhanic

Mark BROKEN

Fatal CIRCULAR-DEPENDENCY:
  Circular dependency: ((#<LOAD-OP> . #<SYSTEM "simple-date">) (#<LOAD-OP> . #<SYSTEM "simple-date-postgres-glue">) (#<LOAD-OP> . #<MODULE "simple-date-postgres-glue" "simple-date">) (#<LOAD-OP> . #<CL-SOURCE-FILE "simple-date-postgres-glue" "simple-date" "cl-postgres-glue">) (#<PREPARE-OP> . #<CL-SOURCE-FILE "simple-date-postgres-glue" "simple-date" "cl-postgres-glue">) (#<PREPARE-OP> . #<MODULE "simple-date-postgres-glue" "simple-date">) (#<PREPARE-OP> . #<SYSTEM "simple-date-postgres-glue">))
Fatal error in "buildapp" : Error #<SILENT-EXIT-ERROR #x3020005BBF5D>

Reported by:	pkg-fallout

Correction to r473019: Revert the unintended change to the 'Created by' headers.

Reset MAINTAINER on ports maintained by amutu@amutu.com

Based on the new policy of all maintained ports reset
when maintaner is absent for 3 months.

Bug#226400 for science/py-tensorflow is ignored since 2018-03-06 (3+ months).
portscout database indicates that 48.94% of his ports aren't updated.

New port: databases/pgloader3

Pgloader loads data into PostgreSQL using the COPY streaming protocol,and
doing so with separate threads for reading and writing data.Asynchronous
IO,compiled to the metal programming language.
pgloader knows how to read data from MySQL,SQLite or dBase databases,and
knows how to discover the schema and properly cast data types over.It also
knows how to read CSV files in several definitions of CSV,and fixed columns
files.

WWW: http://pgloader.io

PR:           219165
Submitted by: Jov <amutu@amutu.com>