Encoding change actually works)

Started by Nonameabout 10 years ago2 messagesdocs
Beta feature

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.

won't retrysuccessCI history

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:t75739
psql -h localhost -U postgres

Built from patchset v2 (message #2), July 28, 2026 at 08:28 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 t75739_2 https://github.com/hackorum-dev/postgres.git

In a checkout you already have, add the fork once:

git remote add hackorum https://github.com/hackorum-dev/postgres.git

then, for this patchset and every later one:

git fetch hackorum t75739_2 && git checkout t75739_2

Patchset v2 (message #2) is on t75739_2

Jump to latest
#1Noname
marc+pgsql@milestonerdl.com

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.4/static/sql-createdatabase.html
Description:

https://www.postgresql.org/docs/9.4/static/sql-createdatabase.html

Says:
CREATE DATABASE music ENCODING 'LATIN1' TEMPLATE template0;

that did not work. Whereas:

CREATE DATABASE music ENCODING 'LATIN1' TEMPLATE template0 LC_COLLATE='C'
LC_CTYPE='C';

sure DOES seem to work.

--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Noname (#1)
Re: Encoding change actually works)

On 6/27/16 4:24 AM, marc+pgsql@milestonerdl.com wrote:

https://www.postgresql.org/docs/9.4/static/sql-createdatabase.html

Says:
CREATE DATABASE music ENCODING 'LATIN1' TEMPLATE template0;

that did not work. Whereas:

CREATE DATABASE music ENCODING 'LATIN1' TEMPLATE template0 LC_COLLATE='C'
LC_CTYPE='C';

sure DOES seem to work.

How about the attached patch with some refreshed examples?

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachments:

t75739_2
0001-doc-Update-CREATE-DATABASE-examples.patchtext/x-patch; name=0001-doc-Update-CREATE-DATABASE-examples.patchDownload+23-8