Thread: question about meaning of character varying without length

Hello,<br />I've found following description: "If character varying is used without length specifier, the type accepts
stringsof any size. The latter is a PostgreSQL extension."<br /><br />Does this mean that "character varying without
length"is equivalent to "text" type. Are there any differences?<br /><br />I noticed that ODBC driver processes the
typedifferently from "text".<br /><br />Please help!<br />Konstantin<br /><br /><br /> 

On Tue, Jun 16, 2009 at 12:24 AM, Konstantin Izmailov<pgfizm@gmail.com> wrote:
> Hello,
> I've found following description: "If character varying is used without
> length specifier, the type accepts strings of any size. The latter is a
> PostgreSQL extension."
>
> Does this mean that "character varying without length" is equivalent to
> "text" type. Are there any differences?
>
> I noticed that ODBC driver processes the type differently from "text".
>
> Please help!
> Konstantin

This question would be more appropriate for pgsql-general or maybe
pgsql-odbc, since it is not a question about the development of
PostgreSQL.

character varying and text are different types, but there's no real
difference between them.  I can't speak to what the ODBC driver does.

...Robert

On Tue, Jun 16, 2009 at 12:45 AM, Konstantin Izmailov<pgfizm@gmail.com> wrote:
> I have tried to send to pgsql-general twice, each time it returns error:
> "Relay access denied (state 14)." Will try to post to pgsql-odbc.

Could you provide the full bounce message?

...Robert

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 /> 

Konstantin Izmailov wrote:
> Here you go:
> from    Mail Delivery Subsystem <mailer-daemon@googlemail.com 
> <mailto:mailer-daemon@googlemail.com>>
> to    pgfizm@gmail.com <mailto:pgfizm@gmail.com>
> date    Mon, Jun 15, 2009 at 9:16 PM
> subject    Delivery Status Notification (Failure)
> 
>     
> hide details 9:16 PM (31 minutes ago)
>     
>     
> Reply
>     
>     Follow up message
> 
> This is an automatically generated Delivery Status Notification
> 
> Delivery to the following recipient failed permanently:
> 
>     pgsql-general@postgresql.com <mailto:pgsql-general@postgresql.com>

postgresql.com != postgresql.org...


Stefan

Konstantin Izmailov wrote:
>
>
> Delivery to the following recipient failed permanently:
>
>     pgsql-general@postgresql.com <mailto:pgsql-general@postgresql.com>
>
>

should be pgsql-general@postgresql.org, not pgsql-general@postgresql.com.

cheers

andrew