From: | "Carlos Chvez" <cchavez(at)agssa(dot)net> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #1845: pg_dump data only COPY wrong order |
Date: | 2005-08-24 18:36:57 |
Message-ID: | 20050824183657.BFF65F11D4@svr2.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 1845
Logged by: Carlos Chvez
Email address: cchavez(at)agssa(dot)net
PostgreSQL version: 8.0.3-1
Operating system: Fedora Cora 4 kernel-2.6.12-1.1398
Description: pg_dump data only COPY wrong order
Details:
Hello to all.
I think this is a BUG, the order of the instruction COPY are generated in
wrong order, this is part of my schema of the database:
CREATE TABLE coempleadora
(
coe_id int4 not null default
nextval('coempleadora_coe_id_seq'),
coe_nombreempresa varchar(40) unique not null,
coe_nombrecomercial varchar(100) unique not null,
primary key(coe_id),
CHECK(coe_admin BETWEEN 0 AND 1)
);
CREATE TABLE cocliente
(
coe_id int4 not null,
coc_id int4 not null default
nextval('cocliente_coc_id_seq'),
coc_nombreempresa varchar(40) unique not null,
coc_nombrecomercial varchar(100) unique not null,
primary key(coe_id,coc_id),
foreign key(coe_id) references coempleadora(coe_id) on update CASCADE
);
when i use pg_dump the file generated have first the COPY for the table
cocliente and then they have the COPY for coempleadora, this are wrong.
when i use pg_dump with postgresql-7.4.8-1 the order for the instruction
COPY are in the correct Order.
so, any idea about hits ?
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Alley | 2005-08-25 00:02:05 | BUG #1846: PostgreSQL oledb driver |
Previous Message | T.J. Ferraro | 2005-08-24 17:36:13 | Re: Ref: BUG#1321: SSL error: sslv3 alert handshake failure |