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

index with no column

From: "Didier Gasser-Morlay" <didiergm(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: index with no column
Date: 2008-04-26 18:51:34
Message-ID: 608b66ce0804261151v5badaadbvc5905696f3b43fd7@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
With this group's help (which is MUCH appreciated, thanks) I am slowly
starting to live with Postgres in a production environment.

I have setup an automated backup/restore between two machines, all is
fine. Bar on thing: after restoring mu database, I had a message about
several errors ignored (I did not keep a log of these errors), but I
am seing on several tables, some indexes declared but pgadmin3 fails
to show any columns. I had to manually drop the indexes and recreate
them

So my questions are

- How is this possible ? Should'nt the index be rejected during the
restore if there was a problem ?

- Is there a query I could write to check what are the indexes w/o
columns defined ?

Thanks in advance

Didier

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2008-04-26 20:07:47
Subject: Re: index with no column
Previous:From: Didier Gasser-MorlayDate: 2008-04-25 05:02:10
Subject: Re: Changing a trigger function

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