Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sH8sj-003mq4-4i for pgsql-general@arkaria.postgresql.org; Tue, 11 Jun 2024 21:18:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sH8sh-00AEe1-Mb for pgsql-general@arkaria.postgresql.org; Tue, 11 Jun 2024 21:18:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sH8qB-00A9iG-7u for pgsql-general@lists.postgresql.org; Tue, 11 Jun 2024 21:15:40 +0000 Received: from mout.gmx.net ([212.227.17.20]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sH8q8-000qrR-OA for pgsql-general@lists.postgresql.org; Tue, 11 Jun 2024 21:15:38 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1718140534; x=1718745334; i=karsten.hilbert@gmx.net; bh=iWnBvlOjzxcoaanbn1laLNYCugnmKlP/+MwbiE3wYHc=; h=X-UI-Sender-Class:Date:From:To:Subject:Message-ID:MIME-Version: Content-Type:Content-Transfer-Encoding:cc: content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=tz8NmJOvWC3Qg0gZZjTinEd1aOtIfft8BfrKlm1G1Mku/OOHEtfM2Uj+LbjYV4Q/ 5DqMI6Lxvps+wReYMdqRfr/wUaW5VBz4TLmiq5nId3unw9Tm9efrjJEfM/T0+vbX0 0WNstXdFhQiMCxy54bSB9DUp+67bcrf8kq0LitFhIk2bsXZajDFSboP1XthJfTYcO rMJ/39f2//TIMQR78QDXqAECNhBx23nYOf/FAQipxOoXJL1MeyvcXigaIR6mkQJEm gGOBPOYRYTPFWsQFRX53SOzddsNnqvb0HWmLpuyZzZBHbUqypBVpyVhx5qYz8XxHA z4AKDS+hsgcsBniuSw== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from hermes ([79.192.55.172]) by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1Mt79F-1sWjux1bgH-00rTvT for ; Tue, 11 Jun 2024 23:15:34 +0200 Received: from ncq by hermes with local (Exim 4.96) (envelope-from ) id 1sH8qI-0008Md-0X for pgsql-general@lists.postgresql.org; Tue, 11 Jun 2024 23:15:46 +0200 Date: Tue, 11 Jun 2024 23:15:46 +0200 From: Karsten Hilbert To: pgsql-general@lists.postgresql.org Subject: DROP COLLATION vs pg_collation question Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Ma_X_il-Followup-to: d Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri_X_ority: 2 (High) Sender: X-Provags-ID: V03:K1:VkHg3SADoHmBC6zq6YQ6PxTa2R/a8ocarw6mz8cB85FWRFiXBJ2 dRbdZIB/fHnQOWzlklLhBFC/KJzySPtxl2YQIWtHKLoHc398NEp+yzlXwFbgohi6B8qPDmM Ekf+lH/lQXd0LsqK3vEgQWYypSEVe39blRdbsb+sCYsy0gUdgjb80gEtumt/FjkEloNdIHj GXmdXTfEfl6R8MxsJiGZg== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:sGnHUCga7bc=;9uupyhsyQnB3XrHJBObRnaYZOuu qfwCPP1U3ftDSD+5wBps9ZHrpkmj9nSAR+O+1qbsYSQBeepQRUP95AQzz39v06EfMiXraYmzK 7edtsEXdcOHVJADRb/xQMaEJuoil0ewpfWhavQE2RxfWkslS9N873y7F10+/guu+a82qqO8vH JK4Blw95PPvQThMENJIOJ+ElOHAaqIz01Gl7oU++vQQ17uqaQjsHNbRZOyKXG09MP/2fvWnK7 PBdipt/lQsQiEpYin6U9Ufb+4D8BFOPu85grtkrXKA1/w5JsCZJqoyLSnS2WCHOBy873hoVjv z58o874yY9mr2yQpvcztoktFFSnwc8odo+yhsWUKCDOSlQRqTgG5TSf8S9jqtC/20K6f5vH6z 1I0uKVVGbm4WvKENwDrD70pkRXY1ETJrZ0k7nF/yRr5zKdeDbx6J1DaVfUvGiRtDND1f3stno 6pepwHuhC9XXwr37Wf5g+gONBDVWHsTNXY+3F3RPTwj9VyymHyyOWsKeH3HsjiMhj+Un9jzOd udd+ygs1jy4jKcGp52+ayaI24zOL9R3Dex9ngAeCBx8IY+ugekIFuaikOwp+FVrmAuAWG8NcK KA70LVEClPmg4/uzJSH+XKR36thlp/lTBELeulomUjbtdL3nYX65M+bo/ZqzMBnxA7Npxwryy Tl/q+QPeZP5wQengDMDmWPZIy0vgMf+Y4fyfOS16XetNjkSopCPTuMBrbWiSQVMsfVW16nxDx R8wCcQxQWS2sgk6pByMi2zCZgpOXvK2Hh/YlIxEa+qWWxecMgLFP7hs2z3nBFx6owJaIW9o9O 2ME1B8quMMMmvqdJI3sXHrQHPK55JrHT9Y804mEee1Klg= Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Dear list members, maybe a naive question but I was unable to find an answer in the fine manual (sv_SE being an example) Does running DROP COLLATION IF EXISTS pg_catalog."sv_SE" also remove the corresponding row from pg_collation (assuming nothing depends on collation sv_SE) ? Experimentation seems to hint that way but I was unable to confirm. Thanks Karsten =2D- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B