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

From Konstantin Izmailov
Subject Re: question about meaning of character varying without length
Date
Msg-id 72746b5e0906152150r1fa9524clb98422edc8dbf75@mail.gmail.com
Whole thread Raw
In response to Re: question about meaning of character varying without length  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: question about meaning of character varying without length
Re: question about meaning of character varying without length
List pgsql-hackers
Here you go:
fromMail Delivery Subsystem <mailer-daemon@googlemail.com>
topgfizm@gmail.com
dateMon, Jun 15, 2009 at 9:16 PM
subjectDelivery 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

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@postgresql.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@mail.gmail.com>
Subject: question about meaning of character varying without length
From: Konstantin Izmailov <pgfizm@gmail.com>
To: pgsql-general@postgresql.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@gmail.com> wrote:
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

pgsql-hackers by date:

Previous
From: Kedar Potdar
Date:
Subject: Re: Patch for automating partitions in PostgreSQL 8.4 Beta 2
Next
From: Robert Haas
Date:
Subject: Re: change do_tup_output to take Datum arguments rather than cstring