• Thoughts on logging
  • Background
  • PostgreSQL has supremely good log messages.
  • Original log event life cycle
  • Handling logged events in front-end code
  • Handling logged events in a back-end PL
  • As for PL/Java
  • How do the other PostgreSQL JDBCs give access to error details?
  • pgjdbc
  • pgjdbc-ng
  • Originating loggable events
  • As for PL/Java
  • Mapping of severity levels
  • How can JDBC front-end code originate events?
  • when throwing
  • when logging
  • What would a nice API look like?
  • An abstract LogRecord class (not derived from Exception)
  • An interface for exceptions that carry LogRecords
  • Different concrete subclasses of LogRecord
  • An ereport-like API for creating a LogRecord from scratch
  • Methods for the conversions into/out of log system or exception
  • In concert with existing standard API
  • Using familiar level names
  • Could pgjdbc move to java.util.logging without disruption?
  • A place to pause