Skip site navigation (1) Skip section navigation (2)

Field with character varying (255)

From: "Christopher A(dot) Goodfellow" <cgoodfellow(at)tealuxe(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Field with character varying (255)
Date: 2004-04-26 16:48:43
Message-ID: 004901c42bae$561d9660$ (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
I have a table with a field set to character varying (255).  When an insert
is executed with a value for this field greater than 255 characters, an
error is generated rather than the input being truncated as stated in the
postgresql docs.

  Postgresql version 7.3.2.

  This problem did not occur in postgresql version 6.5 and the values were

Output from \d of the filed in question below....

  Column     |        Type                   |                Modifiers
questions    | character varying(255) |

Thank You,
Christopher A. Goodfellow
Director of Information Technology
Tealuxe, Inc.
Phone: 508 520 7887 ex:22
Fax: 508 528 8999
tea for all


pgsql-novice by date

Next:From: Joe ConwayDate: 2004-04-26 17:31:26
Subject: Re: comma separated value splitting
Previous:From: Oliver FrommeDate: 2004-04-26 07:20:36
Subject: Re: Is there a command to to display active connections

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group