Re: pg_dump and ON DELETE CASCADE problem - Mailing list pgsql-general

Adrian Klaver <aklaver@comcast.net> writes:
> On Thursday 17 December 2009 6:39:45 pm CG wrote:
>> CREATE INDEX packet_search_trigram_packet_uuid_idx
>> ON dpo.packet_search_trigram
>> USING hash
>> (packet_uuid);

> You might want to take a look at upgrading to 8.4.2 per this from the release
> notes:

Actually, what I'd recommend is dropping that hash index and replacing
it with regular btree.  And the same for any other hash indexes you
have.  Hash indexes simply are not production grade (yet).

            regards, tom lane