Re: [PATCH] SQL function to report log message

On 7/13/15 3:39 PM, dinesh kumar wrote:
> I don't really see the point of what you're describing here. Just do
> something like RAISE WARNING which should normally be high enough to
> make it into the logs. Or use a pl language that will let you write
> your own logfile on the server (ie: plperlu).
>
> True. Using plperlu, shall we bypass our log_* settings. If it's true, i
> wasn't sure about it.

plperlu can do anything the server can do. Including fun things like
appending to any file the server can write to or executing things like
`rm -rf pg_xlog`.

> I didn't mean that, we need to have this feature, since we have
> it on
> other RDBMS. I don't see a reason, why don't we have this in our
> PG too.
>
> I see the similar item in our development list
> <http://www.postgresql.org/message-id/53A8E96E.9060507@2ndquadrant.com>.
>
>
> That's not at all what that item is talking about. It's talking
> about exposing ereport as a SQL function, without altering the rest
> of our logging behavior.
>
>
> Ah. It's' my bad interpretation. Let me work on it, and will send a new
> patch as a wrapper sql function for ereport.

You might want to present a plan for that; it's not as trivial as it
sounds due to how ereport works. In particular, I'd want to see (at
minimum) the same functionality that plpgsql's RAISE command now
provides (errdetail, errhint, etc).
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com