i believe i found a bug
psql> create table test_failure ( id integer primary key );
psql> alter table test_failure alter id rename to id_new ; # not
relevant, just illustrating the reason how i got to step 2
psql> alter table test_failure_pkey rename to test_failure_id_new_pkey;
$ pg_dump --schema-only -ttest_failure -Utest > test.sql
the pkey in the schema is added as 'test_failure_pkey' , not
'test_failure_id_new_pkey';
it happens whether or not you use 'alter table' or 'alter index' on
the pkey name
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
