Re: [GENERAL] NOTICE: word is too long INSERT 0 3014

2006-10-30 Thread Teodor Sigaev
For example, redefine by follow way: typedef struct { uint32 haspos:1, len:31; uint32 pos; } WordEntry; /* <= 1Gb */ #define MAXSTRLEN ( 1<<30 ) #define MAXSTRPOS ( 1<<30 ) Teodor Sigaev wrote: I am running into this limitation ALOT with Tsearch2.

Re: [GENERAL] NOTICE: word is too long INSERT 0 3014

2006-10-30 Thread Teodor Sigaev
I am running into this limitation ALOT with Tsearch2. What are my options to get around it. Do I have to compile PostgreSQL with a different block size? If yes, what are the downsides to doing so (outside of not being able to do straight upgrades)? If you really need that, your should play arou

Re: [GENERAL] NOTICE: word is too long INSERT 0 3014

2006-10-26 Thread Joshua D. Drake
Any thoughts on the below? Joshua D. Drake wrote: > Hello, > > I am running into this limitation ALOT with Tsearch2. What are my > options to get around it. Do I have to compile PostgreSQL with a > different block size? > > If yes, what are the downsides to doing so (outside of not being able to

[GENERAL] NOTICE: word is too long INSERT 0 3014

2006-10-25 Thread Joshua D. Drake
Hello, I am running into this limitation ALOT with Tsearch2. What are my options to get around it. Do I have to compile PostgreSQL with a different block size? If yes, what are the downsides to doing so (outside of not being able to do straight upgrades)? Sincerely, Joshua D. Drake --