Обсуждение: pg_dump: ALTER SEQUENCE ... OWNED in 8.1

Поиск
Список
Период
Сортировка

pg_dump: ALTER SEQUENCE ... OWNED in 8.1

От
Laurent ROCHE
Дата:
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

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

От
Raymond O'Donnell
Дата:
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
---------------------------------------------------------------

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

От
Guillaume Lelarge
Дата:
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/ -->