Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 394699FB919 for ; Thu, 15 Feb 2007 12:56:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 27093-02 for ; Thu, 15 Feb 2007 12:56:14 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from perth.mailnetwork.co.uk (perth.mailnetwork.co.uk [80.175.28.46]) by postgresql.org (Postfix) with ESMTP id D74329FBBDE for ; Thu, 15 Feb 2007 12:56:13 -0400 (AST) Received: from user-3e88bf95.telcl18.dsl.pol.co.uk ([62.136.191.149]:2499 helo=[10.100.9.2]) by perth.mailnetwork.co.uk with esmtpa (Exim 4.66) (envelope-from ) id 1HHju2-0004dm-Cr; Thu, 15 Feb 2007 16:56:14 +0000 Message-ID: <45D490A7.5060501@mailnetwork.co.uk> Date: Thu, 15 Feb 2007 16:56:07 +0000 From: "Andy Shellam (Mailing Lists)" User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: "Cassiano, Marco" CC: pgsql-admin@postgresql.org Subject: Re: PgAdmin : table backup problem References: <26817.1171558314@sss.pgh.pa.us> In-Reply-To: <26817.1171558314@sss.pgh.pa.us> Content-Type: multipart/alternative; boundary="------------080400010906020306080002" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.642 tagged_above=0 required=5 tests=AWL, BAYES_50, HTML_30_40, HTML_MESSAGE, HTML_TITLE_EMPTY, SPF_PASS X-Spam-Level: X-Archive-Number: 200702/218 X-Sequence-Number: 24683 This is a multi-part message in MIME format. --------------080400010906020306080002 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Tom Lane wrote: > "Cassiano, Marco" writes: > >> If I understand well, PgAdmin fails in composing the correct pg_dump command. >> The switch combination -t collezioni -n anamat doesn't work. The >> manual says that the -n switch is ignored when -t is used >> The right (at least, working) syntax seems to be the following : >> /usr/local/pgsql/bin/pg_dump -U user -F c -v -f /tmp/collezioni.backup -t anamat.collezioni mdn >> > > This is something that was changed in 8.2. You seem to be using a > PgAdmin that expects the pre-8.2 convention. If this is the latest > version of PgAdmin then you need to complain to the PgAdmin developers > (not here --- they have their own mailing lists). > FYI (the OP's original e-mail was copied in to pgadmin-support) this is fixed in the upcoming PgAdmin 1.6.3. --------------080400010906020306080002 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Tom Lane wrote:
"Cassiano, Marco" <mcassiano@manord.com> writes:
  
If I understand well, PgAdmin fails in composing the correct pg_dump command.
The switch combination -t collezioni -n anamat doesn't work. The
manual says that the -n switch is ignored when -t is used
The right (at least, working) syntax seems to be the following :
/usr/local/pgsql/bin/pg_dump -U user -F c -v -f /tmp/collezioni.backup -t anamat.collezioni mdn
    

This is something that was changed in 8.2.  You seem to be using a
PgAdmin that expects the pre-8.2 convention.  If this is the latest
version of PgAdmin then you need to complain to the PgAdmin developers
(not here --- they have their own mailing lists).
  

FYI (the OP's original e-mail was copied in to pgadmin-support) this is fixed in the upcoming PgAdmin 1.6.3.

--------------080400010906020306080002--