Error when trying to add DEFAULT Value to NEW column - Mailing list pgadmin-support
| From | Leon du Plessis |
|---|---|
| Subject | Error when trying to add DEFAULT Value to NEW column |
| Date | |
| Msg-id | 000001c627fd$eafc24c0$5a3ca8c0@centauri1 Whole thread Raw |
| In response to | running pg_dump via pgAgent ("Che" <menge00@myway.com>) |
| Responses |
Re: Error when trying to add DEFAULT Value to NEW column
("Leon du Plessis" <leon@designit.za.com>)
|
| List | 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 by date: