Re : pg_dump: ALTER SEQUENCE ... OWNED in 8.1

From: Laurent ROCHE <laurent_roche(at)yahoo(dot)com>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>, rod(at)iol(dot)ie
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re : pg_dump: ALTER SEQUENCE ... OWNED in 8.1
Date: 2007-06-19 12:54:17
Message-ID: 335740.52863.qm@web34404.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

OK, I understand that.

May be that's a pg_dump issue: it should be compatible with the server it connects to, and not to its own version ?

Still meanwhile I would think pgAdmin should allow installing other pg_dump executable. And it should switch from one to another to be able to generate a correct code, according to the server used.
There could be different installer: one with only the latest tools and another one with all compatible tools versions to be able to work correctly on different servers !


Have fun,
L(at)u
The Computing Froggy

----- Message d'origine ----
De : Guillaume Lelarge <guillaume(at)lelarge(dot)info>
À : rod(at)iol(dot)ie
Cc : Laurent ROCHE <laurent_roche(at)yahoo(dot)com>; pgadmin-support(at)postgresql(dot)org
Envoyé le : Lundi, 18 Juin 2007, 23h53mn 13s
Objet : Re: [pgadmin-support] pg_dump: ALTER SEQUENCE ... OWNED in 8.1

Raymond O'Donnell a écrit :
> On 18/06/2007 17:50, Laurent ROCHE wrote:
>
>> However my server is PG 8.1 and this is 8.2 syntax. I understand
>> pgAdmin runs a standard pg_dump but I would expect it to run a
>> version compatible with my server ! ? !
>
> I run the Windows version of pgAdmin, and the installer bundles the
> latest version of pg_dump available at the time of release - so this
> would have been 8.2 with the current pgAdmin.
>

That's right.

And bundling some releases has a cost. pgAdmin's package would be much
more heavy. One way we could try is to put the other pg_dump releases on
other packages and let the user chooses which one he wants to use. But,
GUI won't be easy.

At least, you can try with a 8.1 pg_dump release. (please, be sure to
copy your existing pg_dump before anything).

Regards.

--
Guillaume.
<!-- http://abs.traduc.org/
http://lfs.traduc.org/
http://docs.postgresqlfr.org/ -->

_____________________________________________________________________________
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Raymond O'Donnell 2007-06-19 13:17:48 Re: Re : pg_dump: ALTER SEQUENCE ... OWNED in 8.1
Previous Message Richard Huxton 2007-06-19 09:55:48 Debian Etch packaging problem?