Re: Error when trying to add DEFAULT Value to NEW column - Mailing list pgadmin-support

<div class="Section1"><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size:
10.0pt;font-family:Arial;color:navy">Ok, This was me. When I looked at the SQL statement to trace problem, I
(sheepishly)used the wrong quotes !</span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:navy"> Can the single quotes be added automatically if they are not
supplied?</span></font><pclass="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 
10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal" style="margin-left:36.0pt"><font face="Tahoma"
size="2"><spanstyle="font-size:10.0pt;font-family:Tahoma">-----Original Message-----<br /><b><span
style="font-weight:bold">From:</span></b>pgadmin-support-owner@postgresql.org
[mailto:pgadmin-support-owner@postgresql.org]<b><span style="font-weight:bold">On Behalf Of </span></b>Leon du
Plessis<br/><b><span style="font-weight:bold">Sent:</span></b> </span></font><font face="Tahoma" size="2"><span
style="font-size:10.0pt;font-family:Tahoma">02February 2006</span></font><font face="Tahoma" size="2"><span
style="font-size:10.0pt;
font-family:Tahoma"> </span></font><font face="Tahoma" size="2"><span style="font-size:10.0pt;font-family:Tahoma">03:38
PM</span></font><fontface="Tahoma" size="2"><span style="font-size:10.0pt;font-family:Tahoma"><br /><b><span
style="font-weight:bold">To:</span></b>pgadmin-support@postgresql.org<br /><b><span
style="font-weight:bold">Subject:</span></b>[pgadmin-support] Error when trying to add DEFAULT Value to NEW
column</span></font><pclass="MsoNormal" style="margin-left:36.0pt"><font face="Times New Roman" size="3"><span
style="font-size:12.0pt"> </span></font><pclass="MsoPlainText" style="margin-left:36.0pt"><font face="Courier New"
size="2"><spanlang="EN-GB" style="font-size:10.0pt">Hi, </span></font><p class="MsoPlainText"
style="margin-left:36.0pt"><fontcolor="black" face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;color:black"> </span></font><pclass="MsoPlainText" style="margin-left:36.0pt"><font
color="black"face="Courier New" 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" style="margin-left:36.0pt"><font
color="black"face="Courier New" size="2"><span lang="EN-GB" style="font-size:10.0pt;color:black"> </span></font><p
class="MsoPlainText"style="margin-left:36.0pt"><font color="black" face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;color:black">Receivingan error “Column ‘no’ does not exist” when trying to add a default value
toa <u>new</u> column via properties panel. </span></font><p class="MsoPlainText" style="margin-left:36.0pt"><font
color="black"face="Courier New" size="2"><span lang="EN-GB" style="font-size:10.0pt;color:black"> </span></font><p
class="MsoPlainText"style="margin-left:36.0pt"><font color="black" face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;color:black">Whenyou create the new column without a default value, it’s fine. The default
valuecan then be added afterwards. </span></font><p class="MsoPlainText" style="margin-left:36.0pt"><font color="black"
face="CourierNew" size="2"><span lang="EN-GB" style="font-size:10.0pt;color:black"> </span></font><p
class="MsoPlainText"style="margin-left:36.0pt"><font color="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"
style="margin-left:36.0pt"><fontcolor="black" face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;color:black"> </span></font><pclass="MsoPlainText" style="margin-left:36.0pt"><font
color="black"face="Courier New" size="2"><span lang="EN-GB" style="font-size:10.0pt;color:black">The error indicates
thecolumn “no” does not exist, but I am trying to add straight text to the default value. Can’t see why that field is
tryingto link/check columns. I have tried quotes.</span></font><p class="MsoPlainText" style="margin-left:36.0pt"><font
color="black"face="Courier New" size="2"><span lang="EN-GB" style="font-size:10.0pt;color:black"> </span></font><p
class="MsoPlainText"style="margin-left:36.0pt"><font color="black" face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;color:black">UsingVersion 8.1 on Windows XP SP2 and pgadmin 1.4.1.</span></font><p
class="MsoPlainText"style="margin-left:36.0pt"><font color="black" face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;color:black"> </span></font><pclass="MsoPlainText" style="margin-left:36.0pt"><font
color="black"face="Courier New" size="2"><span lang="EN-GB" style="font-size:10.0pt;color:black">Thank you,
kindly</span></font><pclass="MsoPlainText" style="margin-left:36.0pt"><font color="black" face="Courier New"
size="2"><spanlang="EN-GB" style="font-size:10.0pt;color:black">L.</span></font><p class="MsoPlainText"
style="margin-left:36.0pt"><fontcolor="black" face="Courier New" size="2"><span lang="EN-GB"
style="font-size:10.0pt;color:black"> </span></font><pclass="MsoPlainText" style="margin-left:36.0pt"><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@01C62818.8AE09CE0"width="209" /></span></font></div><br /><p><font size="2">--<br /> No virus
foundin this incoming message.<br /> Checked by AVG Free Edition.<br /> Version: 7.1.375 / Virus Database:
267.14.23/243- Release Date: 2006/01/27<br /></font><p><font face="Arial" size="2"> </font>