Error: no such function: jsonb_extract

[nm15336]

Hi,
When trying to query a trial, I get this error:

ctrLoadQueryIntoDb(
 queryterm = "NCT02437890",
 register = "CTGOV2",
 con = db
  )
Not overruling register label CTGOV2
* Found search query from CTGOV2: term=NCT02437890
* Checking trials using CTGOV API 2.0.0.-test, found 1 trials
(1/3) Downloading in 1 batch(es) (max. 1000 trials each; estimate: 0.1 MB total)
(2/3) Converting to NDJSON...
(3/3) Importing records into database...
JSON file #: 1 / 1                               
= Imported or updated 1 trial(s)
Error: no such function: jsonb_extract

I can't find the function jsonb_extract referenced in the source code, or anywhere, and I get the error whether I install from CRAN or build, or use other trial IDs. The sqlite file was built fine in the previous command

db <- nodbi::[src_sqlite](https://docs.ropensci.org/nodbi/reference/src_sqlite.html)(
  dbname = "sqlite_file.sql",
  collection = "test"
)

Do you have any idea why I get this error?

Thanks

[gaborcsardi]

Hi, this is a read only mirror of CRAN, please see the package authors in the DESCRIPTION file. Look for Maintainer, BugReports and URL. Thanks!

[nm15336]

Thanks!