Thread: 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 toanother 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 tobe able to work correctly on different servers ! Have fun, L@u The Computing Froggy ----- Message d'origine ---- De : Guillaume Lelarge <guillaume@lelarge.info> À : rod@iol.ie Cc : Laurent ROCHE <laurent_roche@yahoo.com>; 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. <!-- 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
On 19/06/2007 13:54, Laurent ROCHE wrote: > May be that's a pg_dump issue: it should be compatible with the > server it connects to, and not to its own version ? What do you mean? > Still meanwhile I would think pgAdmin should allow installing other > pg_dump executable. I'm fairly sure that pgAdmin will work with whatever pg_dump you have handy. > And it should switch from one to another to be able to generate > a correct code, according to the server used. Agreed - an option in the preferences to specify the path to the desired pg_dump would certainly be useful. > 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 ! The installer guys are going to *love* that suggestion! :-) Ray. --------------------------------------------------------------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie ---------------------------------------------------------------
Raymond O'Donnell wrote: > On 19/06/2007 13:54, Laurent ROCHE wrote: > >> May be that's a pg_dump issue: it should be compatible with the >> server it connects to, and not to its own version ? > > What do you mean? Shipping every version of pg_dump, libpq & supporting DLL's back to v7.3 by the sound of it! >> Still meanwhile I would think pgAdmin should allow installing other >> pg_dump executable. > > I'm fairly sure that pgAdmin will work with whatever pg_dump you have > handy. It will. >> And it should switch from one to another to be able to generate >> a correct code, according to the server used. > > Agreed - an option in the preferences to specify the path to the desired > pg_dump would certainly be useful. Already in the next release. >> 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 ! > > The installer guys are going to *love* that suggestion! :-) That simply isn't gonna happen. /D
On 19/06/2007 14:36, Dave Page wrote: > Raymond O'Donnell wrote: >> Agreed - an option in the preferences to specify the path to the desired >> pg_dump would certainly be useful. > > Already in the next release. Great! >>> another one with all compatible tools versions to be able to work >>> correctly on different servers ! >> The installer guys are going to *love* that suggestion! :-) > > That simply isn't gonna happen. I wouldn't imagine it was a serious suggestion in the first place. :-) Anyway, the other change (above) should take care of the needs of anyone who has to juggle multiple pg_dump versions. Ray. --------------------------------------------------------------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie ---------------------------------------------------------------