Hello,
I've got a failing sql-Script that I execute with the psql command. The
Script contains:
----------------------------8<-----------------------------
SET CLIENT_ENCODING = 'LATIN1';
(Some other statements)
CREATE TABLE "public"."init_camera_type" (
"id_camera_type" SMALLINT NOT NULL,
"name" VARCHAR(75) NOT NULL,
"is_video_camera" BOOLEAN DEFAULT false NOT NULL,
"description" VARCHAR(75),
PRIMARY KEY("id_camera_type")
) WITH OIDS;
----------------------------8<-----------------------------
where it bails out. The console output is:
----------------------------8<-----------------------------
PANIK: ERRORDATA_STACK_SIZE exceeded
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
----------------------------8<-----------------------------
The postgresql.log writes:
----------------------------8<-----------------------------
2006-10-17 13:04:03 CEST FEHLER: 22021: ungültige Byte-Sequenz für
Kodierung »UTF8«: 0xbb
2006-10-17 13:04:03 CEST ORT: report_invalid_encoding, wchar.c:1328
2006-10-17 13:04:03 CEST ANWEISUNG: CREATE TABLE
"public"."init_camera_type" (
"id_camera_type" SMALLINT NOT NULL,
"name" VARCHAR(75) NOT NULL,
"is_video_camera" BOOLEAN DEFAULT false NOT NULL,
"description" VARCHAR(75),
PRIMARY KEY("id_camera_type")
) WITH OIDS;
2006-10-17 13:04:03 CEST FEHLER: 22021: ungültige Byte-Sequenz für
Kodierung »UTF8«: 0xfc6c74696765
2006-10-17 13:04:03 CEST ORT: report_invalid_encoding, wchar.c:1328
2006-10-17 13:04:03 CEST ANWEISUNG: CREATE TABLE
"public"."init_camera_type" (
"id_camera_type" SMALLINT NOT NULL,
"name" VARCHAR(75) NOT NULL,
"is_video_camera" BOOLEAN DEFAULT false NOT NULL,
"description" VARCHAR(75),
PRIMARY KEY("id_camera_type")
) WITH OIDS;
2006-10-17 13:04:03 CEST FEHLER: 22021: ungültige Byte-Sequenz für
Kodierung »UTF8«: 0xfc6c74696765
2006-10-17 13:04:03 CEST ORT: report_invalid_encoding, wchar.c:1328
2006-10-17 13:04:03 CEST ANWEISUNG: CREATE TABLE
"public"."init_camera_type" (
"id_camera_type" SMALLINT NOT NULL,
"name" VARCHAR(75) NOT NULL,
"is_video_camera" BOOLEAN DEFAULT false NOT NULL,
"description" VARCHAR(75),
PRIMARY KEY("id_camera_type")
) WITH OIDS;
2006-10-17 13:04:03 CEST FEHLER: 22021: ungültige Byte-Sequenz für
Kodierung »UTF8«: 0xfc6c74696765
2006-10-17 13:04:03 CEST ORT: report_invalid_encoding, wchar.c:1328
2006-10-17 13:04:03 CEST ANWEISUNG: CREATE TABLE
"public"."init_camera_type" (
"id_camera_type" SMALLINT NOT NULL,
"name" VARCHAR(75) NOT NULL,
"is_video_camera" BOOLEAN DEFAULT false NOT NULL,
"description" VARCHAR(75),
PRIMARY KEY("id_camera_type")
) WITH OIDS;
2006-10-17 13:04:03 CEST PANIK: XX000: ERRORDATA_STACK_SIZE exceeded
2006-10-17 13:04:03 CEST ORT: errstart, elog.c:274
2006-10-17 13:04:03 CEST ANWEISUNG: CREATE TABLE
"public"."init_camera_type" (
"id_camera_type" SMALLINT NOT NULL,
"name" VARCHAR(75) NOT NULL,
"is_video_camera" BOOLEAN DEFAULT false NOT NULL,
"description" VARCHAR(75),
PRIMARY KEY("id_camera_type")
) WITH OIDS;
2006-10-17 13:04:03 CEST DEBUG: 00000: reaping dead processes
2006-10-17 13:04:03 CEST ORT: reaper, postmaster.c:2021
2006-10-17 13:04:03 CEST DEBUG: 00000: Serverprozess (PID 32435) wurde
von Signal 6 beendet
2006-10-17 13:04:03 CEST ORT: LogChildExit, postmaster.c:2428
----------------------------8<-----------------------------
I don't think there are invalid byte sequences in my script. In fact
there is no occurrence of 0xbb anywhere in the script.
The database that script is applied to is UTF8 encoded.
The postgresql version is 8.1.4.
My system is Linux pc01 2.6.17-gentoo-r8 #2 SMP Mon Oct 16 11:23:12 CEST
2006 i686 Intel(R) Pentium(R) 4 CPU 2.60GHz GNU/Linux
Is there someone who can explain what's going on here?
Regards
Stefan
