Обсуждение: I have problem with pg_dump in PostgreSQL 7.1.2
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.
Попов Андрей <andrey@cursor.ru> writes:
> 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.
There will be a setval() call in there too, someplace.
regards, tom lane