I compiled 8.0.1 on linux with --with-debug only, and it seemed to
work. I had also compiled 8.0.1 on Netbsd with the same configure
option. I removed the tsearch trigger from the table and I had no
problem. I tried using to_tsvector directly and the server crashed.
PostgreSQL stand-alone backend
Joel Leyh <[EMAIL PROTECTED]> writes:
> 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.
Hmm. I found I still had an older copy of tsearch2 on my other machine,
but I couldn't dup
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 <[EMAIL PROTECTED]> wrote:
> Joel Leyh <[EMAI
Joel Leyh <[EMAIL PROTECTED]> 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 mistran
I have Pg installed on i386 NetBSD from the NetBSD package manager. I
then installed tsearch2 and used its default installation.
I then also got the source and built from it, with debugging enabled.
Again I installed tsearch2 but my results were the same.
Created a new database, added a table with
