Skip to content

RPostgres 1.2.0
Compare
Choose a tag to compare
@krlmlr krlmlr released this 19 Dec 10:51
v1.2.0
e232ecb

Communication with the database

  • Breaking: Translate floating-point values to DOUBLE PRECISION by default (#194).
  • Avoid aggressive rounding when passing numeric values to the database (#184).
  • Avoid adding extra spaces for numerics (#216).
  • Column names and error messages are UTF-8 encoded (#172).
  • dbWriteTable(copy = FALSE), sqlData() and dbAppendTable() now work for character columns (#209), which are always converted to UTF-8.

New features

  • Add timezone argument to dbConnect() (#187, @trafficonese).
  • Implement dbGetInfo() for the driver and the connection object.
  • dbConnect() gains check_interrupts argument that allows interrupting execution safely while waiting for query results to be ready (#193, @zozlak).
  • dbUnquoteIdentifier() also handles unquoted identifiers of the form table or schema.table, for compatibility with dbplyr. In addition, a catalog component is supported for quoting and unquoting with Id().
  • dbQuoteLiteral() available for "character" (#209).
  • Windows: update libpq to 11.1.0.
  • Fulfill CII badge requirements (#227, @TSchiefer).

Bug fixes

  • Hide unused symbols in shared library (#230, @troels).
  • Fix partial argument matching in dbAppendTable() (r-dbi/DBI#249).
  • Fix binding for whole numbers and POSIXt timestamps (#191).

Internal

  • sqlData(copy = FALSE) now uses dbQuoteLiteral() (#209).
  • Add tests for dbUnquoteIdentifier() (#220, @baileych).
  • Improved tests for numerical precision (#203, @harvey131).
  • Fix test: change from REAL to DOUBLE PRECISION (#204, @harvey131).
  • Implement dbAppendTable() for own connection class, don't hijack base class implementation (r-dbi/RMariaDB#119).
  • Avoid including the call in errors.
  • Align DbResult and other classes with RSQLite and RMariaDB.
Assets 2
Loading