Re: [BUGS] 8.2beta1 (w32): server process crash (tsvector)

2006-11-16 Thread Magnus Hagander
> Sent: den 13 november 2006 10:36 > To: Thomas H.; pgsql-bugs@postgresql.org > Cc: Tom Lane > Subject: Re: [BUGS] 8.2beta1 (w32): server process crash (tsvector) > > Did yet some more stuff, mainly in line of shotgun-debugging :-) > > If I add a "return NULL

Re: [BUGS] 8.2beta1 (w32): server process crash (tsvector)

2006-11-13 Thread Magnus Hagander
agander > Sent: den 13 november 2006 10:01 > To: Thomas H.; pgsql-bugs@postgresql.org > Cc: Tom Lane > Subject: Re: [BUGS] 8.2beta1 (w32): server process crash (tsvector) > > Did some more tests, and it's even easier to repro this. No > need to update, just SELECT to

Re: [BUGS] 8.2beta1 (w32): server process crash (tsvector)

2006-11-13 Thread Magnus Hagander
t end fires. //Magnus > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Magnus Hagander > Sent: den 12 november 2006 17:06 > To: Thomas H.; pgsql-bugs@postgresql.org > Cc: Tom Lane > Subject: Re: [BUGS] 8.2beta1 (w32): serve

Re: [BUGS] 8.2beta1 (w32): server process crash (tsvector)

2006-11-12 Thread Magnus Hagander
> > no, i used the win32 setup and selected to install tsearch2 contrib > > module... so i didn't even had to run "\i tsearch2.sql". > installation > > logs are available if helpful. > > Hm, I wonder whether the windows installer changes tsearch2's > configuration at all. It doesn't. And in m

Re: [BUGS] 8.2beta1 (w32): server process crash (tsvector)

2006-11-12 Thread Dave Page
Tom Lane wrote: "Thomas H." <[EMAIL PROTECTED]> writes: no, i used the win32 setup and selected to install tsearch2 contrib module... so i didn't even had to run "\i tsearch2.sql". installation logs are available if helpful. Hm, I wonder whether the windows installer changes tsearch2's config

Re: [BUGS] 8.2beta1 (w32): server process crash (tsvector)

2006-11-12 Thread Thomas H.
TECTED]>; Sent: Sunday, November 12, 2006 6:56 PM Subject: Re: [BUGS] 8.2beta1 (w32): server process crash (tsvector) "Thomas H." <[EMAIL PROTECTED]> writes: no, i used the win32 setup and selected to install tsearch2 contrib module... so i didn't even had to run &qu

Re: [BUGS] 8.2beta1 (w32): server process crash (tsvector)

2006-11-12 Thread Tom Lane
"Thomas H." <[EMAIL PROTECTED]> writes: > no, i used the win32 setup and selected to install tsearch2 contrib > module... so i didn't even had to run "\i tsearch2.sql". installation logs > are available if helpful. Hm, I wonder whether the windows installer changes tsearch2's configuration at al

Re: [BUGS] 8.2beta1 (w32): server process crash (tsvector)

2006-11-12 Thread Thomas H.
Did you do anything to install tsearch2 into this fresh database beyond "\i tsearch2.sql"? no, i used the win32 setup and selected to install tsearch2 contrib module... so i didn't even had to run "\i tsearch2.sql". installation logs are available if helpful. should i try a manual install of

Re: [BUGS] 8.2beta1 (w32): server process crash (tsvector)

2006-11-12 Thread Tom Lane
"Thomas H." <[EMAIL PROTECTED]> writes: > here are the steps to reproduce: > > 1. intall win32 beta3 as new instance using UTF8 / en_US and tsearch2 > module, everything else default > 2. create new db with encoding UTF8, standard template > 3. load data from http://alternize.com/pgsql/ts

Re: [BUGS] 8.2beta1 (w32): server process crash (tsvector)

2006-11-12 Thread Thomas H.
"imad" <[EMAIL PROTECTED]> To: "Magnus Hagander" <[EMAIL PROTECTED]> Cc: "Thomas H." <[EMAIL PROTECTED]>; ; "Tom Lane" <[EMAIL PROTECTED]> Sent: Sunday, November 12, 2006 5:20 PM Subject: Re: [BUGS] 8.2beta1 (w32): server process crash (

Re: [BUGS] 8.2beta1 (w32): server process crash (tsvector)

2006-11-12 Thread imad
x on "someint", and nothing on the tsvector column. //Magnus > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Thomas H. > Sent: den 12 november 2006 15:06 > To: pgsql-bugs@postgresql.org > Subject: Re: [BUGS] 8.2beta1 (

Re: [BUGS] 8.2beta1 (w32): server process crash (tsvector)

2006-11-12 Thread Magnus Hagander
gt; [mailto:[EMAIL PROTECTED] On Behalf Of Thomas H. > Sent: den 12 november 2006 15:06 > To: pgsql-bugs@postgresql.org > Subject: Re: [BUGS] 8.2beta1 (w32): server process crash (tsvector) > > this bug (please see below) is unfortunately still present in > beta3 (win32 build). tes

Re: [BUGS] 8.2beta1 (w32): server process crash (tsvector)

2006-11-12 Thread Thomas H.
Tuesday, October 17, 2006 9:19 PM Subject: Re: [BUGS] 8.2beta1 (w32): server process crash (tsvector) the following query will crash the server process: INSERT INTO news.news SELECT * FROM news.news2; This is undoubtedly data-dependent. Can you supply some sample data that makes it happen?

Re: [BUGS] 8.2beta1 (w32): server process crash (tsvector)

2006-10-25 Thread Thomas H.
OTECTED]> Cc: Sent: Tuesday, October 17, 2006 10:19 PM Subject: Re: [BUGS] 8.2beta1 (w32): server process crash (tsvector) the following query will crash the server process: INSERT INTO news.news SELECT * FROM news.news2; This is undoubtedly data-dependent. Can you supply some sample data that m

Re: [BUGS] 8.2beta1 (w32): server process crash (tsvector)

2006-10-18 Thread me
No. It's debugging output for a problem we had earlier, and will be removed before release. thanks for clarifying. wasn't sure whether the comment in the release notes really was applying to these "file not found" error messages. Unless beaten to it, I'll try to look at the other part later

Re: [BUGS] 8.2beta1 (w32): server process crash (tsvector)

2006-10-18 Thread Magnus Hagander
[offline ATM, can't look at the main issue, just wanted to get a comment in about fopen(). Unless beaten to it, I'll try to look at the other part later.] > on a sidenote: are those fopen() errors debug-code-leftovers > or something one should worry about? i can't find those files > on the file

Re: [BUGS] 8.2beta1 (w32): server process crash (tsvector)

2006-10-17 Thread me
the following query will crash the server process: INSERT INTO news.news SELECT * FROM news.news2; This is undoubtedly data-dependent. Can you supply some sample data that makes it happen? it's not only happening with INSERTS, but also updates. as thats easier to test, here's how i can reprod

Re: [BUGS] 8.2beta1 (w32): server process crash (tsvector)

2006-10-17 Thread Tom Lane
<[EMAIL PROTECTED]> writes: > the following query will crash the server process: > INSERT INTO news.news > SELECT * FROM news.news2; This is undoubtedly data-dependent. Can you supply some sample data that makes it happen? regards, tom lane ---(en

[BUGS] 8.2beta1 (w32): server process crash (tsvector)

2006-10-16 Thread me
the following query will crash the server process:   INSERT INTO news.newsSELECT * FROM news.news2;   news.news is empty; news.news2 contains 600 records. both have the same structure (see end of mail)   when the tsvector column & trigger is dumped from the two tables everything works as exp