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

The following bug has been logged online:

Bug reference:      4278
Logged by:          Alex Balan
Email address:      alex.balan@[EMAIL PROTECTED]
 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@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs