Ah ok. I must have copied it incorectly. I am using 8.0.1 from the
latest binary build from NetBSD. The source I used was
postgresql-8.0.1.tar.bz2 stable release.
I will try the CVS release to see if it's fixed.
--Joel
On Apr 7, 2005 12:26 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Joel Leyh <hashbang@gmail.com> 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
>
