Re: Using many pg_dump in pgAdmin (aka Re : Re : [pgadmin-support] pg_dump: ALTER SEQUENCE ... OWNED in 8.1)

2007-06-19 Thread Guillaume Lelarge
Laurent ROCHE a écrit : > Just to clarify what I mean. > I am quite happy (or should I say: not too unhappy) to juggle with different > version of pg_dump in my scripts. > If that's the way it has to be, that's the way it has to be. > See point A, below. > > But to me pgAdmin is a tool that must

Using many pg_dump in pgAdmin (aka Re : Re : [pgadmin-support] pg_dump: ALTER SEQUENCE ... OWNED in 8.1)

2007-06-19 Thread Laurent ROCHE
Hi, Just to clarify what I mean. I am quite happy (or should I say: not too unhappy) to juggle with different version of pg_dump in my scripts. If that's the way it has to be, that's the way it has to be. See point A, below. But to me pgAdmin is a tool that must be easy to use. Hence, as it seem

Re: Re : [pgadmin-support] pg_dump: ALTER SEQUENCE ... OWNED in 8.1

2007-06-19 Thread Raymond O'Donnell
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 d

Re: Re : [pgadmin-support] pg_dump: ALTER SEQUENCE ... OWNED in 8.1

2007-06-19 Thread Dave Page
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 s

Re: Re : [pgadmin-support] pg_dump: ALTER SEQUENCE ... OWNED in 8.1

2007-06-19 Thread Raymond O'Donnell
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 pgAdm

Re : [pgadmin-support] pg_dump: ALTER SEQUENCE ... OWNED in 8.1

2007-06-19 Thread Laurent ROCHE
ne De : Guillaume Lelarge <[EMAIL PROTECTED]> À : [EMAIL PROTECTED] Cc : Laurent ROCHE <[EMAIL PROTECTED]>; 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 éc

Re: [pgadmin-support] pg_dump: ALTER SEQUENCE ... OWNED in 8.1

2007-06-18 Thread 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

Re: [pgadmin-support] pg_dump: ALTER SEQUENCE ... OWNED in 8.1

2007-06-18 Thread 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

[pgadmin-support] pg_dump: ALTER SEQUENCE ... OWNED in 8.1

2007-06-18 Thread 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