Skip to content

Releases: r-dbi/RPostgres

RPostgres 1.4.7

03 Jun 01:55
Compare
Choose a tag to compare

Features

  • Breaking change: Avoid appending a numeric suffix to duplicate column names (#463).

Bug fixes

  • dbWriteTable() correctly handles name clashes between temporary and permanent tables (#402, #431).
  • Fix dbQuoteIdentifier() for Id() objects to no longer rely on names (#460).

Chore

  • Bump preferred libpq version on MacOS to 15 (#441, #465).
  • Refactor dbListTables() et al. (@dpprdan, #413).
  • Refactor list_fields() (#462).
  • Use Id in exists_table() (#461).

Documentation

Testing

  • Test for columns in dbQuoteIdentifier() (@dpprdan, #263, #372).
  • Fix tests if DBItest is not installed (#448).

RPostgres 1.4.6

27 Oct 07:33
Compare
Choose a tag to compare

Breaking changes

  • Breaking change: dbListObjects() only allows Id() objects as prefix argument (@dpprdan, #390).

Bug fixes

  • Use NULL in favor of NULL::text when quoting strings and literals, to support JSON and other text-ish types. Fixes a regression introduced in #370 (#393, #425).

Features

  • dbQuoteLiteral() correctly quotes 64-bit integers from the bit64 package (of class "integer64") (@karawoo, #435, #436).

  • Breaking change: dbListObjects() only allows Id() objects as prefix argument (@dpprdan, #390).

Libraries

  • Windows: update to libpq-15.3 (#442).

  • Upgrade boost to 1.81.0-1 to fix sprintf warnings (#417).

Documentation

  • Suppress warning in gcc-12 (#443).

  • Tweak driver docs (@dpprdan, #433).

  • Relicense as MIT.

Testing

  • Close result set.

Internal

RPostgres 1.4.5

21 Jan 05:47
Compare
Choose a tag to compare

Features

RPostgres 1.4.4

02 May 12:50
Compare
Choose a tag to compare

Bug fixes

  • Allow connection if the pg_type table is missing (#394, #395, @pedrobtz).
  • Fix dbExecute(immediate = TRUE) after dbAppendTable() (#382, #384).

Internal

  • Expand tests for dbConnect(check_interrupts = TRUE) (#385, @zozlak).
  • Ignore extended timestamp tests on i386 (#387).

RPostgres 1.4.3

20 Dec 06:02
Compare
Choose a tag to compare

Features

  • New postgresIsTransacting() (#351, @jakob-r).
  • Temporary tables are now discovered correctly for Redshift() connections, all DBItest tests pass (#358, @galachad).

Internal

  • Make method definition more similar to S3. All setMethod() calls refer to top-level functions (#380).

RPostgres 1.4.2

05 Dec 12:53
Compare
Choose a tag to compare

Features

  • dbWriteTable() uses savepoints for its transactions, even if an external transaction is open. This does not affect Redshift, because savepoints are not supproted there (#342).
  • With dbConnect(check_interrupts = TRUE), interrupting a query now gives a dedicated error message. Very short-running queries no longer take one second to complete (#344).

Bug fixes

  • dbQuoteLiteral() correctly quotes length-0 values (#355) and generates typed NULL expressions for NA values (#357).
  • The SET DATESTYLE query sent after connecting uses quotes for compatibility with CockroachDB (#360).

Internal

  • dbConnect() executes initial queries with immediate = TRUE (#346).
  • Check Postgres starting from version 10 on GitHub Actions (#368).
  • Fix build on Ubuntu 16.04 (#352).
  • Mention libssl-dev in configure script (#350).

RPostgres 1.4.1

27 Sep 17:50
Compare
Choose a tag to compare

Bug fixes

  • Avoid crash by dereferencing 0-size vector (#343).

RPostgres 1.4.0

26 Sep 09:03
Compare
Choose a tag to compare

Features

  • Redshift() connections now adhere to almost all of the DBI specification when connecting to a Redshift cluster. BLOBs are not supported on Redshift, and there are limitations with enumerating temporary and persistent tables (#215, #326).
  • dbBegin(), dbCommit() and dbRollback() gain name argument to support savepoints. An unnamed transaction must be started beforehand (#13).
  • dbWriteTable() uses a transaction (#307).
  • dbSendQuery() gains immediate argument. Multiple queries (separated by semicolons) can be passed in this mode, query parameters are not supported (#272).
  • dbConnect(check_interrupts = TRUE) now aborts a running query faster and more reliably when the user signals an interrupt, e.g. by pressing Ctrl+C (#336).
  • dbAppendTable() gains copy argument. If set to TRUE, data is imported via COPY name FROM STDIN (#241, @hugheylab).
  • Postgres NOTICE messages are now forwarded as proper R messages and can be captured and suppressed (#208).

Bug fixes

  • dbQuoteLiteral() converts timestamp values to input time zone, used when writing tables to Redshift (#325).

Internal

  • Skip timestamp tests on i386 (#318).
  • dbSendQuery() and dbQuoteLiteral() use single dispatch (#320).
  • dbWriteTable() and dbAppendTable() default to copy = NULL, this translates to TRUE for Postgres() and FALSE for Redshift() connections (#329).

Documentation

  • Order help topics on pkgdown site.
  • Use @examplesIf in method documentation.
  • Document when field.types is used in dbWriteTable() (#206).
  • Document setting the tablespace before writing a table (#246).
  • Tweak error message for named params argument to dbBind() (#266).

RPostgres 1.3.3

24 Aug 02:43
Compare
Choose a tag to compare
  • Fix dbConnect(check_interrupts = TRUE) on Windows (#244, @zozlak).
  • Windows: update to libpq 13.2.0 and add UCRT support (#309, @jeroen).

RPostgres 1.3.2

12 Apr 10:13
Compare
Choose a tag to compare
  • Remove BH dependency by inlining the header files (#300).
  • Use Autobrew if libpq is older than version 12 (#294, @jeroen).
  • dbConnect() now issues SET datestyle to iso, mdy to avoid translation errors for datetime values with databases configured differently (#287, @baderstine).