BUG #4278: pg_dump data outputs when run from command prompt in unreliable

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....