Re: [HACKERS] Please, apply patch for current CVS

2003-06-11 Thread Bruce Momjian

Thanks.  Fixed.

---

Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Patch applied.  You patch indicated _int.c should be removed from CVS,
> > so I have done so.
> 
> This patch causes contrib/intarray to fail to build.
> 
> $ make
> sed 's,MODULE_PATHNAME,$libdir/_int,g' _int.sql.in >_int.sql
> make: *** No rule to make target `_int_bool.o', needed by `lib_int.a'.  Stop.
> $
> 
>   regards, tom lane
> 
> ---(end of broadcast)---
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
> 

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly


Re: [HACKERS] Please, apply patch for current CVS

2003-06-11 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Patch applied.  You patch indicated _int.c should be removed from CVS,
> so I have done so.

This patch causes contrib/intarray to fail to build.

$ make
sed 's,MODULE_PATHNAME,$libdir/_int,g' _int.sql.in >_int.sql
make: *** No rule to make target `_int_bool.o', needed by `lib_int.a'.  Stop.
$

regards, tom lane

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org


Re: [HACKERS] Please, apply patch for current CVS

2003-06-11 Thread Bruce Momjian

Patch applied.  You patch indicated _int.c should be removed from CVS,
so I have done so.

---

Teodor Sigaev wrote:
> Patch for contrib/intarray and contrib/ltree modules.
> 
> Download from: 
> http://www.sai.msu.su/~megera/postgres/gist/patches/intarray_ltree.patch.gz
> 
> Changes:
> 1 intarray: bugfix for int[]-int[] operation
> 2 intarray: split _int.c to several files (_int.c now is unused)
> 3 ntarray (gist__intbig_ops opclass): use special type for index storage
> 4 ltree (gist__ltree_ops opclass), intarray (gist__intbig_ops): optimize GiST's 
> penalty and picksplit interface functions, now use Hemming distance.
> 
> Thank you.
> 
> -- 
> Teodor Sigaev  E-mail: [EMAIL PROTECTED]
> 
> 
> ---(end of broadcast)---
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
> 

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org


Re: [HACKERS] Please, apply patch for current CVS

2003-06-01 Thread Bruce Momjian

Your patch has been added to the PostgreSQL unapplied patches list at:

http://momjian.postgresql.org/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

---


Teodor Sigaev wrote:
> Patch for contrib/intarray and contrib/ltree modules.
> 
> Download from: 
> http://www.sai.msu.su/~megera/postgres/gist/patches/intarray_ltree.patch.gz
> 
> Changes:
> 1 intarray: bugfix for int[]-int[] operation
> 2 intarray: split _int.c to several files (_int.c now is unused)
> 3 ntarray (gist__intbig_ops opclass): use special type for index storage
> 4 ltree (gist__ltree_ops opclass), intarray (gist__intbig_ops): optimize GiST's 
> penalty and picksplit interface functions, now use Hemming distance.
> 
> Thank you.
> 
> -- 
> Teodor Sigaev  E-mail: [EMAIL PROTECTED]
> 
> 
> ---(end of broadcast)---
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
> 

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [HACKERS] Please apply patch

2003-02-18 Thread Bruce Momjian

Patch applied.  Thanks.

---


Teodor Sigaev wrote:
> Please apply patches for contrib/ltree.
> 
> ltree_73.patch.gz - for 7.3 :
>   Fix ~ operation bug: eg '1.1.1' ~ '*.1'
> 
> ltree_74.patch.gz - for current CVS
> Fix ~ operation bug: eg '1.1.1' ~ '*.1'
> Add ? operation
> Optimize index storage
> 
> Last change needs drop/create all ltree indexes, so only for 7.4
> 
> Thank you.
> 
> -- 
> Teodor Sigaev
> [EMAIL PROTECTED]
> 

[ application/gzip is not supported, skipping... ]

[ application/gzip is not supported, skipping... ]

> 
> ---(end of broadcast)---
> TIP 4: Don't 'kill -9' the postmaster

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [HACKERS] Please apply patch

2003-02-17 Thread Bruce Momjian

Your patch has been added to the PostgreSQL unapplied patches list at:

http://momjian.postgresql.org/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

---


Teodor Sigaev wrote:
> Please apply patches for contrib/ltree.
> 
> ltree_73.patch.gz - for 7.3 :
>   Fix ~ operation bug: eg '1.1.1' ~ '*.1'
> 
> ltree_74.patch.gz - for current CVS
> Fix ~ operation bug: eg '1.1.1' ~ '*.1'
> Add ? operation
> Optimize index storage
> 
> Last change needs drop/create all ltree indexes, so only for 7.4
> 
> Thank you.
> 
> -- 
> Teodor Sigaev
> [EMAIL PROTECTED]
> 

[ application/gzip is not supported, skipping... ]

[ application/gzip is not supported, skipping... ]

> 
> ---(end of broadcast)---
> TIP 4: Don't 'kill -9' the postmaster

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])



[HACKERS] Please apply patch

2003-02-07 Thread Teodor Sigaev
Please apply patches for contrib/ltree.

ltree_73.patch.gz - for 7.3 :
	Fix ~ operation bug: eg '1.1.1' ~ '*.1'

ltree_74.patch.gz - for current CVS
   Fix ~ operation bug: eg '1.1.1' ~ '*.1'
   Add ? operation
   Optimize index storage

Last change needs drop/create all ltree indexes, so only for 7.4

Thank you.

--
Teodor Sigaev
[EMAIL PROTECTED]




ltree_73.patch.gz
Description: application/gzip


ltree_74.patch.gz
Description: application/gzip

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



Re: [HACKERS] please apply patch to CVS ( 7.3 and 7.4dev)

2002-12-27 Thread Bruce Momjian

Applied to 7.3.X and CVS HEAD. Thanks.

---

Oleg Bartunov wrote:
> Small fix in documentation and some examples of usage.
> Please, apply to 7.3 and current CVS
> 
>   Regards,
>   Oleg
> _
> Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
> Sternberg Astronomical Institute, Moscow University (Russia)
> Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
> phone: +007(095)939-16-83, +007(095)939-23-83

Content-Description: 

[ Attachment, skipping... ]

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



Re: [HACKERS] please apply patch to CVS ( 7.3 and 7.4dev)

2002-12-19 Thread Bruce Momjian

Your patch has been added to the PostgreSQL unapplied patches list at:

http://momjian.postgresql.org/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

---


Oleg Bartunov wrote:
> Small fix in documentation and some examples of usage.
> Please, apply to 7.3 and current CVS
> 
>   Regards,
>   Oleg
> _
> Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
> Sternberg Astronomical Institute, Moscow University (Russia)
> Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
> phone: +007(095)939-16-83, +007(095)939-23-83

Content-Description: 

[ Attachment, skipping... ]

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



[HACKERS] please apply patch to CVS ( 7.3 and 7.4dev)

2002-12-19 Thread Oleg Bartunov
Small fix in documentation and some examples of usage.
Please, apply to 7.3 and current CVS

Regards,
Oleg
_
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

--- contrib/intarray/README.intarray.orig   Thu Oct  3 21:16:31 2002
+++ contrib/intarray/README.intarrayThu Dec 19 15:15:16 2002
@@ -8,22 +8,59 @@
 
 All work was done by Teodor Sigaev ([EMAIL PROTECTED]) and Oleg Bartunov
 ([EMAIL PROTECTED]). See http://www.sai.msu.su/~megera/postgres/gist
-for additional information. Andrey Oktyabrski has done a great work on 
+for additional information. Andrey Oktyabrski did a great work on 
 adding new functions and operations.
 
 
 FUNCTIONS:
 
   int   icount(int[]) - the number of elements in intarray
+
+test=# select icount('{1,2,3}'::int[]);   
+ icount 
+
+  3
+(1 row)
+
   int[] sort(int[], 'asc' | 'desc') - sort intarray
+
+test=# select sort('{1,2,3}'::int[],'desc');
+  sort   
+-
+ {3,2,1}
+(1 row)
+
   int[] sort(int[]) - sort in ascending order
   int[] sort_asc(int[]),sort_desc(int[]) - shortcuts for sort 
+
   int[] uniq(int[]) - returns unique elements
+
+test=# select uniq(sort('{1,2,3,2,1}'::int[]));
+  uniq   
+-
+ {1,2,3}
+(1 row)
+
   int   idx(int[], int item) - returns index of first intarray matching element to 
item, or
   '0' if matching failed.
+
+test=# select idx('{1,2,3,2,1}'::int[],2);
+ idx 
+-
+   2
+(1 row)
+
+
   int[] subarray(int[],int START [, int LEN]) - returns part of intarray starting 
from
 element number START (from 1) and 
length LEN. 
 
+test=# select subarray('{1,2,3,2,1}'::int[],2,3);
+ subarray 
+--
+ {2,3,2}
+(1 row)
+
+
 OPERATIONS:
 
   int[] && int[]  - overlap - returns TRUE if arrays has at least one common 
elements.
@@ -33,7 +70,7 @@
   int[] + int - push element to array ( add to end of array)
   int[] + int[]   - merge of arrays (right array added to the end of left one)
   int[] - int - remove entries matched by right argument from array
-  int[] - int[]   - remove left array from right
+  int[] - int[]   - remove right array from left
   int[] | int - returns intarray - union of arguments
   int[] | int[]   - returns intarray as a union of two arrays
   int[] & int[]   - returns intersection of arrays


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



Re: [HACKERS] Please, apply patch for 7.3.1 and current CVS

2002-12-12 Thread Bruce Momjian

Patch applied.  Thanks.

Backpatched to 7.3.

---


Teodor Sigaev wrote:
> This patch fixes minor bugs in dictionary generator in contrib/tsearch 
> (contrib/tsearch/makedict/makedict.pl)
> 
> Thank you.
> 
> -- 
> Teodor Sigaev
> [EMAIL PROTECTED]
> 

[ application/gzip is not supported, skipping... ]

> 
> ---(end of broadcast)---
> TIP 4: Don't 'kill -9' the postmaster

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



Re: [HACKERS] Please, apply patch for 7.3.1 and current CVS

2002-12-12 Thread Bruce Momjian

Your patch has been added to the PostgreSQL unapplied patches list at:

http://momjian.postgresql.org/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

---


Teodor Sigaev wrote:
> This patch fixes minor bugs in dictionary generator in contrib/tsearch 
> (contrib/tsearch/makedict/makedict.pl)
> 
> Thank you.
> 
> -- 
> Teodor Sigaev
> [EMAIL PROTECTED]
> 

[ application/gzip is not supported, skipping... ]

> 
> ---(end of broadcast)---
> TIP 4: Don't 'kill -9' the postmaster

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])



[HACKERS] Please, apply patch for 7.3.1 and current CVS

2002-12-12 Thread Teodor Sigaev
This patch fixes minor bugs in dictionary generator in contrib/tsearch 
(contrib/tsearch/makedict/makedict.pl)

Thank you.

--
Teodor Sigaev
[EMAIL PROTECTED]



tsearch_patch.gz
Description: application/gzip

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



Re: [HACKERS] Please, apply patch of tsearch for current CVS & 7.3.1

2002-12-05 Thread Bruce Momjian

Patch applied to HEAD and 7.3.  Thanks.

---


Teodor Sigaev wrote:
> Thank you very much, you catch it :). This bug had a long life, because it 
> exists if and only if locale of postmaster
> was a different from C (or ru_RU.KOI8-R).
> 
> Please, apply patch for current CVS & 7.3.1
> 
> Magnus Naeslund(f) wrote:
> > Ok, I nailed the bug, but i'm not sure what the correct fix is.
> > Attached tsearch_morph.diff that remedies this problem by avoiding it.
> > Also there's a debug aid patch if someone would like to know how i
> > finally found it out :)
> > 
> > There problem in the lemmatize() function is that GETDICT(...) returned
> > a value not handled (BYLOCALE).
> > The value (-1) and later used as an index into the dicts[] array.
> > After that everything went berserk stack went crazy somehow so trapping
> > the fault sent me to the wrong place, and every time i read the value it
> > was positive ;)
> > 
> > So now i just return the initial word passed to the lemmatize function,
> > because i don't know what to do with it.
> > 
> > So you tsearch guys will have to work it out :)
> >
> 
> -- 
> Teodor Sigaev
> [EMAIL PROTECTED]
> 

[ application/gzip is not supported, skipping... ]

> 
> ---(end of broadcast)---
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



Re: [HACKERS] Please, apply patch of tsearch for current CVS & 7.3.1

2002-12-04 Thread Bruce Momjian

Your patch has been added to the PostgreSQL unapplied patches list at:

http://momjian.postgresql.org/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

---


Teodor Sigaev wrote:
> Thank you very much, you catch it :). This bug had a long life, because it 
> exists if and only if locale of postmaster
> was a different from C (or ru_RU.KOI8-R).
> 
> Please, apply patch for current CVS & 7.3.1
> 
> Magnus Naeslund(f) wrote:
> > Ok, I nailed the bug, but i'm not sure what the correct fix is.
> > Attached tsearch_morph.diff that remedies this problem by avoiding it.
> > Also there's a debug aid patch if someone would like to know how i
> > finally found it out :)
> > 
> > There problem in the lemmatize() function is that GETDICT(...) returned
> > a value not handled (BYLOCALE).
> > The value (-1) and later used as an index into the dicts[] array.
> > After that everything went berserk stack went crazy somehow so trapping
> > the fault sent me to the wrong place, and every time i read the value it
> > was positive ;)
> > 
> > So now i just return the initial word passed to the lemmatize function,
> > because i don't know what to do with it.
> > 
> > So you tsearch guys will have to work it out :)
> >
> 
> -- 
> Teodor Sigaev
> [EMAIL PROTECTED]
> 

[ application/gzip is not supported, skipping... ]

> 
> ---(end of broadcast)---
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



[HACKERS] Please, apply patch of tsearch for current CVS & 7.3.1

2002-12-04 Thread Teodor Sigaev
Thank you very much, you catch it :). This bug had a long life, because it 
exists if and only if locale of postmaster
was a different from C (or ru_RU.KOI8-R).

Please, apply patch for current CVS & 7.3.1

Magnus Naeslund(f) wrote:
Ok, I nailed the bug, but i'm not sure what the correct fix is.
Attached tsearch_morph.diff that remedies this problem by avoiding it.
Also there's a debug aid patch if someone would like to know how i
finally found it out :)

There problem in the lemmatize() function is that GETDICT(...) returned
a value not handled (BYLOCALE).
The value (-1) and later used as an index into the dicts[] array.
After that everything went berserk stack went crazy somehow so trapping
the fault sent me to the wrong place, and every time i read the value it
was positive ;)

So now i just return the initial word passed to the lemmatize function,
because i don't know what to do with it.

So you tsearch guys will have to work it out :)



--
Teodor Sigaev
[EMAIL PROTECTED]




tsearch_patch.gz
Description: application/gzip

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



Re: [HACKERS] please apply patch to contrib/ltree

2002-09-19 Thread Bruce Momjian


Patch applied.  Thanks.

---


Oleg Bartunov wrote:
> Tiny patch fixing small documentation typo.
> 
>   Regards,
>   Oleg
> _
> Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
> Sternberg Astronomical Institute, Moscow University (Russia)
> Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
> phone: +007(095)939-16-83, +007(095)939-23-83

Content-Description: 

[ Attachment, skipping... ]

> 
> ---(end of broadcast)---
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])



Re: [HACKERS] please apply patch to contrib/ltree

2002-09-18 Thread Bruce Momjian


Your patch has been added to the PostgreSQL unapplied patches list at:

http://candle.pha.pa.us/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

---


Oleg Bartunov wrote:
> Tiny patch fixing small documentation typo.
> 
>   Regards,
>   Oleg
> _
> Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
> Sternberg Astronomical Institute, Moscow University (Russia)
> Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
> phone: +007(095)939-16-83, +007(095)939-23-83

Content-Description: 

[ Attachment, skipping... ]

> 
> ---(end of broadcast)---
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])



[HACKERS] please apply patch to contrib/ltree

2002-09-18 Thread Oleg Bartunov

Tiny patch fixing small documentation typo.

Regards,
Oleg
_
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


*** contrib/ltree/README.ltree  Sun Aug 11 00:46:24 2002
--- README.ltree.newWed Sep 18 13:08:27 2002
***
*** 144,154 
* GiST index over ltree:
  <, <=, =, =>, >, @>, <@, @, ~
  Example:
! create index path_gist_idx on test using gist_ltree_ops (path);
* GiST index over ltree[]:
  ltree[]<@ ltree, ltree @> ltree[], @, ~.
  Example:
! create index path_gist_idx on test using gist__ltree_ops (array_path);
  Notices: This index is lossy.
  
  FUNCTIONS
--- 144,154 
* GiST index over ltree:
  <, <=, =, =>, >, @>, <@, @, ~
  Example:
! create index path_gist_idx on test using gist (path);
* GiST index over ltree[]:
  ltree[]<@ ltree, ltree @> ltree[], @, ~.
  Example:
! create index path_gist_idx on test using gist (array_path);
  Notices: This index is lossy.
  
  FUNCTIONS



---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



[HACKERS] Please, apply patch

2002-08-22 Thread Teodor Sigaev

Please, apply patch for tsearch to current CVS.

Patch resolve ERROR problem for non-goog query_txt.

Teodor Sigaev wrote:
> Now you can use:
> regression=# select 'the'::mquery_txt;
> ERROR:  Your query contained only stopword(s), ignored
> regression=# select 'good'::mquery_txt;
>  mquery_txt
> 
>  'good'
> (1 row)
> 
> I suggest:
> 1.
> regression=# select 'the'::mquery_txt;
> NOTICE:  Your query contained only stopword(s), ignored
> mquery_txt
> -
> 
> (1 row)
> 2. any operation with void query returns false:
> select  t from tbl where t ## 'the';
> NOTICE:  Your query contained only stopword(s), ignored
> tbl
> -
> (0 row)
> 
> 
> 
> 
> 
> Christopher Kings-Lynne wrote:
> 
>> Ross - maybe we could work on a little function for tsearch - 
>> parse_query()
>> or something like that.  It could return true or false depending on 
>> whether
>> it would cause tsearch to error or not...
>>
>> Chris
>>
>>
>>> -Original Message-
>>> From: [EMAIL PROTECTED]
>>> [mailto:[EMAIL PROTECTED]]On Behalf Of Ross J.
>>> Reedstrom
>>> Sent: Friday, 16 August 2002 4:59 AM
>>> To: Oleg Bartunov
>>> Cc: Christopher Kings-Lynne; Hackers
>>> Subject: Re: [HACKERS] tsearch bug in 7.2.1?
>>>
>>>
>>> On Thu, Aug 15, 2002 at 11:59:20AM +0300, Oleg Bartunov wrote:
>>>
 tsearch has compiled-in stop-list, it's currently just not flexible
 as OpenFTS does. We plan to move most functionality to tsearch but
 currently have no time. Feel free to join us to speedup tsearch
 development.
>>>
>>>
>>> Oleg -
>>> I think Chris's issue might be the same one I ran into just last night.
>>> (BTW, thanks for tsearch and the OpenFTS work, it's really great)
>>> My problem is that queries with only stopwords throw an ERROR, rather
>>> than a WARNING or NOTICE. This means We've got to deal with catching an
>>> exception so our middleware doesn't spew ugly errors and tracebacks at
>>> our endusers, and I've got to deal with cleaning up the transaction.
>>>
>>> Having the behavior be "issue a notice and return no match" would give
>>> us a reasonably functional interface: if I don't implement reading the
>>> NOTICE, I get confused users ('huh? "the" doesn't match anything?')
>>> rather than irate users ('Your search interface sucks! It keeps
>>> crashing!')
>>>
>>> Oh, well, off to implement some try: catch: logic.
>>>
>>> Ross
>>>
>>> ---(end of broadcast)---
>>> TIP 4: Don't 'kill -9' the postmaster
>>>
>>
>>
>>
>> ---(end of broadcast)---
>> TIP 3: if posting/reading through Usenet, please send an appropriate
>> subscribe-nomail command to [EMAIL PROTECTED] so that your
>> message can get through to the mailing list cleanly
>>
> 
> 


-- 
Teodor Sigaev
[EMAIL PROTECTED]




tsearch_patch.gz
Description: application/gzip


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [HACKERS] Please, apply patch for contrib/tsearch

2002-08-14 Thread Bruce Momjian


Patch applied.  Thanks.

---


Teodor Sigaev wrote:
> CHANGES:
> 
> August 13, 2002
>  Use parser of OpenFTS v0.33.
> 
> -- 
> Teodor Sigaev
> [EMAIL PROTECTED]
> 

[ application/gzip is not supported, skipping... ]

> 
> ---(end of broadcast)---
> TIP 4: Don't 'kill -9' the postmaster

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [HACKERS] Please, apply patch for contrib/tsearch

2002-08-13 Thread Bruce Momjian


Your patch has been added to the PostgreSQL unapplied patches list at:

http://candle.pha.pa.us/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

---


Teodor Sigaev wrote:
> CHANGES:
> 
> August 13, 2002
>  Use parser of OpenFTS v0.33.
> 
> -- 
> Teodor Sigaev
> [EMAIL PROTECTED]
> 

[ application/gzip is not supported, skipping... ]

> 
> ---(end of broadcast)---
> TIP 4: Don't 'kill -9' the postmaster

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



Re: [HACKERS] Please, apply patch for contrib/tsearch

2002-08-13 Thread Teodor Sigaev

to current CVS, of course. Sorry
-- 
Teodor Sigaev
[EMAIL PROTECTED]



---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



[HACKERS] Please, apply patch for contrib/tsearch

2002-08-13 Thread Teodor Sigaev

CHANGES:

August 13, 2002
 Use parser of OpenFTS v0.33.

-- 
Teodor Sigaev
[EMAIL PROTECTED]




tsearch_patch.gz
Description: application/gzip


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



[HACKERS] please apply patch

2002-04-01 Thread Nicolas Bazin



 
- Original Message - 
From: Nicolas 
Bazin 
To: PostgreSQL-development 
Cc: Tom 
Lane ; Bruce Momjian ; Michael 
Meskes 
Sent: Thursday, March 28, 2002 9:30 AM
Subject: Always the same ecpg bug - please (re)apply 
patch

Here is the description:
 
When a macro is replaced by the preprocessor, pgc.l 
reaches a end of file, which is not the actual end of the file. One side effect 
of that is that if you are in a ifdef block, you get a wrong error telling you 
that a endif is missing.
 
This patch corrects pgc.l and also adds a test of 
this problem to test1.pgc. To convince you apply the patch to test1.pgc first 
then try to compile the test then apply the patch to pgc.l.
 
The patch moves the test of the scope of an ifdef 
block to the end of the file beeing parsed, including all includes files, ... 
.
 
For the record, this patch was applied a first time 
by bruce then overwritten by Micheal and reapplied by him. But the big mystery 
is that there is no trace of that in CVS 
 
Nicolas


ecpg.patch
Description: Binary data


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



Re: [HACKERS] please apply patch for GiST (7.1.1, current cvs)

2001-05-15 Thread Tom Lane

Bruce Momjian <[EMAIL PROTECTED]> writes:
> Applied to 7.1.1 and 7.2.  Thanks.

You seem to have missed the REL7_1_STABLE branch ...

regards, tom lane

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster