Re: Checking is TSearch2 query is valid - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Checking is TSearch2 query is valid
Date
Msg-id 200803122050.m2CKoTV23654@momjian.us
Whole thread Raw
In response to Re: Checking is TSearch2 query is valid  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
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@benjaminarai.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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

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

pgsql-general by date:

Previous
From: Alex Vinogradovs
Date:
Subject: table size in 8.3
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Functional Index Question