Markus Bertheau ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
pg_dump errors on renamed primary key column names
Long Description
Sample Code
test=# select version();
version
-------------------------------------------------------------
PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.96
(1 row)
test=# create table "tt" (
test(# id int8 not null,
test(# parent int8,
test(# primary key("id")
test(# );
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'tt_pkey' for table 'tt'
CREATE
----------------- dump test1.dump follows ------------
\connect - root
CREATE TABLE "tt" (
"id" int8 NOT NULL,
"parent" int8,
PRIMARY KEY ("id")
);
COPY "tt" FROM stdin;
\.
----------------- dump end ----------------
test=# alter table tt rename id to forum_id;
ALTER
----------------- dump test2.dump follows ------------
\connect - root
CREATE TABLE "tt" (
"forum_id" int8 NOT NULL,
"parent" int8,
PRIMARY KEY ("id")
);
COPY "tt" FROM stdin;
\.
----------------- dump end ----------------
test=#
[root@entwicklung01 bertheau]# psql -d test < test2.dump
You are now connected as new user root.
ERROR: CREATE TABLE: column 'id' named in key does not exist
ERROR: Relation 'tt' does not exist
invalid command \.
is this a bug?
Markus Bertheau
No file was uploaded with this report
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
