The following bug has been logged online:
Bug reference: 3653
Logged by: Marc Munro
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.5
Operating system: Linux 2.6.15.6 #4 SMP PREEMPT i686
Description: Database crash
Details:
Also occurs on 8.2.3 and 8.1.4
The following script causes a db server crash:
psql -d postgres <<'CLUSTEREOF'
create database "skittest" with
encoding 'UTF8'
connection limit = -1;
CLUSTEREOF
psql -d skittest <<'DBEOF'
create or replace function "public"."mycharin"(
in "pg_catalog"."cstring")
returns "public"."mychar"
as 'charin'
language internal immutable strict;
create or replace function "public"."mycharout"(
in "public"."mychar")
returns "pg_catalog"."cstring"
as 'charout'
language internal immutable strict;
create type "public"."mychar"(
input = "public"."mycharin",
output = "public"."mycharout",
internallength = -1,
alignment = char,
storage = plain,
delimiter = ',');
create domain "public"."postal3"
as "public"."mychar"
default 'xxx' not null;
comment on domain "public"."postal3" is
'wibble';
DBEOF
The following is from the log file:
2007-10-04 11:05:40 PDT NOTICE: type "public.mychar" is not yet defined
2007-10-04 11:05:40 PDT DETAIL: Creating a shell type definition.
2007-10-04 11:05:40 PDT NOTICE: argument type public.mychar is only a
shell
2007-10-04 11:05:40 PDT LOG: server process (PID 13775) was terminated by
signa
l 11
2007-10-04 11:05:40 PDT LOG: terminating any other active server processes
2007-10-04 11:05:40 PDT LOG: all server processes terminated;
reinitializing
2007-10-04 11:05:40 PDT LOG: database system was interrupted at 2007-10-04
11:0
5:34 PDT
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
