Thanks for your reply. Actually I had already changed the sizeof()s..
Not sure of the actual error, postmaster just dies: NOTICE: Didn't find 9 -- good NOTICE: about to extract object at key 0 (extra notice added by me) LOG: server process (PID 55483) was terminated by signal 11: Segmentation fault Wondering if it was just me..? ----- Original Message ---- From: Tom Lane <t...@sss.pgh.pa.us> To: Jay Flattery <jayc...@rocketmail.com> Cc: pgsql-general@postgresql.org Sent: Wed, August 4, 2010 3:46:24 PM Subject: Re: [GENERAL] hashtable issue - HASH_FIND?? Jay Flattery <jayc...@rocketmail.com> writes: > I'm looking to use the PostgreSQL Hash Table for some custom functions. > However, the example, as per http://wiki.postgresql.org/wiki/HashTable > crashes > postmaster (or segfaults from the cmd line) when trying to retrieve an > element > from the hash. I think the "palloc(sizeof(key))" bits ought to be "palloc(sizeof(*key))" ... or personally I'd have used sizeof(HashKey). Although offhand it looks like that should be the same size or larger, so it doesn't seem to explain a crash. Where's the crash happening exactly? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general