Snapshot of 2 feb:

postgres=> create table one (str char(52));
CREATE
postgres=> insert into one values ('Salut!');
INSERT 546025 1
postgres=> create table two (str char(52));
CREATE
postgres=> insert into two select * from one;
ERROR:  Length of str is longer than length of target column str

Good luck!

Costin Oproiu


Fri, 6 Feb 1998 00:01:34 +0200 (EET)
PostgreSQL <postgres@linux.tpd.deuroconsult.ro>
Bug with char() type