Re: [ADMIN] pg_dump doesn't save correct the sequences

2004-10-28 Thread Andrei Bintintan
<[EMAIL PROTECTED]> Sent: Thursday, October 28, 2004 9:22 AM Subject: Re: [ADMIN] pg_dump doesn't save correct the sequences > > On Thu, 28 Oct 2004, Andrei Bintintan wrote: > > > I try to dump a database from a 7.4.2 postgre system and to import it on > > a 7.3

Re: [ADMIN] pg_dump doesn't save correct the sequences

2004-10-27 Thread Stephan Szabo
On Thu, 28 Oct 2004, Andrei Bintintan wrote: > I try to dump a database from a 7.4.2 postgre system and to import it on > a 7.3.2. system, but I have a problem with the sequences in the dump. In general, the above is not guaranteed to work. pg_dump will use features of the dumping version so mov

[ADMIN] pg_dump doesn't save correct the sequences

2004-10-27 Thread Andrei Bintintan
Hi to all,   I try to dump a database from a 7.4.2 postgre system and to import it on a 7.3.2. system, but I have a problem with the sequences in the dump.   This is a seq example:   CREATE SEQUENCE test_id_seq    INCREMENT BY 1    NO MAXVALUE    NO MINVALUE    CACHE 1;   This gives me an