Re: question about meaning of character varying without length

Here you go:
fromMail Delivery Subsystem <mailer-daemon(at)googlemail(dot)com>topgfizm(at)gmail(dot)com
dateMon, Jun 15, 2009 at 9:16 PMsubjectDelivery Status Notification
(Failure)
hide details 9:16 PM (31 minutes ago)
Reply

[image: Follow up message]
This is an automatically generated Delivery Status Notification

Delivery to the following recipient failed permanently:

pgsql-general(at)postgresql(dot)com

Technical details of permanent failure:
Google tried to deliver your message, but it was rejected by the recipient
domain. We recommend contacting the other email provider for further
information about the cause of this error. The error that the other server
returned was: 554 554 5.7.1 <pgsql-general(at)postgresql(dot)com>: Relay access
denied (state 14).

----- Original message -----

MIME-Version: 1.0
Received: by 10.142.237.19 with SMTP id k19mr3677653wfh.31.1245125814649;
Mon,
15 Jun 2009 21:16:54 -0700 (PDT)
Date: Mon, 15 Jun 2009 21:16:54 -0700
Message-ID: <72746b5e0906152116t13e67918l3eb58b5c304fdc82(at)mail(dot)gmail(dot)com>
Subject: question about meaning of character varying without length
From: Konstantin Izmailov <pgfizm(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)com
Content-Type: multipart/alternative; boundary=000e0cd24232e205f2046c6f7190

--000e0cd24232e205f2046c6f7190
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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

----- Message truncated -----

On Mon, Jun 15, 2009 at 9:47 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:

> On Tue, Jun 16, 2009 at 12:45 AM, Konstantin Izmailov<pgfizm(at)gmail(dot)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
>