Package: phppgadmin Version: 4.2.2-1 Tags: patch
Coin,Selecting the "SQL" format instead of the "COPY" one to have full inserts fails due to changes in the pg_dump options : --inserts cannot be shortened with -d anymore in PostgreSQL 8.4.
The tiny attached patch solves the issue. Regards. -- Marc Dequènes (Duck)
--- ./dbexport.php.orig 2010-03-25 16:07:36.000000000 +0100
+++ ./dbexport.php 2010-03-25 16:05:51.000000000 +0100
@@ -101,7 +101,7 @@
switch ($_REQUEST['what']) {
case 'dataonly':
$cmd .= ' -a';
- if ($_REQUEST['d_format'] == 'sql') $cmd .= ' -d';
+ if ($_REQUEST['d_format'] == 'sql') $cmd .= ' --inserts';
elseif (isset($_REQUEST['d_oids'])) $cmd .= ' -o';
break;
case 'structureonly':
@@ -109,7 +109,7 @@
if (isset($_REQUEST['s_clean'])) $cmd .= ' -c';
break;
case 'structureanddata':
- if ($_REQUEST['sd_format'] == 'sql') $cmd .= ' -d';
+ if ($_REQUEST['sd_format'] == 'sql') $cmd .= ' --inserts';
elseif (isset($_REQUEST['sd_oids'])) $cmd .= ' -o';
if (isset($_REQUEST['sd_clean'])) $cmd .= ' -c';
break;
pgpUdVLkrlLnj.pgp
Description: PGP Digital Signature
