Possible dump/restore bug - Mailing list pgsql-general

From William Yu
Subject Possible dump/restore bug
Date
Msg-id cpl3g0$30j5$1@news.hub.org
Whole thread Raw
Responses Re: Possible dump/restore bug  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
It seems that upon dump & restore, UPPER indexes either aren't recreated
correctly or not listed somewhere the query analyzer can know it exist.
I've encountered first encountered this problem doing an upgrade to
7.3.7 to 7.4.6. I again encountered this program replicating a server
(same 7.4.6 on both source & dest). Dropping the index and creating it
again seems to fix the issue.

This server isn't slated to go live for another few weeks so I can leave
it in this semi-crippled state for some debugging/testing if needed.

pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: [ADMIN] plperl loading
Next
From: Tom Lane
Date:
Subject: Re: Possible dump/restore bug