View Single Post

   
  #1 (permalink)  
Old 04-12-2008, 06:06 AM
Magnus Hagander
 
Posts: n/a
Default tsearch2 error msg

search=# select to_tsquery('foo bar');
ERROR: syntax error


Might want to enhance that message to include the information that it's
parsing the tsquery that's failing? I originally had it as part of a
much larger query, and it took me a while to remember that it's tsearch
that spits out that very generic error message.

//Magnus


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Reply With Quote