Search Postgresql Archives

Re: Checking is TSearch2 query is valid

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxxx> 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@xxxxxxxxxx>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux