turn varchar into text

The table defs use varchar, limiting url length, but not enforcing this limti in php code.

The result is a log file full of sql errors, and annoyed sysadmins.

255chars is too short for many URLS anyways.

so, i made a patch to turn the varchars into text.

tested in postgresql 8.1

BEGIN;
ALTER table  trackback_received add column new_name text;
update  trackback_received set new_name = name;
alter table  trackback_received alter column new_name set not null;

alter table  trackback_received drop column name;
alter table  trackback_received rename new_name to name;

ALTER table  trackback_received add column new_subject text;
update  trackback_received set new_subject = subject;
alter table  trackback_received alter column new_subject set not null;

alter table  trackback_received drop column subject;
alter table  trackback_received rename new_subject to subject;

ALTER table  trackback_received add column new_url text;
update  trackback_received set new_url = url;
alter table  trackback_received alter column new_url set not null;

alter table  trackback_received drop column url;
alter table  trackback_received rename new_url to url;


ALTER table  trackback_received add column new_excerpt text;
update  trackback_received set new_excerpt = excerpt;
alter table  trackback_received alter column new_excerpt set not null;

alter table  trackback_received drop column excerpt;
alter table  trackback_received rename new_excerpt to excerpt;
COMMIT;