Re: Reporting errors inside plpgsql/SPI queries - Mailing list pgsql-hackers

From Joe Conway
Subject Re: Reporting errors inside plpgsql/SPI queries
Date
Msg-id 405DE307.6040309@joeconway.com
Whole thread Raw
In response to Reporting errors inside plpgsql/SPI queries  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Reporting errors inside plpgsql/SPI queries  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Although this is quite reasonable for queries submitted by
> user-written C functions, I'm worried that plpgsql programmers will
> be confused because they've never heard of SPI.  I toyed with saying
> "SQL query" instead, but that seems pretty nearly content-free ... it
> doesn't distinguish these queries from ones submitted directly by the
> client. Can anyone think of a better wording?

"Embedded query"?

> Does this bother people enough to justify hacking the SPI interface
> to allow a label to be passed in?

That may be the only way to have the message make sense in all contexts.

Joe



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Syntax error reporting (was Re: [PATCHES] syntax error position "CREATE FUNCTION" bug fix)
Next
From: jseymour@LinxNet.com (Jim Seymour)
Date:
Subject: Re: 7.4.2 Build broken on (Sparc) Solaris 7 and 8