Bug in pg_dump.exe/pg_restore (Version 8.4 beta 2) - Mailing list pgsql-bugs

Hello,

I'm testing now for almost a day, and I'm pretty sure now that this is a bu=
g.

I tried to collect as much information for you as possible.

=20

following behaviour:

=20

I have a UTF8 encoded database (with name MANZPartCarrier), running on Wind=
owsXP. Dump/Restore work fine with PostgreSQL 8.3.6, but not with 8.4 beta =
2.

=20

=20

// 1. Create the database, via silent installation

msiexec /i Installer\postgresql-8.4-beta2-int.msi  /qn INTERNALLAUNCH=3D1 D=
OSERVICE=3D0 NOSHORTCUTS=3D1 DOINITDB=3D0 ADDLOCAL=3D"server,psql,pgadmin,i=
ncludefiles,libfiles,nls" PERMITREMOTE=3D1 BASEDIR=3D%pgPath% /Lime Log\PGS=
erverInstallationLog.txt

=20

// 2. Init DB with UTF8 settings

%pgPath%\bin\initdb.exe --username=3D"sa" --pwfile=3D"SAPassword.txt" --pgd=
ata=3D%pgPath%\data --encoding=3DUTF8 --locale=3D"English_United States" --=
xlogdir=3D%walPath%

=20

// 3. Backup the DB (also tried with explicid -E UTF8 or -E Windows_1252)

%backupPath%\..\bin\pg_dump.exe -h localhost -p 5432 -U sa -F c -b -v -f %b=
ackupPath%\%ManzPartCarrierFileName% "MANZPartCarrier"

=20

=20

// Some intermediate steps (from my point of view not important)

  // Stopping database, to disconnect connections and background tasks

  pg_ctl.exe stop -w -D "..\data" -m fast

=20

  // Restart database

  Net.exe start pgMANZDB

=20

  // Drop current database

  // dropdb -U sa MANZPartCarrier

=20

// 4. Restore the db

..\bin\pg_restore.exe -h localhost -p 5432 -U sa -C -d postgres -v "%backup=
Path%\MANZPartCarrier_Original.backup"

=20

--> Result:

A warning appear on the console: WARNING: errors ignored on restore: 152

=20

The db log shows:

... CEST ERROR: syntax error at or near "@" at character 33

... CEST STATEMENT: ALTER FUNCTION public.sp_pp_set(@ppnr integer, @JobID c=
haracter varying) OWNER TO sa;

=20

It fails to restore the parameters of a lot of functions... only 2 function=
s (without any parameter) are restored fine.

=20

=20

=20

=20

=20

Beste Gruesse / best regards

Andreas Nolte

=20

Manz Automation AG
Andreas Nolte
Entwicklung / Applikation Software HMI & SCADA

R & D / Application Software HMI & SCADA

=20

Steigaeckerstrasse 5
D-72768 Reutlingen
T +49.(0)7121.9000-844
F +49.(0)7121.9000-279

E anolte@manz-automation.com
www.manz-automation.com <http://www.manz-automation.com/>=20

=20








Manz Automation AG - Steigaeckerstr. 5 - 72768 Reutlingen
Handelsregister: HRB 353989 Registergericht Stuttgart
Vorstandsvorsitzender: Dieter Manz
Vorstand: Dieter Manz, Otto Angerhofer, Martin Hipp, Volker Renz
Aufsichtsratsvorsitzender: Dr. Jan Wittig
_____________________________________________________________________
Diese E-Mail ist nur fuer den Empfaenger bestimmt, an den sie gerichtet
ist und kann vertrauliches bzw. unter das Berufsgeheimnis fallendes
Material enthalten. Jegliche darin enthaltene Ansicht oder Meinungs-
aeusserung ist die des Autors und stellt nicht notwendigerweise die
Ansicht oder Meinung der Manz Automation AG dar.
Sind Sie nicht der Empfaenger, so haben Sie diese E-Mail irrtuemlich
erhalten und jegliche Verwendung, Veroeffentlichung, Weiterleitung,
Abschrift oder jeglicher Druck dieser E-Mail ist strengstens untersagt.

Weder die Manz Automation AG noch der Absender (Andreas Nolte)
uebernehmen die Haftung fuer Viren; es obliegt Ihrer Verantwortung,
die E-Mail und deren 0 Anhaenge auf Viren zu pruefen.
0 Anhaenge:

_____________________________________________________________________
This e-mail is intended only for the recipient to whom it is addressed
and may include confidential or proprietary information.
Any views or opinions presented in this email are
solely those of the author and do not necessarily represent
those of Manz Automation AG.
If you are not the intended recipient, any disclosure, copying,
or distribution is strictly prohibited.

Neither Manz Automation AG nor the sender (Andreas Nolte)
accepts any responsibility for loss or damage caused by any virus transmitt=
ed by this e-mail.
It is the responsibility of the recipient to check this e-mail and any atta=
chments for viruses.
0 Attachments:

_____________________________________________________________________