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

Long strings, short varchars

From: "Sasa Markovic" <saxon(at)eunet(dot)yu>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Long strings, short varchars
Date: 2002-08-14 18:41:29
Message-ID: IHEFJCICNMFNCIKJAKIKEELACBAA.saxon@eunet.yu (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
In PostgreSQL 7.1, this code goes smoothly.

    create table test (name varchar(5));
    insert into test values('abracadabra');

Long input string was silently trimmed. But in PG7.2 an error is triggered.

OK, I suppose this is just a new feature, not a bug but. But...

...Is it possible to restore the old behaviour?

--
Best regards,
Sasa Markovic, Development Team Leader
DataGate Belgrade - http://www.datagate.co.yu


Responses

pgsql-hackers by date

Next:From: Matthew T. O'ConnorDate: 2002-08-14 18:47:45
Subject: More CVS Problems
Previous:From: Rod TaylorDate: 2002-08-14 18:40:40
Subject: Re: Open 7.3 items

pgsql-bugs by date

Next:From: Peter EisentrautDate: 2002-08-14 18:49:20
Subject: Re: mistakes in postgresql-snapshots (7.3)
Previous:From: Tom LaneDate: 2002-08-14 15:49:16
Subject: Re: Bug #738: "order by" returning different results in 7.2 and 7.21

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