On Tuesday 05 February 2008 11:04:07 Mike Williams wrote: > Compiling postgresql non-hardened allows me to create any table I like, and > throw a couple hundred meg of data and schema at it in one go. Seems to be a problem specific to stack smashing protection. If I compile with -fno-stack-protector I can't make it crash, but psql loses it's command history (both recall and saving). # find /etc/portage/env/ -type f -print -exec cat "{}" \; /etc/portage/env/dev-db/postgresql source /etc/make.conf CFLAGS="${CFLAGS} -fno-stack-protector" -- Mike Williams System Administration Manager - Comodo Office Tel Europe: +44 (0) 161 8747070 Fax Europe: +44 (0) 161 8771767 ---------------------------(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