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$030a640a@tealuxe.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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
truncated.

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
www.tealuxe.com
tea for all

Responses

Browse pgsql-novice by date

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