on the table "file" the column "url" is a varchar(255)
When the url inserted is longer than 255 chars, postgres will say "don't be silly, you can't insert that" and reject it. Mysql will silently truncate the field. This means the data save is just plain wrong. for postgres, I can change this column to a type "text", and it's solved. i understand mysql is really slow at handling "text" columns, so i'm unsure if we can do the same there. It doesn't seem to be used in any WHERE clauses, so it's probably safe. what say you? _______________________________________________ Laconica-dev mailing list [email protected] http://mail.laconi.ca/mailman/listinfo/laconica-dev
