#571291 - Use SQL_ASCII encoding when creating the PostgreSQL database

Debian Bug report logs - #571291
Use SQL_ASCII encoding when creating the PostgreSQL database

Reported by: Michael Biebl <[email protected]>

Date: Thu, 25 Feb 2010 00:21:01 UTC

Severity: normal

Received: (at submit) by bugs.debian.org; 25 Feb 2010 00:14:50 +0000
From [email protected] Thu Feb 25 00:14:50 2010
X-Spam-Checker-Version: SpamAssassin 3.2.3-bugs.debian.org_2005_01_02
	(2007-08-08) on rietz.debian.org
X-Spam-Level: 
X-Spam-Bayes: score:0.0000 Tokens: new, 19; hammy, 150; neutral, 76; spammy,
	1. spammytokens:0.993-1--H*M:7009 hammytokens:0.000-+--H*M:reportbug,
	0.000-+--H*MI:reportbug, 0.000-+--H*x:reportbug, 0.000-+--H*UA:reportbug,
	0.000-+--UD:UTF-8
X-Spam-Status: No, score=-12.1 required=4.0 tests=AWL,BAYES_00,FOURLA,
	FROMDEVELOPER,HAS_PACKAGE,RCVD_IN_DNSWL_MED,XMAILER_REPORTBUG autolearn=ham
	version=3.2.3-bugs.debian.org_2005_01_02
Return-path: <[email protected]>
Received: from smtp2.rz.uni-karlsruhe.de ([129.13.185.218] ident=Debian-exim)
	by rietz.debian.org with esmtp (Exim 4.63)
	(envelope-from <[email protected]>)
	id 1NkRNS-0004ef-Cz
	for [email protected]; Thu, 25 Feb 2010 00:14:50 +0000
Received: from teco141pc.teco.edu (teco141pc.teco.uni-karlsruhe.de [129.13.170.141])
	by smtp2.rz.uni-karlsruhe.de with esmtp (Exim 4.63 #1)
	id 1NkRNK-0007xj-Od; Thu, 25 Feb 2010 01:14:42 +0100
Received: from e180072049.adsl.alicedsl.de ([85.180.72.49] helo=pluto)
	by teco141pc.teco.edu with esmtpsa (TLS1.0:RSA_AES_256_CBC_SHA1:32)
	(Exim 4.69)
	(envelope-from <[email protected]>)
	id 1NkRNK-0001YQ-Ee; Thu, 25 Feb 2010 01:14:42 +0100
Received: from michael by pluto with local (Exim 4.71)
	(envelope-from <[email protected]>)
	id 1NkRNJ-0001r7-4R; Thu, 25 Feb 2010 01:14:41 +0100
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: Michael Biebl <[email protected]>
To: Debian Bug Tracking System <[email protected]>
Subject: Use SQL_ASCII encoding when creating the PostgreSQL database
Message-ID: <[email protected]>
X-Mailer: reportbug 4.10.2
Date: Thu, 25 Feb 2010 01:14:40 +0100
Delivered-To: [email protected]

Package: rsyslog-pgsql Severity: normal As reference: http://lists.adiscon.net/pipermail/rsyslog/2010-January/003360.html upstream recommends to create the postgresql db with encoding 'SQL_ASCII' Determine, if we want to use SQL_ASCII in Debian or stick with the default, UTF-8 dbconfig-common's dbc_pgsql_createdb_encoding allows to specify the encoding but currently fails to create a db using SQL_ASCII as the template db uses UTF-8. -- System Information: Debian Release: squeeze/sid APT prefers unstable APT policy: (500, 'unstable'), (1, 'experimental') Architecture: i386 (i686) Kernel: Linux 2.6.33-rc8 (SMP w/1 CPU core) Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Versions of packages rsyslog-pgsql depends on: ii dbconfig-common 1.8.45 common framework for packaging dat ii debconf [debconf-2.0] 1.5.28 Debian configuration management sy ii libc6 2.10.2-5 Embedded GNU C Library: Shared lib ii libpq5 8.4.2-2+b1 PostgreSQL C client library ii rsyslog 4.6.0-1 enhanced multi-threaded syslogd ii ucf 3.0025 Update Configuration File: preserv Versions of packages rsyslog-pgsql recommends: pn postgresql-client <none> (no description available) Versions of packages rsyslog-pgsql suggests: pn postgresql <none> (no description available)

Debian bug tracking system administrator <[email protected]>. Last modified: Fri May 16 15:21:33 2025; Machine Name: bembo

Debian Bug tracking system

Debbugs is free software and licensed under the terms of the GNU General Public License version 2. The current version can be obtained from https://bugs.debian.org/debbugs-source/.

Debian Bug report logs - #571291 Use SQL_ASCII encoding when creating the PostgreSQL database

Debian Bug report logs - #571291
Use SQL_ASCII encoding when creating the PostgreSQL database