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 по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: WHERE =NULL malfunction in release 7.2
Следующее
От: "David M. Kaplan"
Дата:
Сообщение: regex (not) matching null string