Hello Ben,
Unless I am wrong there is a set of RPMs available via the PostgreSQL site for
8.1.1/2 http://www.postgresql.org/ftp/binary/v8.1.2/linux/rpms/
Aly.
Benjamin Smith wrote:
Version: postgresql-8.1.0-4.c4
I'll have to see about getting an update...
Thanks a TON,
-Ben
On Wednesday 25 January 2006 13:11, you wrote:
Benjamin Smith <lists@xxxxxxxxxxxxxxxxxx> writes:
Aha, yep. Sorry:
Program received signal SIGSEGV, Segmentation fault.
0x000000000043c82c in heap_modifytuple ()
(gdb) bt
#0 0x000000000043c82c in heap_modifytuple ()
#1 0x000000000043c8f5 in slot_getattr ()
#2 0x000000000047a50a in FormIndexDatum ()
#3 0x00000000004ebee3 in ExecInsertIndexTuples ()
#4 0x00000000004e5265 in ExecutorRun ()
#5 0x0000000000564312 in FreeQueryDesc ()
#6 0x0000000000565287 in PortalRun ()
#7 0x0000000000560f8b in pg_parse_query ()
#8 0x0000000000562e0e in PostgresMain ()
#9 0x000000000053d316 in ClosePostmasterPorts ()
#10 0x000000000053ea59 in PostmasterMain ()
#11 0x00000000005033c3 in main ()
Oh, so this is happening during index entry creation? (The reference to
heap_modifytuple is misleading, but in a debug-symbol-free backend it's
not so surprising.)
This suddenly looks a whole lot like a known bug:
http://archives.postgresql.org/pgsql-hackers/2005-11/msg01016.php
Which version did you say you were using exactly? That bug is fixed
in 8.1.1 ...
regards, tom lane
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
Aly S.P Dharshi
aly.dharshi@xxxxxxxxx
"A good speech is like a good dress
that's short enough to be interesting
and long enough to cover the subject"