CREATE COLLATION IF NOT EXISTS
Hackorum builds and tests every patch posted to the lists, not only commitfest submissions. This is Hackorum's own CI rather than the PostgreSQL project's, and it is still under testing - please report anything that looks wrong.
You can run a PostgreSQL built from this patch straight from Docker, with no checkout and no build:
docker run --rm -p 5432:5432 ghcr.io/hackorum-dev/postgres-patch:t35999psql -h localhost -U postgresBuilt from patchset v1 (message #1), July 28, 2026 at 08:19 AM.
Every patchset is also pushed to a branch of our PostgreSQL fork, so you can check out the same tree CI built. Without a PostgreSQL checkout:
git clone --branch t35999_1 https://github.com/hackorum-dev/postgres.gitIn a checkout you already have, add the fork once:
git remote add hackorum https://github.com/hackorum-dev/postgres.gitthen, for this patchset and every later one:
git fetch hackorum t35999_1 && git checkout t35999_1Patchset v1 (message #1) is on t35999_1
Here is a patch to complete the implementation of CREATE COLLATION IF
NOT EXISTS. The meat of this was already implemented for
pg_import_system_collations; this just exposes it in the SQL command.
If we go ahead with ICU, then creating collations by hand will become
more common, so this could be useful in practice.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
On 2/8/17 10:55 PM, Peter Eisentraut wrote:
Here is a patch to complete the implementation of CREATE COLLATION IF
NOT EXISTS. The meat of this was already implemented for
pg_import_system_collations; this just exposes it in the SQL command.
committed
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers