Re: Better handling of parse errors - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Better handling of parse errors
Date
Msg-id 200208171306.g7HD6vS06878@candle.pha.pa.us
Whole thread Raw
In response to Re: Better handling of parse errors  (Gavin Sherry <swm@linuxworld.com.au>)
List pgsql-hackers
Patch applied.  Thanks.

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


Gavin Sherry wrote:
> On Wed, 14 Aug 2002, Tom Lane wrote:
>
> > Gavin Sherry <swm@linuxworld.com.au> writes:
> > > ... do we want to modify every 7.2 error message?
> >
> > Nyet ... but I don't think tacking an offset onto the end of
> > "parse error at or near foo" messages is likely to cause the
> > sort of generalized havoc you suggest ...
>
> In that case, attached is a patch which locates the beginning of the
> offending token more efficiently (per your suggestion of using
> scanbuf). The new patch does the same as before:
>
> template1=# select * frum pg_class;
> ERROR:  parser: parse error at or near "frum" at character 10
>
> It also implement's Tom's suggestion:
>
> template1=# select * from pg_class where\g
> ERROR:  parse: parse error at end of input
>
> Gavin

Content-Description:

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: Re: Function result cacheing
Next
From: Bruce Momjian
Date:
Subject: Re: Removing Libraries (Was: Re: Open 7.3 issues)