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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-04-26 20:07:47 | Re: index with no column |
Previous Message | Didier Gasser-Morlay | 2008-04-25 05:02:10 | Re: Changing a trigger function |