Re: [BUGS] Long strings, short varchars

2002-08-15 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Sasa Markovic writes: >> 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? > Write a rule that truncates t

Re: [BUGS] Long strings, short varchars

2002-08-15 Thread Peter Eisentraut
Sasa Markovic writes: > 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? Write a rule that truncates the string before it's inserted. -- Peter Eisentra

[BUGS] Long strings, short varchars

2002-08-14 Thread Sasa Markovic
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