Skip to main content

Changelog for the postgresql adaptor

@openfn/language-postgresql

8.0.2 - 24 February 2026​

Patch Changes​

  • Updated dependencies [856f85c]
    • @openfn/language-common@3.2.3

8.0.1 - 09 February 2026​

Patch Changes​

  • Updated dependencies [8ad6b98]
  • Updated dependencies [8ad6b98]
    • @openfn/language-common@3.2.2

8.0.0 - 30 December 2025​

Major Changes​

  • 9cc4290: - remove callbacks support in all functions

    • add examples for parameterized query statements
    • export cursor and assert from common
    • export util.format from pg-format

    Migration Guide​

    The callback parameter has been removed from all adaptor functions. If you need to perform operations after a function completes, use promise chaining with .then() instead.

    Functions affected:​

    • sql()
    • insert()
    • insertMany()
    • upsert()
    • upsertIf()
    • upsertMany()
    • describeTable()
    • insertTable()
    • modifyTable()

    Examples​

    sql() - Before

    sql(
      { text: 'SELECT * FROM users WHERE id = $1', values: [1] },
      { writeSql: true },
      state => {
        console.log('Query completed:', state.data);
        return state;
      }
    );

    sql() - After

    sql(
      { text: 'SELECT * FROM users WHERE id = $1', values: [1] },
      { writeSql: true }
    ).then(state => {
      console.log('Query completed:', state.data);
      return state;
    });

7.0.7 - 28 November 2025​

Patch Changes​

  • Updated dependencies [cfc66df]
    • @openfn/language-common@3.2.1

7.0.6 - 12 November 2025​

Patch Changes​

  • Updated dependencies [4d7a833]
    • @openfn/language-common@3.2.0

7.0.5 - 04 November 2025​

Patch Changes​

  • Updated dependencies
    • @openfn/language-common@3.1.2

7.0.4 - 16 October 2025​

Patch Changes​

  • Updated dependencies [408a3a2]
    • @openfn/language-common@3.1.1

7.0.3 - 18 September 2025​

Patch Changes​

  • Updated dependencies [e2bc436]
    • @openfn/language-common@3.1.0

7.0.2 - 01 September 2025​

Patch Changes​

  • Updated dependencies [1d60531]
    • @openfn/language-common@3.0.3

7.0.1 - 28 August 2025​

Patch Changes​

  • b7af59a: - Update package.json description to be LLM-readable

7.0.0 - 11 August 2025​

Major Changes​

  • a5cea4e: removed http export from @openfn/language-common

    Migration Guide​

    The http export has been removed from @openfn/language-common. If you were using it, you should remove it from your code and create a new step that uses http adaptor. See example below.

    Before

    Step 1: Fetch and post data using postgresql adaptor

    sql('select * from foo');
    http.post('/example', { body: $.data }),

    Now

    Step 1: Fetch data using postgresql adaptor

    sql('select * from foo');

    Step 2: Post data using http adaptor

    post('/example', { body: $.data });

6.1.2 - 14 July 2025​

Patch Changes​

  • Updated dependencies [9b5a4f8]
    • @openfn/language-common@3.0.2

6.1.1 - 10 July 2025​

Patch Changes​

  • Updated dependencies [cf9c09f]
    • @openfn/language-common@3.0.1

6.1.0 - 10 July 2025​

Minor Changes​

  • 19f2d7e: Exported as() function from common.

Patch Changes​

  • Updated dependencies [ea85695]
  • Updated dependencies [3fce58f]
  • Updated dependencies [19f2d7e]
  • Updated dependencies [f26bd2b]
  • Updated dependencies [19f2d7e]
    • @openfn/language-common@3.0.0

6.0.13 - 20 June 2025​

Patch Changes​

  • Updated dependencies [28c2e8b]
    • @openfn/language-common@2.5.0

6.0.12 - 22 April 2025​

Patch Changes​

  • Updated dependencies [99e4b48]
  • Updated dependencies [13bf08f]
    • @openfn/language-common@2.4.0

6.0.11 - 16 April 2025​

Patch Changes​

  • Updated dependencies [b089c56]
    • @openfn/language-common@2.3.3

6.0.10 - 11 April 2025​

Patch Changes​

  • Updated dependencies [d7105c0]
    • @openfn/language-common@2.3.2

6.0.9 - 14 March 2025​

Patch Changes​

  • Updated dependencies [23ccb01]
    • @openfn/language-common@2.3.1

6.0.8 - 16 January 2025​

Patch Changes​

  • Updated dependencies [b3d7f59]
  • Updated dependencies [2d709ff]
  • Updated dependencies [41e8cc3]
    • @openfn/language-common@2.3.0

6.0.7 - 16 January 2025​

Patch Changes​

  • Updated dependencies [6dffdbd]
    • @openfn/language-common@2.2.1

6.0.6 - 09 January 2025​

Patch Changes​

  • Updated dependencies [a47d8d5]
  • Updated dependencies [9240428]
    • @openfn/language-common@2.2.0

6.0.5 - 28 October 2024​

Patch Changes​

  • Updated docs for each()
  • Updated dependencies
    • @openfn/language-common@2.1.1

6.0.4 - 18 October 2024​

Patch Changes​

  • Updated dependencies [03a1a74]
    • @openfn/language-common@2.1.0

6.0.3 - 15 October 2024​

Patch Changes​

  • Fixed security vulnerability in jsonpath-plus [33973a2]
    • @openfn/language-common@2.0.3

6.0.2 - 24 September 2024​

Patch Changes​

  • Updated dependencies [77a690f]
    • @openfn/language-common@2.0.2

6.0.1 - 16 August 2024​

Patch Changes​

  • 8146c23: Fix typings in package.json
  • Updated dependencies [8146c23]
    • @openfn/language-common@2.0.1

6.0.0 - 01 August 2024​

Major Changes​

  • Export new common http helpers (http namespace)

5.0.2​

Patch Changes​

  • Updated dependencies [4fe527c]
    • @openfn/language-common@2.0.0

5.0.1 - 25 July 2024​

Patch Changes​

  • Updated dependencies [4c08444]
  • Updated dependencies [73d0a02]
    • @openfn/language-common@1.15.1

5.0.0 - 19 June 2024​

Major Changes​

  • 6a4081b8: - Update all operations to use util expandReferences
    • Add findValue result to state

Minor Changes​

  • 5fb82f07: Export group operation from common

Patch Changes​

  • Updated dependencies [5fb82f07]
    • @openfn/language-common@1.15.0

4.2.0 - 13 June 2024​

Minor Changes​

  • 73433c20: Add fnIf operation

Patch Changes​

  • Updated dependencies [106ecf6d]
    • @openfn/language-common@1.14.0

4.1.15 - 11 June 2024​

Patch Changes​

  • Updated dependencies
    • @openfn/language-common@1.13.5

4.1.14 - 21 May 2024​

Patch Changes​

  • Updated dependencies [12f02ed5]
    • @openfn/language-common@1.13.4

4.1.13 - 08 May 2024​

Patch Changes​

  • Updated dependencies [88f99a8f]
    • @openfn/language-common@1.13.3

4.1.12 - 08 May 2024​

Patch Changes​

  • Updated dependencies
    • @openfn/language-common@1.13.2

4.1.11 - 24 April 2024​

Patch Changes​

  • 02ab7a89: - Change host format from uri or ipv4 to string in configuration-schema.json
    • Update required list to include user, password and database

4.1.10 - 12 April 2024​

Patch Changes​

  • Updated dependencies
    • @openfn/language-common@1.13.1

4.1.9 - 12 April 2024​

Patch Changes​

  • Updated dependencies [1ad86651]
    • @openfn/language-common@1.13.0

4.1.8 - 20 September 2023​

Patch Changes​

  • Updated dependencies [c19efbe]
    • @openfn/language-common@1.11.1

4.1.7 - 08 September 2023​

Patch Changes​

  • Updated dependencies [85c35b8]
    • @openfn/language-common@1.11.0

4.1.6 - 14 August 2023​

Patch Changes​

  • Updated dependencies [df09270]
    • @openfn/language-common@1.10.3

4.1.5 - 14 July 2023​

Patch Changes​

  • Updated dependencies [26a303e]
    • @openfn/language-common@1.10.2

4.1.4 - 14 July 2023​

Patch Changes​

  • Updated dependencies [8c32eb3]
    • @openfn/language-common@1.10.1

4.1.3 - 30 June 2023​

Patch Changes​

  • Updated dependencies [aad9549]
    • @openfn/language-common@1.10.0

4.1.2 - 23 June 2023​

Patch Changes​

  • Updated dependencies [111807f]
    • @openfn/language-common@1.9.0

4.1.1 - 19 June 2023​

Patch Changes​

  • Update lock files
  • Updated dependencies
    • @openfn/language-common@1.8.1

4.1.0​

Minor Changes​

  • 2c1d603: Remove parameter reassignment to ensure proper functioning inside an each block; add eslint

    The packages receiving a major bump here exposed functions that didn't work as expected inside each blocks. Users were previously wrapping these functions inside their own custom fn blocks, and this change will ensure that they can be used inside a standard each.

    See https://github.com/OpenFn/adaptors/issues/275 for more details.

Patch Changes​

  • Updated dependencies [2c1d603]
    • @openfn/language-common@1.8.0

4.0.0 - 20 April 2023​

Major Changes​

  • ecd0b53: add optional callback in sql and update response structure

3.4.6 - 31 March 2023​

Patch Changes​

  • Updated dependencies [929bca6]
    • @openfn/language-common@1.7.7

3.4.5 - 30 March 2023​

Patch Changes​

  • 14f481e: mark execute as private
  • Updated dependencies [2b4c61a]
    • @openfn/language-common@1.7.6

3.4.4 - 15 February 2023​

Patch Changes​

  • f2aed32: add examples

3.4.3 - 13 January 2023​

Patch Changes​

  • 6d8de03: change @constructor to @function and remove /*_ @module Adaptor _/

3.4.2 - 11 November 2022​

Patch Changes​

  • f2a91a4: Update package exports
  • Updated dependencies [f2a91a4]
    • @openfn/language-common@1.7.5

3.4.1 - 04 November 2022​

Patch Changes​

  • 8566b26: Fix typings
  • b3d45ff: Fix CJS export of npm package.
  • ecf5d30: remove sinon since it was not being used
  • Updated dependencies [8566b26]
  • Updated dependencies [b3d45ff]
  • Updated dependencies [b5eb665]
  • Updated dependencies [ecf5d30]
    • @openfn/language-common@1.7.4

3.4.0 - 21 October 2022​

Minor Changes​

  • 44ae341: Migrate postgresql

Patch Changes​

  • e04aa28: Rename credential-schema to configuration-schema, update descriptions