to_address table should be altered to text .. its truncating anything over 255 .. unless something is supposed to split the to field ? This error is happening when the to: has a lot of addresses.
-- Jeremy McSpadden Flux Labs | http://www.fluxlabs.net<http://www.fluxlabs.net/> | Endless Solutions Office : 850-250-5590x101<tel:850-250-5590;101> | Cell : 850-890-2543<tel:850-890-2543> | Fax : 850-254-2955<tel:850-254-2955> On Jan 15, 2014, at 4:22 PM, Jeremy McSpadden <[email protected]<mailto:[email protected]>> wrote: baruwa=> \d messages Table "public.messages" Column | Type | Modifiers ---------------+--------------------------+------------------------------------------------------- id | bigint | not null default nextval('messages_id_seq'::regclass) messageid | character varying(255) | actions | character varying(128) | clientip | character varying(128) | date | date | from_address | character varying(255) | from_domain | character varying(255) | headers | text | hostname | text | highspam | smallint | rblspam | smallint | saspam | smallint | spam | smallint | nameinfected | smallint | otherinfected | smallint | isquarantined | smallint | isarchived | smallint | sascore | double precision | scaned | smallint | size | integer | blacklisted | smallint | spamreport | text | whitelisted | smallint | subject | text | time | time with time zone | timestamp | timestamp with time zone | default timezone('utc'::text, now()) to_address | character varying(255) | to_domain | character varying(255) | virusinfected | smallint | ts | timestamp with time zone | default timezone('utc'::text, now()) Anyway to show a test insert, not sure which of the varying(255) it is saying is too long . -- Jeremy McSpadden Flux Labs | http://www.fluxlabs.net<http://www.fluxlabs.net/> | Endless Solutions Office : 850-250-5590x101<tel:850-250-5590;101> | Cell : 850-890-2543<tel:850-890-2543> | Fax : 850-254-2955<tel:850-254-2955> _______________________________________________ http://pledgie.com/campaigns/12056 _______________________________________________ http://pledgie.com/campaigns/12056
_______________________________________________ http://pledgie.com/campaigns/12056
