On Tue, 2007-11-20 at 11:46 +0000, Heikki Linnakangas wrote: > >> In logs after this: > >> Nov 20 11:02:04 www postgres[32757]: [4-1] wolni>NOTICE: CREATE TABLE / > >> PRIMARY KEY will create implicit index "phpbb_acl_roles_data_pkey" for > >> table
> >> Nov 20 11:02:04 www postgres[32731]: [2-1] >LOG: server process (PID > >> 32757) > >> was terminated by signal 11 > To me it does look like it was the CREATE TABLE that crashed. The NOTICE > shows that it's process ID 32757 that's running the CREATE TABLE, and > the LOG line later on says that that's the process that crashed. Yep, agreed. :-( -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
