"Obe, Regina" <robe.dnd@cityofboston.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
requiringyou 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