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

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@u
The Computing Froggy

----- Message d'origine ----
De : Guillaume Lelarge 
À : rod@iol.ie
Cc : Laurent ROCHE ; pgadmin-support@postgresql.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.





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