I have problem with pg_dump in PostgreSQL 7.1.2

From: Попов Андрей <andrey(at)cursor(dot)ru>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: I have problem with pg_dump in PostgreSQL 7.1.2
Date: 2002-06-19 13:06:13
Message-ID: 000a01c21792$17196700$4000a8c0@ics.technology.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello.
I am working with PostgreSQL 7.1.2.
Earlier I worked with PostgreSQL 6.5.3 and I had no problems.
How to make, that at pg_dump were taken into account sequence. In a file
dump.txt it is always created sequnece with initial value 1.
Example:
I have table:
Users (id serial primary key, :.).
And sequence users_id_seq.
I make: /usr/local/pg-7/bin/pg_dump -u -f /usr/home/andrey/pg/dump.txt
db_name
In file dump.txt creat string:
CREATE SEQUENCE "users_id_seq" start 1 increment 1 maxvalue 2147483647
minvalue 1 cache 1 ;
Though should be CREATE SEQUENCE "users_id_seq" start 787 increment 1
maxvalue 2147483647 minvalue 1 cache 1 ;
As users_id_seq. last_value = 787.

The version 6.5.3 worked correctly.

Best regards, Popov Andrey.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David M. Kaplan 2002-06-19 21:01:16 regex (not) matching null string
Previous Message Reinhard Max 2002-06-18 16:51:57 Re: pg_hba.conf confusion