-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
- --On Tuesday, August 12, 2003 08:18:53 AM -0700 Stephan Szabo <[EMAIL PROTECTED]
.bigpanda.com> wrote:
On Tue, 12 Aug 2003, Kevin Houle wrote:
System Configuration - ---------------------- Architecture : i686
Operating System : RH9, 2.4.20-19
PostgreSQL version : PostgreSQL-7.3.4 (RPMS from PGDG)
Please enter a FULL description of your problem: - -------------------------------------------------
There is an email attachment (md5: 5cc780da645df9516235d43d1cf1e8b5) which contains a file with two SQL INSERT commands to insert two rows into a test table. The table should look like this:
CREATE TABLE tbl_test ( testcol text, unique (testcol) );
The databases in my testing are using SQL_ASCII encoding.
I don't receive an error on my 7.3.4 system, what locale is the database initialized in?
I'm using defaults, so on RH9 it is:
/var/lib/pgsql/initdb.i18n: LANG="en_US.UTF-8"
and on RH7.3 it is:
/var/lib/pgsql/initdb.i18n: LANG="en_US"
Kevin
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQE/OQeiu/NTC+XTbEkRAqyCAJ9dWKLKDy7ikbFFNwc6bzt7rEqj+wCfevAe LOaw4FFNrbr6wdtl0Zls+cU= =X2Z2 -----END PGP SIGNATURE-----
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
