Thread: pg_dump: ALTER SEQUENCE ... OWNED in 8.1
Hi All, I have a table with a sequence. When I backup the table I get the following code (among other things): ... ALTER SEQUENCE documents_doc_id_seq OWNED BY documents.doc_id; ... 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 ! ? ! Cheers, L@u The Computing Froggy _____________________________________________________________________________ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail
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. Ray. --------------------------------------------------------------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie ---------------------------------------------------------------
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/ -->