Re: BUG #4860: Indexes gone after restore

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Obe, Regina" <robe(dot)dnd(at)cityofboston(dot)gov>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4860: Indexes gone after restore
Date: 2009-06-18 17:59:01
Message-ID: 12653.1245347941@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Obe, Regina" <robe(dot)dnd(at)cityofboston(dot)gov> writes:
> Your example seems to work fine for me too. I'm trying to figure out the best way to give an isolated case without requiring you install a bunch of stuff.

Well, the only two possibilities for an index not being restored are
(1) it's not listed in the dump file, or
(2) the CREATE INDEX command gets an error during the restore.

Which is it, and if (2) what's the error message?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Obe, Regina 2009-06-18 18:07:19 Re: BUG #4860: Indexes gone after restore
Previous Message Obe, Regina 2009-06-18 17:46:03 Re: BUG #4860: Indexes gone after restore