dup 3854
thanks
Stefan Kaltenbrunner wrote:
> the reason for this seems to be that pg_dump is using the constraint name
> (which is not changed by ALTER TABLE/ALTER INDEX) and not the index name to
> dump this kind of information but I wonder if it would actually be more
> sensible (until we g
Andy just reported on IRC that renaming indexes can lead to unrestorable
dumps under certain circumstances. A simple example(8.2 but at least 8.1
and 8.3 seem to behave exactly the same) for that is:
test=# CREATE TABLE foo(bar int PRIMARY KEY);
NOTICE: CREATE TABLE / PRIMARY KEY will create i