Error when trying to add DEFAULT Value to NEW column

Поиск
Список
Период
Сортировка
От Leon du Plessis
Тема Error when trying to add DEFAULT Value to NEW column
Дата
Msg-id 000001c627fd$eafc24c0$5a3ca8c0@centauri1
обсуждение исходный текст
Ответ на running pg_dump via pgAgent  ("Che" <menge00@myway.com>)
Ответы Re: Error when trying to add DEFAULT Value to NEW column  ("Leon du Plessis" <leon@designit.za.com>)
Список pgadmin-support
<div class="Section1"><p class="MsoPlainText"><font face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt">Hi,</span></font><p class="MsoPlainText"><font color="black" face="Courier New" size="2"><span
lang="EN-GB"style="font-size:10.0pt;color:black"> </span></font><p class="MsoPlainText"><font color="black"
face="CourierNew" size="2"><span lang="EN-GB" style="font-size:10.0pt;color:black">If this is a known issue, please
ignore…just direct me to the fix:</span></font><p class="MsoPlainText"><font color="black" face="Courier New"
size="2"><spanlang="EN-GB" style="font-size:10.0pt;color:black"> </span></font><p class="MsoPlainText"><font
color="black"face="Courier New" size="2"><span lang="EN-GB" style="font-size:10.0pt;color:black">Receiving an error
“Column‘no’ does not exist” when trying to add a default value to a <u>new</u> column via properties panel.
</span></font><pclass="MsoPlainText"><font color="black" face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;color:black"> </span></font><pclass="MsoPlainText"><font color="black" face="Courier New"
size="2"><spanlang="EN-GB" style="font-size:10.0pt;color:black">When you create the new column without a default value,
it’sfine. The default value can then be added afterwards. </span></font><p class="MsoPlainText"><font color="black"
face="CourierNew" size="2"><span lang="EN-GB" style="font-size:10.0pt;color:black"> </span></font><p
class="MsoPlainText"><fontcolor="black" face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;color:black">Alsosubsequent deletion and re-creation of the column does not produce the same
conditionand the default value can then be added with no further problems. </span></font><p class="MsoPlainText"><font
color="black"face="Courier New" size="2"><span lang="EN-GB" style="font-size:10.0pt;color:black"> </span></font><p
class="MsoPlainText"><fontcolor="black" face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;color:black">Theerror indicates the column “no” does not exist, but I am trying to add straight
textto the default value. Can’t see why that field is trying to link/check columns. I have tried
quotes.</span></font><pclass="MsoPlainText"><font color="black" face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;color:black"> </span></font><pclass="MsoPlainText"><font color="black" face="Courier New"
size="2"><spanlang="EN-GB" style="font-size:10.0pt;color:black">Using Version 8.1 on Windows XP SP2 and pgadmin
1.4.1.</span></font><pclass="MsoPlainText"><font color="black" face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;color:black"> </span></font><pclass="MsoPlainText"><font color="black" face="Courier New"
size="2"><spanlang="EN-GB" style="font-size:10.0pt;color:black">Thank you, kindly</span></font><p
class="MsoPlainText"><fontcolor="black" face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;color:black">L.</span></font><pclass="MsoPlainText"><font color="black" face="Courier New"
size="2"><spanlang="EN-GB" style="font-size:10.0pt;color:black"> </span></font><p class="MsoPlainText"><font
color="black"face="Courier New" size="2"><span lang="EN-GB" style="font-size:10.0pt;color:black"><img height="120"
src="cid:image001.jpg@01C6280E.ADB08DC0"width="209" /></span></font></div> 

В списке pgadmin-support по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: [pgadmin-hackers] "view data" freezes up every time
Следующее
От: "Leon du Plessis"
Дата:
Сообщение: Re: Error when trying to add DEFAULT Value to NEW column