Re: [BUGS] ALTER INDEX/ALTER TABLE on indexes can cause unrestorable dumps

2008-01-07 Thread Alvaro Herrera
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

[BUGS] ALTER INDEX/ALTER TABLE on indexes can cause unrestorable dumps

2008-01-07 Thread Stefan Kaltenbrunner
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