Re: Checking is TSearch2 query is valid

Add psql TODO:

o Include the symbolic SQLSTATE name in verbose error reports

http://archives.postgresql.org/pgsql-general/2007-09/msg00438.php

---------------------------------------------------------------------------

Alvaro Herrera wrote:
> Tom Lane wrote:
> > Benjamin Arai <me(at)benjaminarai(dot)com> writes:
> > > Is there a specific exception code for:
> > > ERROR: no operand in tsearch query: "("
> >
> > regression=# \set VERBOSITY verbose
> > regression=# select to_tsquery('(');
> > ERROR: 42601: no operand in tsearch query: "("
> > LOCATION: gettoken_query, tsquery.c:163
> >
> > Seems to be "SYNTAX_ERROR".
>
> Hmm, maybe we should be displaying the textual name of the SQLSTATE
> somehow.
>
> --
> Alvaro Herrera http://www.amazon.com/gp/registry/5ZYLFMCVHXC
> "El d?a que dejes de cambiar dejar?s de vivir"
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +