Re: question about meaning of character varying without length - Mailing list pgsql-hackers

Here you go:<br /><table cellpadding="0" class="cf gJ"><tbody><tr><td class="gF gK"><table cellpadding="0" class="cf
gJ"><tbody><trclass="UszGxc"><td class="gG"><span class="gI">from</span></td><td class="gL" colspan="2"><span
class="gI"><spanclass="ik"><img class="QrVm3d" height="16" id="upi" name="upi" src="images/cleardot.gif" width="16"
/></span><spanclass="gD" style="color: rgb(121, 6, 25);">Mail Delivery Subsystem</span> <span class="go"><<a
href="mailto:mailer-daemon@googlemail.com">mailer-daemon@googlemail.com</a>></span></span></td></tr><tr><td
class="gG"colspan="2"><span class="gI">to</span></td><td class="gL" colspan="2"><span class="gI"><span class="ik"><img
class="c6QrVm3d" height="16" id="upi" name="upi" src="images/cleardot.gif" width="16" /></span><a
href="mailto:pgfizm@gmail.com">pgfizm@gmail.com</a><br/></span></td></tr><tr><td class="gG" colspan="2"><span
class="gI">date</span></td><tdclass="gL" colspan="2"><span class="gI"><span class="ik"><img height="16"
src="images/cleardot.gif"width="16" /></span>Mon, Jun 15, 2009 at 9:16 PM</span></td></tr><tr><td class="gG"
colspan="2"><spanclass="gI">subject</span></td><td class="gL" colspan="2"><span class="gI"><span class="ik"><img
height="16"src="images/cleardot.gif" width="16" /></span>Delivery Status Notification (Failure)</span></td></tr><tr><td
colspan="4"><spanclass="gI"></span><br /></td></tr></tbody></table></td><td class="gH"><div class="gK UszGxc"><span
class="iD">hidedetails</span> <span alt="Mon, Jun 15, 2009 at 9:16 PM" class="g3" id=":3w" title="Mon, Jun 15, 2009 at
9:16PM">9:16 PM (31 minutes ago)</span> <span></span></div></td><td class="gH cY8xve"><div class="h2"><table
cellpadding="0"class="cf h3" id=":2n"><tbody><tr><td class="cTzXV hC hy"><img alt="" class="hB"
src="images/cleardot.gif"/></td><td class="cTzXV hy"><div class="hE">Reply</div></td><td class="hy"><br /></td><td
class="tKFvYbhz hy" tabindex="0"><img alt="Follow up message" class="hA" src="images/cleardot.gif"
/></td></tr></tbody></table></div></td></tr></tbody></table>Thisis an automatically generated Delivery Status
Notification<br/><br /> Delivery to the following recipient failed permanently:<br /><br />     <a
href="mailto:pgsql-general@postgresql.com">pgsql-general@postgresql.com</a><br/><br /> Technical details of permanent
failure:<br/> Google tried to deliver your message, but it was rejected by the recipient domain. We recommend
contactingthe other email provider for further information about the cause of this error. The error that the other
serverreturned was: 554 554 5.7.1 <<a
href="mailto:pgsql-general@postgresql.com">pgsql-general@postgresql.com</a>><divclass="ii gt" id=":1o">: Relay
accessdenied (state 14).<br /><br />   ----- Original message -----<br /><br /> MIME-Version: 1.0<br /> Received: by
10.142.237.19with SMTP id k19mr3677653wfh.31.1245125814649; Mon,<br />        15 Jun 2009 21:16:54 -0700 (PDT)<br />
Date:Mon, 15 Jun 2009 21:16:54 -0700<br /> Message-ID: <<a
href="mailto:72746b5e0906152116t13e67918l3eb58b5c304fdc82@mail.gmail.com">72746b5e0906152116t13e67918l3eb58b5c304fdc82@mail.gmail.com</a>><br
/>Subject: question about meaning of character varying without length<br /> From: Konstantin Izmailov <<a
href="mailto:pgfizm@gmail.com">pgfizm@gmail.com</a>><br/> To: <a
href="mailto:pgsql-general@postgresql.com">pgsql-general@postgresql.com</a><br/> Content-Type: multipart/alternative;
boundary=000e0cd24232e205f2046c6f7190<br/><br /> --000e0cd24232e205f2046c6f7190<br /> Content-Type: text/plain;
charset=ISO-8859-1<br/> Content-Transfer-Encoding: 7bit<br /><div class="im"><br /> Hello,<br /> I've found following
description:"If character varying is used without<br /> length specifier, the type accepts strings of any size. The
latteris a<br /> PostgreSQL extension."<br /><br /> Does this mean that "character varying without length" is
equivalentto<br /><br /></div>   ----- Message truncated -----</div><br /><br /><br /><br /><div class="gmail_quote">On
Mon,Jun 15, 2009 at 9:47 PM, Robert Haas <span dir="ltr"><<a
href="mailto:robertmhaas@gmail.com">robertmhaas@gmail.com</a>></span>wrote:<br /><blockquote class="gmail_quote"
style="border-left:1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="im">On Tue,
Jun16, 2009 at 12:45 AM, Konstantin Izmailov<<a href="mailto:pgfizm@gmail.com">pgfizm@gmail.com</a>> wrote:<br />
>I have tried to send to pgsql-general twice, each time it returns error:<br /> > "Relay access denied (state
14)."Will try to post to pgsql-odbc.<br /><br /></div>Could you provide the full bounce message?<br /><font
color="#888888"><br/> ...Robert<br /></font></blockquote></div><br />