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

Поиск
Список
Период
Сортировка
От Alex Balan
Тема BUG #4278: pg_dump data outputs when run from command prompt in unreliable
Дата
Msg-id 200807040126.m641QgXs049979@wwwmaster.postgresql.org
обсуждение исходный текст
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      4278
Logged by:          Alex Balan
Email address:      alex.balan@carainformation.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....

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Russell Smith
Дата:
Сообщение: Re: libpq does not manage SSL callbacks properly when other libraries are involved.
Следующее
От: "Vitold S"
Дата:
Сообщение: BUG #4279: Bad codepage in our web-site