The following bug has been logged online:

Bug reference: 2527
Logged by: Lance Rushing
Email address: lance_rushing (AT) hotmail (DOT) com
PostgreSQL version: 8.1.1
Operating system: SuSE
Description: Contrib - tsearch2 - ' as first char for in to_tsquery()
Details:

Not sure if this is a best place to report, but..

When using to_tsquery(TEXT,TEXT) I enounter an error when the first
character is an apostrophe.

non-error example:
select to_tsquery('default'::text, 'o\'brien'::text);
to_tsquery
---------------
'o' & 'brien'

Example of error:
select to_tsquery('default'::text, '\'brien'::text);
ERROR: syntax error

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly