Thread: Error creating a new index with tablespace and fillfacotor
Error creating a new index with tablespace and fillfacotor
From
"Stefan Wolf \(Zielpunkt-Marketing\)"
Date:
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB" style="font-size: 10.0pt;font-family:Arial">Hi, if I try to add a new object – new index on MyTable. Using Fillfactor 100 and Tablespace MyTablespacewill caus an error.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB" style="font-size: 10.0pt;font-family:Arial">The order in the SQL-Text is wrong.</span></font><p class="MsoNormal"><font face="Arial" size="2"><spanlang="EN-GB" style="font-size: 10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB" style="font-size: 10.0pt;font-family:Arial">pgAdmin 1.8.0 on Win32, PostgreSQL 8.2.5 and 8.3.1 Beta</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span lang="EN-GB" style="font-size: 10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB" style="font-size: 10.0pt;font-family:Arial">Regards, Stefan Wolf</span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><spanlang="EN-GB" style="font-size:12.0pt"> </span></font></div>
Stefan Wolf (Zielpunkt-Marketing) wrote: > Hi, if I try to add a new object – new index on MyTable. Using > Fillfactor 100 and Tablespace MyTablespace will caus an error. > > The order in the SQL-Text is wrong. Thanks - fixed in SVN for 1.8.1. Regards, Dave