BUG #2299: pg_dump error w/ renamed primary keys

Поиск
Список
Период
Сортировка
От Gavin Scott
Тема BUG #2299: pg_dump error w/ renamed primary keys
Дата
Msg-id 20060303181807.05EB5F0B06@svr2.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #2299: pg_dump error w/ renamed primary keys  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      2299
Logged by:          Gavin Scott
Email address:      gavin@planetacetech.com
PostgreSQL version: 8.1.3
Operating system:   fedora core 4
Description:        pg_dump error w/ renamed primary keys
Details:

If you rename a primary key, pg_dump tries to recreate it with the original
name.  Here is how to recreate:

[postgres81@boll ~]$ createdb bug
CREATE DATABASE
[postgres81@boll ~]$ psql bug << EOF
> CREATE TABLE foo ( id integer );
> ALTER TABLE foo ADD CONSTRAINT foo_pkey PRIMARY KEY (id);
> ALTER TABLE foo_pkey RENAME TO bar_pkey;
> EOF
CREATE TABLE
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "foo_pkey"
for table "foo"
ALTER TABLE
ALTER TABLE
[postgres81@boll ~]$ echo '\d foo' | psql bug
      Table "public.foo"
 Column |  Type   | Modifiers
--------+---------+-----------
 id     | integer | not null
Indexes:
    "bar_pkey" PRIMARY KEY, btree (id)

[postgres81@boll ~]$ pg_dump bug | grep -B 1 -i key
--
-- Name: foo_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres81;
Tablespace:
--
ALTER TABLE ONLY foo
    ADD CONSTRAINT foo_pkey PRIMARY KEY (id);

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Kashin Oleg"
Дата:
Сообщение: BUG #2300: Error in upper function
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #2300: Error in upper function