Re: bug in schema export?

Jonathan Vanasco <postgres(at)2xlp(dot)com> writes:
> 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';

You didn't rename the constraint. If we were going to do anything about
this, it'd be to forbid directly renaming indexes that're owned by
constraints. However, since we don't currently have a RENAME CONSTRAINT
command, the effect of that would be that you couldn't do it at all ...

In the meantime you can probably do an UPDATE on pg_constraint if you
really care.

regards, tom lane