RE : RE : Problem with inserting data in table through pgAdmin - Mailing list pgadmin-support

<div class="Section1"><p class="MsoNormal"><font color="blue" face="Century Gothic" size="2"><span lang="EN-GB"
style="font-size:11.0pt;color:blue">Hello,</span></font><pclass="MsoNormal"><font color="blue" face="Century Gothic"
size="2"><spanlang="EN-GB" style="font-size:11.0pt;color:blue"> </span></font><p class="MsoNormal"><font color="blue"
face="CenturyGothic" size="2"><span lang="EN-GB" style="font-size:11.0pt;color:blue">Sorry for the late answer… I was
awaya few days and saw your post only now.</span></font><p class="MsoNormal"><font color="blue" face="Century Gothic"
size="2"><spanlang="EN-GB" style="font-size:11.0pt;color:blue"> </span></font><p class="MsoNormal"><font color="blue"
face="CenturyGothic" size="2"><span lang="EN-GB" style="font-size:11.0pt;color:blue">Sorry no… It doesn’t
work.</span></font><pclass="MsoNormal"><font color="blue" face="Century Gothic" size="2"><span lang="EN-GB"
style="font-size:11.0pt;color:blue"> </span></font><pclass="MsoNormal"><font color="blue" face="Century Gothic"
size="2"><spanlang="EN-GB" style="font-size:11.0pt;color:blue">I downloaded and installed the last available
snapshot.</span></font><pclass="MsoNormal"><font color="blue" face="Century Gothic" size="2"><span lang="EN-GB"
style="font-size:11.0pt;color:blue">Actuallymy pgadmin identifies itself as Version 1.3.0 (19 sept 2005) but I still
havethe same bug.</span></font><p class="MsoNormal"><font color="blue" face="Century Gothic" size="2"><span
lang="EN-GB"style="font-size:11.0pt;color:blue"> </span></font><p class="MsoNormal"><font color="blue" face="Century
Gothic"size="2"><span lang="EN-GB" style="font-size:11.0pt;color:blue">Anyway… Thanks for your help</span></font><p
class="MsoNormal"><fontcolor="blue" face="Century Gothic" size="2"><span lang="EN-GB"
style="font-size:11.0pt;color:blue"> </span></font><pclass="MsoNormal"><font color="blue" face="Century Gothic"
size="2"><spanlang="EN-GB" style="font-size:11.0pt;color:blue">Umar</span></font><p class="MsoNormal"><font
color="blue"face="Century Gothic" size="2"><span lang="EN-GB" style="font-size:11.0pt;color:blue"> </span></font><p
class="MsoNormal"><fontcolor="blue" face="Century Gothic" size="2"><span lang="EN-GB"
style="font-size:11.0pt;color:blue"> </span></font><blockquotestyle="border:none;border-left:solid blue
1.5pt;padding:0cm0cm 0cm 4.0pt; 
margin-left:3.75pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt"><p class="MsoNormal"
style="margin-left:35.4pt"><fontface="Century Gothic" size="2"><span style="font-size:11.0pt">Hello,</span></font><p
class="MsoNormal"style="margin-left:35.4pt"><font face="Century Gothic" size="2"><span
style="font-size:11.0pt"> </span></font><pclass="MsoNormal" style="margin-left:35.4pt"><font face="Century Gothic"
size="2"><spanlang="EN-GB" style="font-size:11.0pt">I have found something that looks like a bug.</span></font><p
class="MsoNormal"style="margin-left:35.4pt"><font face="Century Gothic" size="2"><span lang="EN-GB"
style="font-size:11.0pt">Ichecked the FAQ and the PG admin website but didn’t find any information about
it.</span></font><pclass="MsoNormal" style="margin-left:35.4pt"><font face="Century Gothic" size="2"><span lang="EN-GB"
style="font-size:11.0pt">Ialso installed the last available version (1.2.2)</span></font><p class="MsoNormal"
style="margin-left:35.4pt"><fontface="Century Gothic" size="2"><span style="font-size:11.0pt"> </span></font><p
class="MsoNormal"style="margin-left:35.4pt"><font face="Century Gothic" size="2"><span lang="EN-GB"
style="font-size:11.0pt">Mysystem:</span></font><p class="MsoNormal" style="margin-left:35.4pt"><font face="Century
Gothic"size="2"><span style="font-size:11.0pt"> </span></font><p class="MsoNormal"
style="margin-left:88.65pt;text-indent:-18.0pt"><fontface="Century Gothic" size="2"><span lang="EN-GB"
style="font-size:11.0pt">-</span></font><fontface="Times New Roman" size="1"><span lang="EN-GB" style="font-size:7.0pt; 
font-family:"Times New Roman"">          </span></font><span lang="EN-GB">Win 2000 SP4 in French + Service
rollout</span><pclass="MsoNormal" style="margin-left:88.65pt;text-indent:-18.0pt"><font face="Century Gothic"
size="2"><spanlang="EN-GB" style="font-size:11.0pt">-</span></font><font face="Times New Roman" size="1"><span
lang="EN-GB"style="font-size:7.0pt; 
font-family:"Times New Roman"">          </span></font><span lang="EN-GB">All patches</span><p class="MsoNormal"
style="margin-left:88.65pt;text-indent:-18.0pt"><fontface="Century Gothic" size="2"><span lang="EN-GB"
style="font-size:11.0pt">-</span></font><fontface="Times New Roman" size="1"><span lang="EN-GB" style="font-size:7.0pt; 
font-family:"Times New Roman"">          </span></font><span lang="EN-GB">Postgres 8.0.3</span><p class="MsoNormal"
style="margin-left:88.65pt;text-indent:-18.0pt"><fontface="Century Gothic" size="2"><span lang="EN-GB"
style="font-size:11.0pt">-</span></font><fontface="Times New Roman" size="1"><span lang="EN-GB" style="font-size:7.0pt; 
font-family:"Times New Roman"">          </span></font><span lang="EN-GB">PGAdmin 1.2.2</span><p class="MsoNormal"
style="margin-left:35.4pt"><fontface="Century Gothic" size="2"><span style="font-size:11.0pt"> </span></font><p
class="MsoNormal"style="margin-left:35.4pt"><font face="Century Gothic" size="2"><span lang="EN-GB"
style="font-size:11.0pt">Myproblem:</span></font><p class="MsoNormal" style="margin-left:35.4pt"><font face="Century
Gothic"size="2"><span style="font-size:11.0pt"> </span></font><p class="MsoNormal" style="margin-left:35.4pt"><font
face="CenturyGothic" size="2"><span lang="EN-GB" style="font-size:11.0pt">I can’t add data in a table of a test
databaseI created through the PGAdmin interface. If I do that I receive a Windows message that tells
me:</span></font><pclass="MsoNormal" style="margin-left:35.4pt"><font face="Century Gothic" size="2"><span
style="font-size:11.0pt"> </span></font><pclass="MsoNormal" style="margin-left:35.4pt"><font face="Century Gothic"
size="2"><spanstyle="font-size:11.0pt">« pgAdmin3.exe a généré des erreurs et sera fermé par Windows. »</span></font><p
class="MsoNormal"style="margin-left:35.4pt"><font face="Century Gothic" size="2"><span
style="font-size:11.0pt"> </span></font><pclass="MsoNormal" style="margin-left:35.4pt"><font face="Century Gothic"
size="2"><spanlang="EN-GB" style="font-size:11.0pt">That means in English : “pgAdmin3.exe has caused an error and will
beclosed by Windows.”</span></font><p class="MsoNormal" style="margin-left:35.4pt"><font face="Century Gothic"
size="2"><spanstyle="font-size:11.0pt"> </span></font><p class="MsoNormal" style="margin-left:35.4pt"><font
face="CenturyGothic" size="2"><span lang="EN-GB" style="font-size:11.0pt">The exact description on how I caused the
error.</span></font><pclass="MsoNormal" style="margin-left:35.4pt"><font face="Century Gothic" size="2"><span
style="font-size:11.0pt"> </span></font><pclass="MsoNormal" style="margin-left:88.65pt;text-indent:-18.0pt"><font
face="CenturyGothic" size="2"><span lang="EN-GB" style="font-size:11.0pt">-</span></font><font face="Times New Roman"
size="1"><spanlang="EN-GB" style="font-size:7.0pt; 
font-family:"Times New Roman"">          </span></font><span lang="EN-GB">Standard download and install of the last
versionof PG 8.0.3 and pgAdmin 1.2.2</span><p class="MsoNormal" style="margin-left:88.65pt;text-indent:-18.0pt"><font
face="CenturyGothic" size="2"><span lang="EN-GB" style="font-size:11.0pt">-</span></font><font face="Times New Roman"
size="1"><spanlang="EN-GB" style="font-size:7.0pt; 
font-family:"Times New Roman"">          </span></font><span lang="EN-GB">Opening pgAdmin and using it for:</span><p
class="MsoNormal"style="margin-left:124.65pt;text-indent:-18.0pt"><font face="Courier New" size="2"><span lang="EN-GB"
style="font-size:11.0pt;font-family:
"Courier New"">o</span></font><font face="Times New Roman" size="1"><span lang="EN-GB"
style="font-size:7.0pt;font-family:"TimesNew Roman"">        </span></font><span lang="EN-GB">Creation of the database
“TEST”</span><pclass="MsoNormal" style="margin-left:124.65pt;text-indent:-18.0pt"><font face="Courier New"
size="2"><spanlang="EN-GB" style="font-size:11.0pt;font-family: 
"Courier New"">o</span></font><font face="Times New Roman" size="1"><span lang="EN-GB"
style="font-size:7.0pt;font-family:"TimesNew Roman"">        </span></font><span lang="EN-GB">Creation of the table
“BOOKS”</span><pclass="MsoNormal" style="margin-left:124.65pt;text-indent:-18.0pt"><font face="Courier New"
size="2"><spanlang="EN-GB" style="font-size:11.0pt;font-family: 
"Courier New"">o</span></font><font face="Times New Roman" size="1"><span lang="EN-GB"
style="font-size:7.0pt;font-family:"TimesNew Roman"">        </span></font><span lang="EN-GB">Creation of the column
“BOOK_ID”(int8)</span><p class="MsoNormal" style="margin-left:124.65pt;text-indent:-18.0pt"><font face="Courier New"
size="2"><spanlang="EN-GB" style="font-size:11.0pt;font-family: 
"Courier New"">o</span></font><font face="Times New Roman" size="1"><span lang="EN-GB"
style="font-size:7.0pt;font-family:"TimesNew Roman"">        </span></font><span lang="EN-GB">Creation of the column
“BOOK_TITLE”(text)</span><p class="MsoNormal" style="margin-left:124.65pt;text-indent:-18.0pt"><font face="Courier New"
size="2"><spanlang="EN-GB" style="font-size:11.0pt;font-family: 
"Courier New"">o</span></font><font face="Times New Roman" size="1"><span lang="EN-GB"
style="font-size:7.0pt;font-family:"TimesNew Roman"">        </span></font><span lang="EN-GB">Configuration of the
column“BOOK_ID” as primary key</span><p class="MsoNormal" style="margin-left:124.65pt;text-indent:-18.0pt"><font
face="CourierNew" size="2"><span lang="EN-GB" style="font-size:11.0pt;font-family: 
"Courier New"">o</span></font><font face="Times New Roman" size="1"><span lang="EN-GB"
style="font-size:7.0pt;font-family:"TimesNew Roman"">        </span></font><span lang="EN-GB">Going to “Servers” -->
“PostgreSQLDatabase Server 8.0” --> “Databases” --> “test” --> “Schemas” --> “Public” --> “Tables”
-->“BOOKS”</span><p class="MsoNormal" style="margin-left:124.65pt;text-indent:-18.0pt"><font face="Courier New"
size="2"><spanlang="EN-GB" style="font-size:11.0pt;font-family: 
"Courier New"">o</span></font><font face="Times New Roman" size="1"><span lang="EN-GB"
style="font-size:7.0pt;font-family:"TimesNew Roman"">        </span></font><span lang="EN-GB">Right-clicking on “BOOKS”
andselecting “view data”</span><p class="MsoNormal" style="margin-left:124.65pt;text-indent:-18.0pt"><font
face="CourierNew" size="2"><span lang="EN-GB" style="font-size:11.0pt;font-family: 
"Courier New"">o</span></font><font face="Times New Roman" size="1"><span lang="EN-GB"
style="font-size:7.0pt;font-family:"TimesNew Roman"">        </span></font><span lang="EN-GB">Typing a title in
“BOOK_TITLE”and a unique number in “BOOK_ID”</span><p class="MsoNormal"
style="margin-left:124.65pt;text-indent:-18.0pt"><fontface="Courier New" size="2"><span lang="EN-GB"
style="font-size:11.0pt;font-family:
"Courier New"">o</span></font><font face="Times New Roman" size="1"><span lang="EN-GB"
style="font-size:7.0pt;font-family:"TimesNew Roman"">        </span></font><span lang="EN-GB">Pressing enter</span><p
class="MsoNormal"style="margin-left:124.65pt;text-indent:-18.0pt"><font face="Courier New" size="2"><span lang="EN-GB"
style="font-size:11.0pt;font-family:
"Courier New"">o</span></font><font face="Times New Roman" size="1"><span lang="EN-GB"
style="font-size:7.0pt;font-family:"TimesNew Roman"">        </span></font><span lang="EN-GB">CRASH</span><p
class="MsoNormal"style="margin-left:35.4pt"><font face="Century Gothic" size="2"><span
style="font-size:11.0pt"> </span></font><pclass="MsoNormal" style="margin-left:35.4pt"><font face="Century Gothic"
size="2"><spanlang="EN-GB" style="font-size:11.0pt">This error is systematic and happens each time I try to add data
thisway.</span></font><p class="MsoNormal" style="margin-left:35.4pt"><font face="Century Gothic" size="2"><span
style="font-size:11.0pt"> </span></font></blockquote><pclass="MsoNormal" style="margin-left:35.4pt"><font color="blue"
face="Arial"size="2"><span style="font-size:10.0pt;font-family:Arial;color:blue">Hello,</span></font><p
class="MsoNormal"style="margin-left:35.4pt"><font face="Century Gothic" size="2"><span
style="font-size:11.0pt"> </span></font><pclass="MsoNormal" style="margin-left:35.4pt"><font color="blue" face="Arial"
size="2"><spanstyle="font-size:10.0pt;font-family:Arial;color:blue">Can you test the latest snapshot from <a
href="http://developer.pgadmin.org/">http://developer.pgadmin.org/</a>and let us know if you see the problem with that
versionas well please?</span></font><p class="MsoNormal" style="margin-left:35.4pt"><font face="Century Gothic"
size="2"><spanstyle="font-size:11.0pt"> </span></font><p class="MsoNormal" style="margin-left:35.4pt"><font
color="blue"face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:blue">Regards,
Dave</span></font></div>