The following bug has been logged online: Bug reference: 4278 Logged by: Alex Balan Email address: [EMAIL PROTECTED] 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.... -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs