Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group