I have problem with pg_dump in PostgreSQL 7.1.2
От | Попов Андрей |
---|---|
Тема | I have problem with pg_dump in PostgreSQL 7.1.2 |
Дата | |
Msg-id | 000a01c21792$17196700$4000a8c0@ics.technology.lan обсуждение исходный текст |
Ответы |
Re: I have problem with pg_dump in PostgreSQL 7.1.2
(Tom Lane <tgl@sss.pgh.pa.us>)
|
Список | pgsql-bugs |
<div class="Section1"><p class="MsoNormal" style="mso-layout-grid-align:none;text-autospace:none"><font color="black" face="Arial"size="2"><span lang="EN-US" style="font-size:10.0pt; font-family:Arial;color:black;mso-ansi-language:EN-US">Hello.</span></font><p class="MsoNormal" style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Arial" size="2"><span lang="EN-US" style="font-size:10.0pt; font-family:Arial;color:black;mso-ansi-language:EN-US">I am working with PostgreSQL 7.1.2. </span></font><p class="MsoNormal"style="mso-layout-grid-align:none;text-autospace:none"><font color="black" face="Arial" size="2"><span lang="EN-US"style="font-size:10.0pt; font-family:Arial;color:black;mso-ansi-language:EN-US">Earlier I worked with PostgreSQL 6.5.3 and I had no problems.</span></font><fontcolor="black" face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:black"></span></font><pclass="MsoNormal" style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Arial" size="2"><span lang="EN-US" style="font-size:10.0pt; font-family:Arial;color:black;mso-ansi-language:EN-US">How to make, that at pg_dump were taken into account sequence. Ina file dump.txt it is always created sequnece with initial value 1. </span></font><p class="MsoNormal" style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Arial" size="2"><span lang="EN-US" style="font-size:10.0pt; font-family:Arial;color:black;mso-ansi-language:EN-US">Example:</span></font><p class="MsoNormal" style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Arial" size="2"><span lang="EN-US" style="font-size:10.0pt; font-family:Arial;color:black;mso-ansi-language:EN-US">I have table:</span></font><p class="MsoNormal" style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Arial" size="2"><span lang="EN-US" style="font-size:10.0pt; font-family:Arial;color:black;mso-ansi-language:EN-US">Users (id serial primary key, ….).</span></font><p class="MsoNormal"style="mso-layout-grid-align:none;text-autospace:none"><font color="black" face="Arial" size="2"><span lang="EN-US"style="font-size:10.0pt; font-family:Arial;color:black;mso-ansi-language:EN-US">And sequence users_id_seq.</span></font><p class="MsoNormal" style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Arial" size="2"><span lang="EN-US" style="font-size:10.0pt; font-family:Arial;color:black;mso-ansi-language:EN-US">I make: /usr/local/pg-7/bin/pg_dump -u -f /usr/home/andrey/pg/dump.txtdb_name</span></font><p class="MsoNormal" style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Arial" size="2"><span lang="EN-US" style="font-size:10.0pt; font-family:Arial;color:black;mso-ansi-language:EN-US">In file dump.txt creat string:</span></font><p class="MsoNormal" style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Arial" size="2"><span lang="EN-US" style="font-size:10.0pt; font-family:Arial;color:black;mso-ansi-language:EN-US">CREATE SEQUENCE "users_id_seq" start 1 increment 1 maxvalue 2147483647minvalue 1<span style="mso-spacerun:yes"> </span>cache 1 ;</span></font><p class="MsoNormal" style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Arial" size="2"><span lang="EN-US" style="font-size:10.0pt; font-family:Arial;color:black;mso-ansi-language:EN-US">Though should be CREATE SEQUENCE "users_id_seq" start 787 increment1 maxvalue 2147483647 minvalue 1<span style="mso-spacerun:yes"> </span>cache 1 ;</span></font><p class="MsoNormal"style="mso-layout-grid-align:none;text-autospace:none"><font color="black" face="Arial" size="2"><span lang="EN-US"style="font-size:10.0pt; font-family:Arial;color:black;mso-ansi-language:EN-US">As users_id_seq.</span></font><span lang="EN-US" style="mso-ansi-language:EN-US"></span><font color="black" face="Arial" size="2"><span lang="EN-US" style="font-size:10.0pt;font-family:Arial; color:black;mso-ansi-language:EN-US">last_value = 787.</span></font><p class="MsoNormal" style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Arial" size="2"><span lang="EN-US" style="font-size:10.0pt; font-family:Arial;color:black;mso-ansi-language:EN-US"> </span></font><p class="MsoNormal" style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Arial" size="2"><span lang="EN-US" style="font-size:10.0pt; font-family:Arial;color:black;mso-ansi-language:EN-US">The version 6.5.3 worked correctly.</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span lang="EN-US" style="font-size: 10.0pt;font-family:Arial;mso-ansi-language:EN-US"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US"style="font-size: 10.0pt;font-family:Arial;mso-ansi-language:EN-US">Best regards, Popov Andrey.</span></font><p class="MsoNormal"><font face="Arial"size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font></div>
В списке pgsql-bugs по дате отправления: