| 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: | Whole Thread | Raw Message | 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 |