Received: from localhost (unknown [200.46.204.184])
	by developer.postgresql.org (Postfix) with ESMTP id 2D8BC2E00C1
	for <pgsql-admin-postgresql.org@developer.postgresql.org>;
	Sun, 11 May 2008 15:12:36 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 44085-04-6
	for <pgsql-admin-postgresql.org@developer.postgresql.org>;
	Sun, 11 May 2008 15:12:29 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from hs-out-0708.google.com (hs-out-0708.google.com
 [64.233.178.247])
	by developer.postgresql.org (Postfix) with ESMTP id 2E9ED2E0044
	for <pgsql-admin@postgresql.org>; Sun, 11 May 2008 15:12:20 -0300 (ADT)
Received: by hs-out-0708.google.com with SMTP id x43so1954489hsb.3
	for <pgsql-admin@postgresql.org>; Sun, 11 May 2008 11:12:18 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type;
	bh=zuBeLKKvIGiH3Yy3foj8J861+u7cfMZnjpyCnwknKrQ=;
	b=AmAzup+x1k3oMJayg60v05+sItSLf3dsc5Z5jIsvppCUHQhA/yGRxwOJT0ZmCKQnS2A086GZYNADfyQvm9MG8OJrA6Xi8hTfoDZDQC7GjzvaN6dj9Wq1A6XRoV3CfKB5t2B8L6HbbANXWkR4vPPJcvUa3cXNaKojZ4lqp/KxgF0=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=h3fiKe4woBqRmXhFkPWywDTo4WavksJQ6ZoTpCjRBhG14pTkkWsF9rPgRwpfRfyFUXDxaymfmqBa/MlUIEPM771H0y5iCQQizPE2oukHUYiuz99cYVLSGB8w2VRvqzFYUhDOCBdNYre80ITXSrUCHW9c8crsMTP3sK5vcHXaST0=
Received: by 10.90.101.7 with SMTP id y7mr9326810agb.117.1210529538292;
	Sun, 11 May 2008 11:12:18 -0700 (PDT)
Received: by 10.90.88.4 with HTTP; Sun, 11 May 2008 11:12:18 -0700 (PDT)
Message-ID: <8b3ae1cc0805111112h53156be3nbb5d6ce1cb8bc433@mail.gmail.com>
Date: Sun, 11 May 2008 14:12:18 -0400
From: "Denison Wright" <denisonwright@gmail.com>
To: pgsql-admin@postgresql.org
Subject: pg_dump 8.3 changes from 8.2
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_592_16180235.1210529538284"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200805/85
X-Sequence-Number: 29169

------=_Part_592_16180235.1210529538284
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

 <pgsql-admin@postgresql.org>
Hi,

I had a command that I used with Postgresql 8.2 that stopped working once I
upgraded to 8.3.
I am running Postgresql 8.3 on Windows Vista with the following basic
configuration:

   - database: mydb
   - user: mydbuser
   - password: mydbpassword
   - schema:myschema
   - table: mytable

When I run the following commands:

>set PGPASSWORD=mydbpassword
>pg_dump mydb -U mydbuser -a -f backup.sql -F plain -t 'myschema.mytable'

I get the following error now: "pg_dump: too many command-line arguments"

Then, I tried the following to see what would happen:

>set PGPASSWORD=mydbpassword
>set PGDATABASE=mydb
>pg_dump --username=mydbuser --format=p --table='myschema.mytable' --verbose
--data-only --file=backup.sql

Error:
dump: No matching tables were found
dump: *** aborted because of error


Does anyone know if there were changes from 8.2 to 8.3 that would cause the
above command to stop working? I couldn't tell from the 8.3 documentation
online.
If something changed, what is the appropriate parameter sequence to make
that work?

Thanks,

Denison

------=_Part_592_16180235.1210529538284
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<a href="mailto:pgsql-admin@postgresql.org"></a><br>Hi,<br><br>I had a command that I used with Postgresql 8.2 that stopped working once I upgraded to 8.3.<br>I am running Postgresql 8.3 on Windows Vista with the following basic configuration:<br>
<ul><li>database: mydb</li><li>user: mydbuser</li><li>password: mydbpassword</li><li>schema:myschema</li><li>table: mytable<br></li></ul>When I run the following commands:<br><br>&gt;set PGPASSWORD=mydbpassword<br>&gt;pg_dump mydb -U mydbuser -a -f backup.sql -F plain -t &#39;myschema.mytable&#39;<br>
<br>I get the following error now: &quot;pg_dump: too many command-line arguments&quot;<br><br>Then, I tried the following to see what would happen:<br><br>&gt;set PGPASSWORD=mydbpassword<br>&gt;set PGDATABASE=mydb <br>&gt;pg_dump --username=mydbuser --format=p --table=&#39;myschema.mytable&#39; --verbose --data-only --file=backup.sql<br>
<br>Error:<br>dump: No matching tables were found<br>dump: *** aborted because of error<br><br><br>Does anyone know if there were changes from 8.2 to 8.3 that would cause the above command to stop working? I couldn&#39;t tell from the 8.3 documentation online.<br>
If something changed, what is the appropriate parameter sequence to make that work?<br><br>Thanks,<br><br>Denison<br>

------=_Part_592_16180235.1210529538284--