Hi
Donald,
This
is a feature, not a bug :-)
Seriously, pgAdmin figures out that the index is part of a constraint and
classes it as a system object, therefore hiding it. If you switch on View System
Objects on the View menu, you will see both indexes under the table. My guess is
that pg_dump is not quite so clever and misses the UNIQUE constraint from the
table definition, adding the index manually instead.
Regards, Dave.
|
Title: Message
- [pgadmin-support] Strange bug... Donald Fraser
- Re: [pgadmin-support] Strange bug... Dave Page
- Re: [pgadmin-support] Strange bug... Donald Fraser
- Re: [pgadmin-support] Strange bug... Dave Page