| From: | "Jonathan Vanasco" <postgres(at)2xlp(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #3234: pg_dump uses the first version of a primary key's name when generating reports |
| Date: | 2007-04-17 18:47:11 |
| Message-ID: | 200704171847.l3HIlBTj042755@wwwmaster.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 3234
Logged by: Jonathan Vanasco
Email address: postgres(at)2xlp(dot)com
PostgreSQL version: 8.2.3
Operating system: freebsd 6.1 , osx 10.4.9
Description: pg_dump uses the first version of a primary key's name
when generating reports
Details:
reposted from pg-users, sorry for posting in the wrong place:
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2007-04-17 19:09:35 | Re: BUG #3228: Linux/M32R project |
| Previous Message | Alvaro Herrera | 2007-04-17 12:51:15 | Re: Grantor name gets lost when grantor role dropped |