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

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

Browse pgsql-bugs by date

  From Date Subject
Next Message Vitold S 2008-07-04 05:58:43 BUG #4279: Bad codepage in our web-site
Previous Message Russell Smith 2008-07-03 23:07:30 Re: libpq does not manage SSL callbacks properly when other libraries are involved.