From owner-svn-ports-all@freebsd.org Thu Oct 26 17:39:51 2017 Return-Path: Delivered-To: svn-ports-all@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 296F1E4F19D; Thu, 26 Oct 2017 17:39:51 +0000 (UTC) (envelope-from tcberner@FreeBSD.org) Received: from repo.freebsd.org (repo.freebsd.org [IPv6:2610:1c1:1:6068::e6a:0]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id E7AAB2B32; Thu, 26 Oct 2017 17:39:50 +0000 (UTC) (envelope-from tcberner@FreeBSD.org) Received: from repo.freebsd.org ([127.0.1.37]) by repo.freebsd.org (8.15.2/8.15.2) with ESMTP id v9QHdo8s072386; Thu, 26 Oct 2017 17:39:50 GMT (envelope-from tcberner@FreeBSD.org) Received: (from tcberner@localhost) by repo.freebsd.org (8.15.2/8.15.2/Submit) id v9QHdnIB072384; Thu, 26 Oct 2017 17:39:49 GMT (envelope-from tcberner@FreeBSD.org) Message-Id: <201710261739.v9QHdnIB072384@repo.freebsd.org> X-Authentication-Warning: repo.freebsd.org: tcberner set sender to tcberner@FreeBSD.org using -f From: "Tobias C. Berner" Date: Thu, 26 Oct 2017 17:39:49 +0000 (UTC) To: ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org Subject: svn commit: r452931 - in head/www/davical: . files X-SVN-Group: ports-head X-SVN-Commit-Author: tcberner X-SVN-Commit-Paths: in head/www/davical: . files X-SVN-Commit-Revision: 452931 X-SVN-Commit-Repository: ports MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-BeenThere: svn-ports-all@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: SVN commit messages for the ports tree List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 26 Oct 2017 17:39:51 -0000 Author: tcberner Date: Thu Oct 26 17:39:49 2017 New Revision: 452931 URL: https://svnweb.freebsd.org/changeset/ports/452931 Log: Fix www/davical to be comptible with Postgres 10.0 PR: 223187 Submitted by: Le Baron d'Merde (maintainer) Reported by: karl@denninger.net Added: head/www/davical/files/patch-git_39001794 (contents, props changed) Modified: head/www/davical/Makefile Modified: head/www/davical/Makefile ============================================================================== --- head/www/davical/Makefile Thu Oct 26 17:13:57 2017 (r452930) +++ head/www/davical/Makefile Thu Oct 26 17:39:49 2017 (r452931) @@ -4,7 +4,7 @@ PORTNAME= davical DISTVERSIONPREFIX= r DISTVERSION= 1.1.5 -PORTREVISION= 1 +PORTREVISION= 2 CATEGORIES?= www MASTER_SITES= https://gitlab.com/${PORTNAME}-project/${PORTNAME}/repository/archive.tar.gz?ref=${DISTVERSIONPREFIX}${PORTVERSION}&dummy=/ Added: head/www/davical/files/patch-git_39001794 ============================================================================== --- /dev/null 00:00:00 1970 (empty, because file is newly added) +++ head/www/davical/files/patch-git_39001794 Thu Oct 26 17:39:49 2017 (r452931) @@ -0,0 +1,59 @@ +From 39001794a3121c33c8cba50398b653a94328be40 Mon Sep 17 00:00:00 2001 +From: Florian Schlichting +Date: Tue, 3 Oct 2017 22:36:29 +0200 +Subject: [PATCH] Update caldav_functions.sql for Postgresql 10 + +From version 10, Postgresql does not allow set-returning functions in +CASE statements. As we're using the functions recursively, we cannot +use LATERAL as suggested in the error message, but we can switch the +condition inside-out with only a limited amount of repetition. + +--- dba/caldav_functions.sql ++++ dba/caldav_functions.sql +@@ -897,21 +897,37 @@ LANGUAGE plpgsql IMMUTABLE STRICT; + + -- Expanded group memberships out to some depth + CREATE or REPLACE FUNCTION expand_memberships( INT8, INT ) RETURNS SETOF INT8 AS $$ +- SELECT group_id FROM group_member WHERE member_id = $1 +- UNION +- SELECT expanded.g_id FROM (SELECT CASE WHEN $2 > 0 THEN expand_memberships( group_id, $2 - 1) END AS g_id +- FROM group_member WHERE member_id = $1) AS expanded +- WHERE expanded.g_id IS NOT NULL; +-$$ LANGUAGE sql STABLE STRICT; ++BEGIN ++ IF $2 > 0 THEN ++ RETURN QUERY ++ SELECT group_id FROM group_member WHERE member_id = $1 ++ UNION ++ SELECT expanded.g_id FROM (SELECT expand_memberships( group_id, $2 - 1) AS g_id ++ FROM group_member WHERE member_id = $1) AS expanded ++ WHERE expanded.g_id IS NOT NULL; ++ ELSE ++ RETURN QUERY ++ SELECT group_id FROM group_member WHERE member_id = $1; ++ END IF; ++END ++$$ LANGUAGE plpgsql IMMUTABLE STRICT; + + -- Expanded group members out to some depth + CREATE or REPLACE FUNCTION expand_members( INT8, INT ) RETURNS SETOF INT8 AS $$ +- SELECT member_id FROM group_member WHERE group_id = $1 +- UNION +- SELECT expanded.m_id FROM (SELECT CASE WHEN $2 > 0 THEN expand_members( member_id, $2 - 1) END AS m_id +- FROM group_member WHERE group_id = $1) AS expanded +- WHERE expanded.m_id IS NOT NULL; +-$$ LANGUAGE sql STABLE STRICT; ++BEGIN ++ IF $2 > 0 THEN ++ RETURN QUERY ++ SELECT member_id FROM group_member WHERE group_id = $1 ++ UNION ++ SELECT expanded.m_id FROM (SELECT expand_members( member_id, $2 - 1) AS m_id ++ FROM group_member WHERE group_id = $1) AS expanded ++ WHERE expanded.m_id IS NOT NULL; ++ ELSE ++ RETURN QUERY ++ SELECT member_id FROM group_member WHERE group_id = $1; ++ END IF; ++END ++$$ LANGUAGE plpgsql IMMUTABLE STRICT;