Lists: | pgsql-bugs |
---|
From: | "Alex Balan" <alex(dot)balan(at)carainformation(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #4278: pg_dump data outputs when run from command prompt in unreliable |
Date: | 2008-07-04 01:26:42 |
Message-ID: | 200807040126.m641QgXs049979@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4278
Logged by: Alex Balan
Email address: alex(dot)balan(at)carainformation(dot)com
PostgreSQL version: 8.3.3 Windows
Operating system: Windows XP SP2
Description: pg_dump data outputs when run from command prompt in
unreliable
Details:
Have reinstalled Postgres 8.3.3 on Windows
database encoding SQL_ASCII (dbname is remoteupload)
have following table:
CREATE TABLE scan_d
(
scan_id bigint NOT NULL DEFAULT 0,
scan_page integer NOT NULL DEFAULT 0,
scan_type character(6) NOT NULL DEFAULT ''::bpchar,
scan_data bytea,
CONSTRAINT pk_scan_id_and_page PRIMARY KEY (scan_id, scan_page)
)
WITH OIDS;
ALTER TABLE scan_d OWNER TO postgres;
GRANT ALL ON TABLE scan_d TO postgres;
INSERT INTO scan_d (scan_id,scan_page,scan_type) VALUES (1,1,'TIFF');
INSERT INTO scan_d (scan_id,scan_page,scan_type) VALUES (2,11,'ABC');
INSERT INTO scan_d (scan_id,scan_page,scan_type) VALUES (3,111,'XYZ');
runas /user:CARA2\postgres cmd.exe
C:\Program Files\PostgreSQL\8.3\bin\pg_dump.exe -i -h 192.168.100.77 -p
5432 -U postgres -F c -v -D -f
"D:\SCAN_DIRBACKUP_DIR\scan_d_upload_20080703175038.backup" -t scan_d -n
public remoteupload
DELETE FROM scan_d;
Now take the backup and restore it in pg_Admin III (ver 1.6.3 rev 6112)
SELECT scan_id,scan_page,scan_type FROM scan_d;
60716 1 TIFF
It always returns ONLY ONE RECORD with 60716 as scan_id
Tried without option -D, same results only one record with id 60716....