Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cZNYc-0006UA-61 for pgsql-docs@arkaria.postgresql.org; Thu, 02 Feb 2017 20:00:38 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cZNYb-0006Qc-PH for pgsql-docs@arkaria.postgresql.org; Thu, 02 Feb 2017 20:00:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cZNYb-0006PR-3B for pgsql-docs@postgresql.org; Thu, 02 Feb 2017 20:00:37 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cZNYW-0003qt-RU for pgsql-docs@postgresql.org; Thu, 02 Feb 2017 20:00:36 +0000 Received: from compute7.internal (compute7.nyi.internal [10.202.2.47]) by mailout.nyi.internal (Postfix) with ESMTP id 7B2D820A87; Thu, 2 Feb 2017 15:00:30 -0500 (EST) Received: from frontend2 ([10.202.2.161]) by compute7.internal (MEProxy); Thu, 02 Feb 2017 15:00:30 -0500 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d= messagingengine.com; h=content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-sender :x-me-sender:x-sasl-enc:x-sasl-enc; s=smtpout; bh=at3iBd2oyCr0Eb 4iDqO8/AYUMQ8=; b=ZcyqrswUgedvsRa+dR0uvtPGhvIrTzLgsx8jTBofiQ7HPU ZmYDUXRmAUEaLpjoZRBj9pb7/uVyZGcRILhuLla3EgkFNHIwR0iv77JFuuIPjuX0 1AzO6+B1nvQfk1X1KZiPXSOJ/fP//Ll4wVomd+sy/LYez3rhCTrm/ub2lwxRA= X-ME-Sender: X-Sasl-enc: iFyMynBTVcnDXgIXVBoF9OSlBJRfb6A7DBoBaJGLNZfu 1486065630 Received: from april.local (c-73-13-66-39.hsd1.pa.comcast.net [73.13.66.39]) by mail.messagingengine.com (Postfix) with ESMTPA id 3878C2453A; Thu, 2 Feb 2017 15:00:30 -0500 (EST) Subject: Re: Encoding change actually works) To: marc+pgsql@milestonerdl.com, pgsql-docs@postgresql.org References: <20160627082424.17236.27619@wrigleys.postgresql.org> From: Peter Eisentraut Organization: 2ndQuadrant Message-ID: <52fe192f-99b1-e916-e5ce-c4e086d163d2@2ndquadrant.com> Date: Thu, 2 Feb 2017 15:00:29 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:45.0) Gecko/20100101 Thunderbird/45.7.0 MIME-Version: 1.0 In-Reply-To: <20160627082424.17236.27619@wrigleys.postgresql.org> Content-Type: multipart/mixed; boundary="------------E820FE3A380D190A139975E2" X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org This is a multi-part message in MIME format. --------------E820FE3A380D190A139975E2 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit 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 --------------E820FE3A380D190A139975E2 Content-Type: text/x-patch; name="0001-doc-Update-CREATE-DATABASE-examples.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="0001-doc-Update-CREATE-DATABASE-examples.patch"