Re: question about meaning of character varying without length

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

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

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.

Thank you!

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

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

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
>

Konstantin Izmailov wrote:
> Here you go:
> from Mail Delivery Subsystem <mailer-daemon(at)googlemail(dot)com
> <mailto:mailer-daemon(at)googlemail(dot)com>>
> to pgfizm(at)gmail(dot)com <mailto:pgfizm(at)gmail(dot)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(at)postgresql(dot)com <mailto:pgsql-general(at)postgresql(dot)com>

postgresql.com != postgresql.org...

Stefan

Konstantin Izmailov wrote:
>
>
> Delivery to the following recipient failed permanently:
>
> pgsql-general(at)postgresql(dot)com <mailto:pgsql-general(at)postgresql(dot)com>
>
>

should be pgsql-general(at)postgresql(dot)org, not pgsql-general(at)postgresql(dot)com(dot)

cheers

andrew