Re: Can the backend return more than one error message per PQexec? - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Can the backend return more than one error message per PQexec?
Date
Msg-id Pine.LNX.4.30.0106061734310.757-100000@peter.localdomain
Whole thread Raw
In response to Re: Can the backend return more than one error message per PQexec?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Can the backend return more than one error message per PQexec?
List pgsql-hackers
Tom Lane writes:

> One way to do this that wouldn't involve breaking the protocol is
> to assign significance to linebreaks in an 'E' message's payload.

Some fields may contain line breaks; for example, error messages
definitely do now.  We could pick a non-printing character (e.g., \001)
as the separator, but it might get ugly with multibyte.  Of course table
names and such things can contain these characters as well, but I guess
there wouldn't be so much resistance in changing that.  At worst we could
make up an escape mechanism.

> Also, it would work tolerably well when fed to an old application that
> knows nothing of the convention and just prints out the error string.
> I'm leery of defining a whole new API that must be used before one
> gets to see any of the added error information --- that would mean
> that a lot of people never will see it.

Okay, so PQerrorMessage will print the whole glob, whereas there would be
an accessor method that would filter out the fields.  That would also work
transparently with the notice processor, which I was concerned about until
now.  I like it.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



pgsql-hackers by date:

Previous
From: "Rod Taylor"
Date:
Subject: Timestamp change - 8601 compliance
Next
From: Tom Lane
Date:
Subject: Re: SQL( "if ...exists...),how to do it in the PostgreSQL?