From nobody Fri Jun 30 07:18:02 2023 X-Original-To: dev-commits-ports-all@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4Qsmqt4y23z4knrm; Fri, 30 Jun 2023 07:18:02 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4Qsmqt1Tvvz3jWH; Fri, 30 Jun 2023 07:18:02 +0000 (UTC) (envelope-from git@FreeBSD.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1688109482; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=RJiGUWnq/LIDTqhf4NxuhJ27L+5yX94Nb1NYGlIKr3c=; b=TvjlajgnCVY0Kn5WBLu3YyS0n1aeNWl9PcOlKesLIYyRRM9zClBQiS1yqtFXAF9gK6JkaC gX5Wwz0xWtp4q36eCk98ERh9uEBuwk7wCT+7Jhsn9m2tBcnoT2SSrKsi7Wif2QuOqewwop CVvuQAu1CaE5Q0g7bLe6asIdLhhuUKdVgrf0+HaV4HR79aoMmpr2Z67v+M6v5rMxc1sNJe 1pxoUDiIY2CHyK6BTsAKoxW4+CVEQsLYkj8J60VV650oAKMg+bQ129XNdZHr6YYn0kOHLz GlqL5rB1MvwFf4jCiO7lvsd7m6VXQMJCsBmh/YzyCvztDT06/BJPSOvJAXznZw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1688109482; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=RJiGUWnq/LIDTqhf4NxuhJ27L+5yX94Nb1NYGlIKr3c=; b=Wc27gVhmSRwGVd8d331vuhoKS6gfuR+2TCKhoTqgmAOvCqqqqADAdHjHAZG91xqeyidUOC jjoWrElQVpMqtjvbvWgfEYDhg1yMsefUGLsiL8NH1xdryd1fpzpTz2UvwjJ/i37/zW1XS2 yk34PZZYF61p6OVnv21MVoXipra1UfN5ZB7iatgbKn+aPy6eOKVtJu8vRSdKCLYnN74g6f u9TcEoSr58RznuB0HbAUxJ/1uaK59xG6tzNYN6TdDRsOW2B0Zi5TNMDQPIOoQmIXF9mCJe 0+UfdDOCzvfNNu6MeuDMg7Yvu2jw0panavwEatWGHNOUm6GV9ATDLutjoiOIRA== ARC-Authentication-Results: i=1; mx1.freebsd.org; none ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1688109482; a=rsa-sha256; cv=none; b=rrBJK1slPGRlD2D0D96BpyPtsRfbFMOQaVwCycS7i5NAIYjp28FYrgRlkMO8iMAaEKeeFr aSrsw6sb5zpkSX1ui3iI0EJI4Q+Y+wb7nJzv0SutiFkc2XjsraThxjh9U+OVNEMBO6WeS6 Lril1THSx/ffhAstyEJuP5cjonxcvPe35cl/xhGb4OMmDiDt4ZDhSjkmC4teoawTx+FxVP qL4e7jvhmeadCOtrNwg/KPEDCG6w4IPghl57u7YccWsQr4k1nFNZkuMpLDueKbUN7V/VO4 gCYX8H62W4Wd6iSO0K/7rSvL21D1KMWf/qe/TXZOVBj6X7DvGZ+5FGxfiBa8Gg== Received: from gitrepo.freebsd.org (gitrepo.freebsd.org [IPv6:2610:1c1:1:6068::e6a:5]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4Qsmqt0XR8zqBv; Fri, 30 Jun 2023 07:18:02 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from gitrepo.freebsd.org ([127.0.1.44]) by gitrepo.freebsd.org (8.17.1/8.17.1) with ESMTP id 35U7I2H0064490; Fri, 30 Jun 2023 07:18:02 GMT (envelope-from git@gitrepo.freebsd.org) Received: (from git@localhost) by gitrepo.freebsd.org (8.17.1/8.17.1/Submit) id 35U7I2OS064489; Fri, 30 Jun 2023 07:18:02 GMT (envelope-from git) Date: Fri, 30 Jun 2023 07:18:02 GMT Message-Id: <202306300718.35U7I2OS064489@gitrepo.freebsd.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org From: Po-Chuan Hsieh Subject: git: 07500a18a2f7 - main - databases/postgresql-orafce: Update to 4.3.0 List-Id: Commit messages for all branches of the ports repository List-Archive: https://lists.freebsd.org/archives/dev-commits-ports-all List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-dev-commits-ports-all@freebsd.org X-BeenThere: dev-commits-ports-all@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Git-Committer: sunpoet X-Git-Repository: ports X-Git-Refname: refs/heads/main X-Git-Reftype: branch X-Git-Commit: 07500a18a2f764241879c96d3cd512e4f1e3d4c8 Auto-Submitted: auto-generated X-ThisMailContainsUnwantedMimeParts: N The branch main has been updated by sunpoet: URL: https://cgit.FreeBSD.org/ports/commit/?id=07500a18a2f764241879c96d3cd512e4f1e3d4c8 commit 07500a18a2f764241879c96d3cd512e4f1e3d4c8 Author: Po-Chuan Hsieh AuthorDate: 2023-06-30 07:01:46 +0000 Commit: Po-Chuan Hsieh CommitDate: 2023-06-30 07:01:46 +0000 databases/postgresql-orafce: Update to 4.3.0 - Update LICENSE: Use BSD0CLAUSE - Convert REINPLACE_CMD to patch file - Update pkg-descr - Take maintainership Changes: https://github.com/orafce/orafce/releases --- databases/postgresql-orafce/Makefile | 31 +++++++----------------- databases/postgresql-orafce/distinfo | 6 ++--- databases/postgresql-orafce/files/patch-Makefile | 11 +++++++++ databases/postgresql-orafce/pkg-descr | 10 ++++---- databases/postgresql-orafce/pkg-plist | 17 ++++++++++++- 5 files changed, 44 insertions(+), 31 deletions(-) diff --git a/databases/postgresql-orafce/Makefile b/databases/postgresql-orafce/Makefile index e246e5dcd4bc..4dad0a1d9db2 100644 --- a/databases/postgresql-orafce/Makefile +++ b/databases/postgresql-orafce/Makefile @@ -1,37 +1,24 @@ -PORTNAME= orafce +PORTNAME= orafce +PORTVERSION= 4.3.0 DISTVERSIONPREFIX= VERSION_ -DISTVERSION= 3_14_0 -CATEGORIES= databases -PKGNAMEPREFIX= postgresql${PGSQL_VER:S/.//}- +CATEGORIES= databases +PKGNAMEPREFIX= postgresql- -MAINTAINER= ports@FreeBSD.org +MAINTAINER= sunpoet@FreeBSD.org COMMENT= Oracle's compatibility functions and packages for PostgreSQL WWW= https://github.com/orafce/orafce -LICENSE= 0BSD -LICENSE_NAME= Zero-Clause BSD / Free Public License 1.0.0 +LICENSE= BSD0CLAUSE LICENSE_FILE= ${WRKSRC}/COPYRIGHT.orafce -LICENSE_PERMS= dist-mirror dist-sell pkg-mirror pkg-sell auto-accept -USES= gmake pgsql:11+ -USE_GITHUB= yes -LLD_UNSAFE= yes +USES= gmake pgsql +LLD_UNSAFE= yes WANT_PGSQL= server -PORTDOCS= COPYRIGHT.orafce NEWS README.asciidoc - -OPTIONS_DEFINE= DOCS - -post-patch: - ${REINPLACE_CMD} -e 's/DOCS = README/#&/' ${WRKSRC}/Makefile +USE_GITHUB= yes post-install: ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/orafce.so -post-install-DOCS-on: - ${MKDIR} ${STAGEDIR}${DOCSDIR} - @(for f in ${PORTDOCS}; do \ - ${INSTALL_DATA} ${WRKSRC}/$${f} ${STAGEDIR}${DOCSDIR}; done) - .include diff --git a/databases/postgresql-orafce/distinfo b/databases/postgresql-orafce/distinfo index 0def41452df8..ddf7d6e6c131 100644 --- a/databases/postgresql-orafce/distinfo +++ b/databases/postgresql-orafce/distinfo @@ -1,3 +1,3 @@ -TIMESTAMP = 1687687563 -SHA256 (orafce-orafce-VERSION_3_14_0_GH0.tar.gz) = 9638d21b789cab72849a51abe7f09033c4c957eb8ca738f76e6113b75534466d -SIZE (orafce-orafce-VERSION_3_14_0_GH0.tar.gz) = 670967 +TIMESTAMP = 1686496676 +SHA256 (orafce-orafce-VERSION_4.3.0_GH0.tar.gz) = d1df0ed17c119360deaf7d574f57592a4b9b3f7154f9acf6fe73d55775f5b474 +SIZE (orafce-orafce-VERSION_4.3.0_GH0.tar.gz) = 722307 diff --git a/databases/postgresql-orafce/files/patch-Makefile b/databases/postgresql-orafce/files/patch-Makefile new file mode 100644 index 000000000000..17cd490fa697 --- /dev/null +++ b/databases/postgresql-orafce/files/patch-Makefile @@ -0,0 +1,11 @@ +--- Makefile.orig 2023-06-01 04:04:25 UTC ++++ Makefile +@@ -60,8 +60,6 @@ DATA = orafce--4.3.sql\ + orafce--4.2--4.3.sql + + +-DOCS = README.asciidoc COPYRIGHT.orafce INSTALL.orafce +- + PG_CONFIG ?= pg_config + + # make "all" the default target diff --git a/databases/postgresql-orafce/pkg-descr b/databases/postgresql-orafce/pkg-descr index 06825e03cb2d..fc9cf2f84638 100644 --- a/databases/postgresql-orafce/pkg-descr +++ b/databases/postgresql-orafce/pkg-descr @@ -1,5 +1,5 @@ -The "orafce" is a module of PostgreSQL. It implements of some functions from -the Oracle database. The functionality was verified on Oracle 10g, and the -module is useful for production work. This module contains some useful function -which can help with porting Oracle application to PostgreSQL or can be useful -generally. +Orafce provides the functions and operators that emulate a subset of functions +and packages from the Oracle RDBMS. + +The Orafce is supported in AWS Aurora with PostgreSQL Compatibility and also in +Azure Database for PostgreSQL. diff --git a/databases/postgresql-orafce/pkg-plist b/databases/postgresql-orafce/pkg-plist index 9657b4ea44e3..25170337a90a 100644 --- a/databases/postgresql-orafce/pkg-plist +++ b/databases/postgresql-orafce/pkg-plist @@ -3,8 +3,19 @@ share/postgresql/extension/orafce--3.10--3.11.sql share/postgresql/extension/orafce--3.11--3.12.sql share/postgresql/extension/orafce--3.12--3.13.sql share/postgresql/extension/orafce--3.13--3.14.sql -share/postgresql/extension/orafce--3.14.sql +share/postgresql/extension/orafce--3.14--3.15.sql +share/postgresql/extension/orafce--3.15--3.16.sql +share/postgresql/extension/orafce--3.16--3.17.sql +share/postgresql/extension/orafce--3.17--3.18.sql +share/postgresql/extension/orafce--3.18--3.19.sql +share/postgresql/extension/orafce--3.19--3.20.sql share/postgresql/extension/orafce--3.2--3.3.sql +share/postgresql/extension/orafce--3.20--3.21.sql +share/postgresql/extension/orafce--3.21--3.22.sql +share/postgresql/extension/orafce--3.22--3.23.sql +share/postgresql/extension/orafce--3.23--3.24.sql +share/postgresql/extension/orafce--3.24--3.25.sql +share/postgresql/extension/orafce--3.25--4.0.sql share/postgresql/extension/orafce--3.3--3.4.sql share/postgresql/extension/orafce--3.4--3.5.sql share/postgresql/extension/orafce--3.5--3.6.sql @@ -12,4 +23,8 @@ share/postgresql/extension/orafce--3.6--3.7.sql share/postgresql/extension/orafce--3.7--3.8.sql share/postgresql/extension/orafce--3.8--3.9.sql share/postgresql/extension/orafce--3.9--3.10.sql +share/postgresql/extension/orafce--4.0--4.1.sql +share/postgresql/extension/orafce--4.1--4.2.sql +share/postgresql/extension/orafce--4.2--4.3.sql +share/postgresql/extension/orafce--4.3.sql share/postgresql/extension/orafce.control