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 1sIhub-00HRSB-JI for pgsql-general@arkaria.postgresql.org; Sun, 16 Jun 2024 04:54:41 +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 1sIhtZ-002wus-1g for pgsql-general@arkaria.postgresql.org; Sun, 16 Jun 2024 04:53:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sIhtY-002wuk-FG for pgsql-general@lists.postgresql.org; Sun, 16 Jun 2024 04:53:37 +0000 Received: from mail-ed1-x534.google.com ([2a00:1450:4864:20::534]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sIhtW-001ucF-Mv for pgsql-general@lists.postgresql.org; Sun, 16 Jun 2024 04:53:36 +0000 Received: by mail-ed1-x534.google.com with SMTP id 4fb4d7f45d1cf-57c83100c5fso3679491a12.3 for ; Sat, 15 Jun 2024 21:53:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1718513612; x=1719118412; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:cc:to:from:subject:message-id:from:to :cc:subject:date:message-id:reply-to; bh=lZ3MnvfBLcKkLlO+sM8ygc/5xAGmQBGYPmzfzyEvYxQ=; b=hXvPfLwZIYYt99K5rFCymHjuoDkVDmJv4FcEnrC3fTsKggSpUXgyUQFDtu3cOo89I/ bCc8CJc1X1+O4/793VcjGGX5c7d0lm+Kx5RPK0GVb7ey8LJnvq7ZjLtkeefM6JIHJSyH ls8YhjvxzQWy7+lBDGVzP3RRc82KumZUMFkl/4VRKIQWuEUwrrcLZx7y/SlN53KWvFKv jYE4rt6nX6dJzUANvUBVmhYSfOO+cZjucVhC1eFFcSPhNPLY+2WvVKaNSFmZRZpyMrmJ hTMSvskjpBMY/QnofWwZi3pL4kbMv+nuola/7zK8Y7dszeE43zMA3WKvT4d5xUOIMEb0 hXVg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1718513612; x=1719118412; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:cc:to:from:subject:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=lZ3MnvfBLcKkLlO+sM8ygc/5xAGmQBGYPmzfzyEvYxQ=; b=SF6Wi4dDFR2Mwokphy482o4PLUD+egEqfdt2Qb1pFldfHUml+1eH1J5/f1IgEnHMy2 h7Cf3XG+4gy1dEWi7Xg6gRqXQjr+CEZ2ie/d2sRx0dUyCuQ0eptU+n1jf7ZFtyUMyuWW 3PG+igyxMfroH///53mRZui5pANgEkCkTeTueCAjBKhKLLqgUhrQEpkPWQ7dCyR580kt 8UOi5H4IW+A7CQjYdJw3LVJIRrYFQm0ovwzDxMTO04WCnOXOupP9VT2BJj0PNsPCvZUH Adm6xXNd2b2JGFZ7btk+djzp9ZZMerw2nDqsTPauSU3UXnoc0Z+eZk0lyxcC92wubuPE gAhw== X-Gm-Message-State: AOJu0YwrTgA7qZ2IrMVGzejnFD1c0vgJ8/znXOxgAcd0xUJZJF3jUZcg 6Z87hS8v691troDDOk4hdGVGwEOle47wNy/dnFPbVEcFYd5/V/3F0yRZmbgs1Xk= X-Google-Smtp-Source: AGHT+IGo+PubvTDX5XhrOaCcnn4L8hkaoH4+YSnj4Lq3kX/q5oJNUvxvz8Z3K6Zt9LjcYPF4bRyB7g== X-Received: by 2002:a50:d7dd:0:b0:57c:5f22:f9c1 with SMTP id 4fb4d7f45d1cf-57cbd68e34amr4743623a12.21.1718513612467; Sat, 15 Jun 2024 21:53:32 -0700 (PDT) Received: from localhost.localdomain ([2001:871:260:1b6e:3eed:be:5f2e:2e0c]) by smtp.gmail.com with ESMTPSA id 4fb4d7f45d1cf-57cb72ce05csm4588749a12.2.2024.06.15.21.53.31 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 15 Jun 2024 21:53:32 -0700 (PDT) Message-ID: <56da532b44bc02a7648796041ffa5da0a85c06df.camel@cybertec.at> Subject: Re: DROP COLLATION vs pg_collation question From: Laurenz Albe To: Karsten Hilbert Cc: pgsql-general@lists.postgresql.org Date: Sun, 16 Jun 2024 06:53:31 +0200 In-Reply-To: References: <26f717988471c4d672cce8c495a2c8e68446486a.camel@cybertec.at> Autocrypt: addr=laurenz.albe@cybertec.at; prefer-encrypt=mutual; keydata=mQINBGGDwAQBEADgbWy5cKXQld3N2mF+DFyiNFbi2oBl2T+XgxpPF8wTRw2D/u4bBKXP0SYSE/lA86jIVNWWU0gf1KODIkVvgJm2w4vH2VBV1b7ddVViGl1Iu+9zaRnv9wulhnH42KefepXnoean6UT1EzLM0opF/Ik0j+40TxdRtobkBprkQUyHDXWlHc2ffPs3SipyFEP9AVLf7ejRC46CXWDnsqjOBSMEW8Z4HiK/8RrPZBsKLts8dJxKF4pygOdJb0CWk8k/X1jbcfdxo+zOLjOMvJcSJ2pFdJmQHU+JufB3rePziqQ2S9Ur6sccr9XnTC1GVBWN4Lf5VHq+vf+bFJjVwg+2hrySZnAVfcOrxoqFLErr7ug1zN2nM1kcpgA4VWn4gxlJtYNYYq+9WxX5dtvnNANlG3ZCrRKQzl8lxtzoF6Zo7LUhEqPaHDwn7Rvs+IdbOn41lF5UDTJGqmC4gS/bZydW2Fy3YWm4aSaN9fgFf8D+PVkrlKAZB7gBLz1TyHjbcRf85cYF+GKKrDld5SzMB/V60VX3oP/Eo8ikFpyWaqiz1f9X7MBot3/PjJkY+wDzp3nmb19QEcOBuQiSQ4xds2r0HewbuHTAR68u8jNNMGmpm2j4x+g09Jd/WQDjqlTBZ/jEltH41fYCCPWMfljXTOOXu2eLNGdfi7ETZogtwjM9oTtSPQARAQABtCdMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5hdD6JAk4EEwEIADgWIQR0CqhbZGGABqoaSbdi8bhXA2EdmAUCYYPABAIbAwULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRBi8bhXA2EdmM/6EADK232JCwmBzhlj8h7U9CjG6kx0JHP3uJGv+XfsHtHAlmY/RCwF1BHMEsRlk bT5UrLvJ2jb99bA9QARzhFaxzyn0F/BUKzuIjRGNs/n6d5dNUFA0kOt8sX+TacmC GEyjEBCrVCm4ranBiUyePn9NhHNWnaex7pJyqvMLLdwW9BEMJx0Fqo+DN8ukbXmYRsmhEtd3ue+x/luYmOmJnaGtzInaY5aOJYbW9XqoRIZkZvOCgbi1FfvNmoqWa+3oVxTOgw9RafjJDyW0lTHzKGjbGI5ofMU98l+/hKJFYJqWUF6VpFJY5YIcN/1lf4ZICMwDl+MPIVo/tpq8L10seJL28nLlvw3K+cI+TVW8IW/qL/LyVoDofI3USeOORuYmhpWRhik8JXX6xf3v6GrRilJIPWNFIJbxm1ZblQiQnOw3IOW7T+8nAmPin1HKqM3VrOrJQ2VtShsefNBibNAsr1oFaqcDBkn3yGG8i6CTW+FyO4PZ+/EwNxMVgktxbYdy5AT1/lpXr5tB+phhLIyVfiBvrWs5EThxYMQ/L8Y85c3GMsAy1l/x4h3jqySIYy3SCU9+jc5UVuNnXljbvkEzJ+NLWJ6C1rACFWrMszgPdh5tCrlRY9PpmYll4JbCgb8BtxEIUmR+xr50/ZElEK5iml7Q00KUekCcDt+36PsyGFTXBzNOrkCDQRhg8AEARAAzOZ2tLHlI4rrhG411h6cdCFjBZxuljaFCxFyHn3m6wbGLqwBUWC5k8UrRqjHMz88KcTSaNO7XGAmCqPdWd2SeflPZRnNTbjsVpw7mLdffsBm4JX7kki2Pvk5h0NtYeidXT1PSpc2ri4DutYXuT9uD8RAm1wUDCE5HQNUihT/WH6opt+hskHW21uHao0+y822tG0QQcGMqdQR5Vxdxj89wiEPdqW+HpU/oOZIhrf2E7prduAppxixjHy/o1rcnoznnJvc8D3+YgI9O0LrBMij89dM55pRGbLovTR1oGR3U74sX774+0xmSzeIKwZfiMUz7Atlvfk5SHOsRUFPN2Ux9kaXiiBibQpHFxt7b lDrT4wxdLJ/XCdbPPAyl+lZtOLsaHEEZvYNyTXwZc35dVf3R4/oz20HoG6s7ct8e1 AQygj43XAERzty9SkWgxs8+grp1PrGx6FHVSYRqBM8dS/ZR6yRVwOwJXPyaSSqfIF21DkE4j1y4n+ItSewPGoRp8K/yWCikt6qlkVkO2ASNIiX04fAbtzwVOaNn8ZMRNqyvLc1fED4sr49onE4cAIcBLjcC3KL+w9DUGRQCdziROj5H2Yl/sXGPdMciUHo/Uz2rggc+2th3bQiMhrHWSsBpUkDQp0yWewemstPpPgBL3h2fHKaX8B9oH5Qu/H1IgrOuX8AEQEAAYkCNgQYAQgAIBYhBHQKqFtkYYAGqhpJt2LxuFcDYR2YBQJhg8AEAhsMAAoJEGLxuFcDYR2YuPwQAMkpGtR80pQ1gVsONhdkqj0H2eU66efP/gO3CoyaoIcvrpKYj7C2HipVSmkt1gpByL0X4AMQ/vKuknUz3wd28Ba+G1dCfbVs/Xiusq+SmpUj5rTwmYqdSjWMuCo1R6oS5hdJMdUUJYGMT0QkVlm1KnW8jkmCTl9GzjDxOAsN9O6/6lPzaGFtk9XF+34Bry/N4HKiJkqpC4+UTd0AprPfzJ2jdT64e1F0+W88X8y1bTTgNrHwK4mDiLnlE4SKRuEm54lNhJz//ar86Or5BErzNpM6TL7lk44QS06hwsMrEdKIy8J/SYJPjfzR8tIUnKscclVpOgjKaBqC+0iFiVaRqAgfOlIEiezX6kMh5Q2FIUfqs46qWhhXjRrdKOEoStYAaikdLu5ZXr7vfb0ZaDh+ZwTQtbSMFolyOkecwI81MCdbMfT/1TqIGTOdAj5as9fAakk0jb2pXgUYQ8X1DVTR8ahSDVEaw9VTmWiSvTxvguVJ1Mb7gG4Gmh6aviDTJhfXtH4rPUNXhDLqrTH8JkJjyKROOMakIF68Hjse5vUfUxreBEOtb5r1Coa2Fe7ncJayaSE7ryrDbFqpZ 36UMAx4ulWMyqJajLNGY0DdG8qIsR5nxRhrnK/mrCidZ8F9/D3bWAl4rjtHlsztN59 +AnW5l0HsQcY9ntFL/zEBOaonjdJf Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.50.4 (3.50.4-1.fc39) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2024-06-14 at 22:08 +0200, Karsten Hilbert wrote: > Are collations per-database or per-cluster objects ? Each database has its own "pg_collation" catalog table. So they are local to the database, but the collations themselves are defined by an external library, so the implementation is shared. > I am asking because I seem to not be enabled to >=20 > 3) update collation version information in pg_collations for > =C2=A0=C2=A0 collations intended for an encoding different from the > =C2=A0=C2=A0 database encoding (ALTER COLLATION ... REFRESH VERSION fails= ) >=20 > which in effect would mean that -- upon change of collation > versions in the underlying operating system (ICU update, libc > update) -- one would have to live with outdated version > information in pg_collations short of dump/sed/restore or > some such ? That should not happen. What error do you get when you ALTER COLLATION ... REFRESH VERSION Does the following give you the same error? ALTER DATABASE ... REFRESH COLLATION VERSION Yours, Laurenz Albe