Joel Leyh <hashbang@xxxxxxxxx> writes:
> insert into server_file values (default,'511','/test/20-Shania
> Twain-Party For Two with Billy
> Curringtonmp3','mp3','323',default,'1');
I get
ERROR: null value in column "server_file_size" violates not-null constraint
which I think indicates you mistranscribed your test query. I changed
it to
regression=# insert into server_file values (default,'511','/test/','Shania
regression'# Twain-Party For Two with Billy
regression'# Curringtonmp3','mp3','323',default,'1');
INSERT 155964 1
and as you can see I didn't get a crash. I'm testing with 8.0.2-to-be
(ie, 8.0 branch CVS tip). Teodor applied some tsearch2 fixes just last
week, so it might be that he fixed your bug --- what version are you
using exactly?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
