← Browse the extensions catalog

pg-textsearch

Source README ↗

Overview

pg_textsearch is a PostgreSQL extension for full-text search with BM25 relevance ranking. This image supports PostgreSQL 18 on Debian bookworm and trixie.

Package details

Extension version
1.5.1
Image built
Publisher
cnpg-extensions
Build
Debian
Platform
PG 18 · Trixie · amd64

Project links

Links from package metadata, recipe update rules, or reviewed upstream mappings.

Database setup

Required extensions
None specified
SQL installation
CREATE EXTENSION pg_textsearch;
SQL version
1.5.1

PostgreSQL parameters

ParameterValue
shared_preload_libraries'pg_textsearch'
hot_standby_feedbackon

These recipe settings are used in automated smoke tests.

OpenSSF scorecard

The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software.

View information about checks. Automated results are informational only; some categories may not apply to this project.

Scanned · Download cached scan ↓

Dangerous-Workflow10

Determines if the project's GitHub Action workflows avoid dangerous patterns.

Reasoning: no dangerous workflow patterns detected

Check details ↗

Binary-Artifacts10

Determines if the project has generated executable (binary) artifacts in the source repository.

Reasoning: no binaries found in the repo

Check details ↗

Branch-ProtectionUnknown

Determines if the default and release branches are protected with GitHub's branch protection settings.

Reasoning: internal error: error during branchesHandler.setup: internal error: some github tokens can't read classic branch protection rules: https://github.com/ossf/scorecard-action/blob/main/docs/authentication/fine-grained-auth-token.md

Check details ↗

Code-Review2

Determines if the project requires human code review before pull requests (aka merge requests) are merged.

Reasoning: Found 8/30 approved changesets -- score normalized to 2

Check details ↗

Dependency-Update-Tool0

Determines if the project uses a dependency update tool.

Reasoning: no update tool detected

  • Warn: no dependency update tool configurations found

Check details ↗

Maintained10

Determines if the project is "actively maintained".

Reasoning: 30 commit(s) and 11 issue activity found in the last 90 days -- score normalized to 10

Check details ↗

Token-Permissions0

Determines if the project's workflows follow the principle of least privilege.

Reasoning: detected GitHub workflow tokens with excessive permissions

  • Info: jobLevel 'contents' permission set to 'read': .github/workflows/ci.yml:28
  • Warn: topLevel 'contents' permission set to 'write': .github/workflows/benchmark-concurrent-insert.yml:4
  • Warn: topLevel 'deployments' permission set to 'write': .github/workflows/benchmark-concurrent-insert.yml:5
  • Warn: topLevel 'contents' permission set to 'write': .github/workflows/benchmark.yml:4
  • Warn: topLevel 'deployments' permission set to 'write': .github/workflows/benchmark.yml:5
  • Info: topLevel 'contents' permission set to 'read': .github/workflows/chinese-ci.yml:33
  • Warn: no topLevel permission defined: .github/workflows/ci.yml:1
  • Warn: no topLevel permission defined: .github/workflows/coverity.yml:1
  • Warn: no topLevel permission defined: .github/workflows/formatting.yml:1
  • Info: topLevel 'contents' permission set to 'read': .github/workflows/nightly-stress.yml:46
  • Warn: topLevel 'contents' permission set to 'write': .github/workflows/package-release.yml:15
  • Warn: no topLevel permission defined: .github/workflows/pgspot.yml:1
  • Warn: topLevel 'contents' permission set to 'write': .github/workflows/release.yml:10
  • Warn: topLevel 'deployments' permission set to 'write': .github/workflows/release.yml:11
  • Warn: no topLevel permission defined: .github/workflows/sanitizer-build-and-test.yml:1
  • Warn: no topLevel permission defined: .github/workflows/upgrade-tests.yml:1
  • Info: no jobLevel write permissions found

Check details ↗

Vulnerabilities10

Determines if the project has open, known unfixed vulnerabilities.

Reasoning: 0 existing vulnerabilities detected

Check details ↗

Fuzzing0

Determines if the project uses fuzzing.

Reasoning: project is not fuzzed

  • Warn: no fuzzer integrations found

Check details ↗

Pinned-Dependencies0

Determines if the project has declared and pinned the dependencies of its build process.

Reasoning: dependency not pinned by hash detected -- score normalized to 0

  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:56: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:222: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:244: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:405: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1665: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1682: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2219: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2235: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2250: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2265: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2280: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2295: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2310: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2337: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2354: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2626: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2651: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2666: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2681: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2696: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2711: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2726: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2741: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2756: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2771: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2798: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:84: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:351: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:547: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:556: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:867: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:934: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:949: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:964: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:979: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:994: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1009: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1024: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1039: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1054: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1081: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1102: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1421: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1522: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1537: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1552: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1567: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1582: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/chinese-ci.yml:52: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/chinese-ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:705: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:712: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:921: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:934: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:32: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:67: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:277: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:404: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:537: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:597: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:629: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:644: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1006: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1116: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1318: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1380: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/ci.yml:1394: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1402: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1409: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:302: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:311: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/ci.yml:382: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:441: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:451: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1443: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1446: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:956: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/coverity.yml:27: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/coverity.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/formatting.yml:19: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/formatting.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:67: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:112: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:252: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:265: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:281: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:25: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:58: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/package-release.yml:72: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/package-release.yml:77: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:208: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:220: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:256: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:268: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:271: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/pgspot.yml:18: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/pgspot.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/pgspot.yml:21: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/pgspot.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:110: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:196: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:20: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:74: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/release.yml:83: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:50: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:57: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:294: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:307: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/upgrade-tests.yml:36: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/upgrade-tests.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/upgrade-tests.yml:823: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/upgrade-tests.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/upgrade-tests.yml:898: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/upgrade-tests.yml/main?enable=pin
  • Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:2362
  • Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:564
  • Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:1110
  • Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:1690
  • Warn: pipCommand not pinned by hash: .github/workflows/ci.yml:648
  • Warn: pipCommand not pinned by hash: .github/workflows/ci.yml:1452
  • Warn: pipCommand not pinned by hash: .github/workflows/formatting.yml:23
  • Warn: pipCommand not pinned by hash: .github/workflows/pgspot.yml:27
  • Info: 0 out of 70 GitHub-owned GitHubAction dependencies pinned
  • Info: 0 out of 36 third-party GitHubAction dependencies pinned
  • Info: 0 out of 8 pipCommand dependencies pinned

Check details ↗

SAST0

Determines if the project uses static code analysis.

Reasoning: SAST tool is not run on all commits -- score normalized to 0

  • Warn: 0 commits out of 30 are checked with a SAST tool

Check details ↗

Security-Policy10

Determines if the project has published a security policy.

Reasoning: security policy file detected

  • Info: security policy file detected: SECURITY.md:1
  • Info: Found linked content: SECURITY.md:1
  • Info: Found disclosure, vulnerability, and/or timelines in security policy: SECURITY.md:1
  • Info: Found text in security policy: SECURITY.md:1

Check details ↗

CI-Tests9

Determines if the project runs tests before pull requests are merged.

Reasoning: 28 out of 30 merged PRs checked by a CI test -- score normalized to 9

Check details ↗

CII-Best-Practices0

Determines if the project has an OpenSSF (formerly CII) Best Practices Badge.

Reasoning: no effort to earn an OpenSSF best practices badge detected

Check details ↗

Contributors10

Determines if the project has a set of contributors from multiple organizations (e.g., companies).

Reasoning: project has 6 contributing companies or organizations

  • Info: found contributions from: infinilabs, microsoft, nix-rust, timescale, topgrade-rs, which-distro

Check details ↗

License10

Determines if the project has defined a license.

Reasoning: license file detected

  • Info: project has a license file: LICENSE:0
  • Info: FSF or OSI recognized license: PostgreSQL License: LICENSE:0

Check details ↗

Extension recipe
PostgreSQL

License expressions in the shipped package inventory

  • PostgreSQL1 package

Expressions retain AND / OR terms. A package may appear under more than one expression. LicenseRef names refer to custom terms.

Image license files

View files →

1 file read directly from /licenses in the selected image. Browse their original contents and checksums in the Licenses tab.

Evidence

Overview

pg_textsearch is a PostgreSQL extension for full-text search with BM25 relevance ranking. This image supports PostgreSQL 18 on Debian bookworm and trixie.

Package details

Extension version
1.5.1
Image built
Publisher
cnpg-extensions
Build
Debian
Platform
PG 18 · Trixie · arm64

Project links

Links from package metadata, recipe update rules, or reviewed upstream mappings.

Database setup

Required extensions
None specified
SQL installation
CREATE EXTENSION pg_textsearch;
SQL version
1.5.1

PostgreSQL parameters

ParameterValue
shared_preload_libraries'pg_textsearch'
hot_standby_feedbackon

These recipe settings are used in automated smoke tests.

OpenSSF scorecard

The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software.

View information about checks. Automated results are informational only; some categories may not apply to this project.

Scanned · Download cached scan ↓

Dangerous-Workflow10

Determines if the project's GitHub Action workflows avoid dangerous patterns.

Reasoning: no dangerous workflow patterns detected

Check details ↗

Binary-Artifacts10

Determines if the project has generated executable (binary) artifacts in the source repository.

Reasoning: no binaries found in the repo

Check details ↗

Branch-ProtectionUnknown

Determines if the default and release branches are protected with GitHub's branch protection settings.

Reasoning: internal error: error during branchesHandler.setup: internal error: some github tokens can't read classic branch protection rules: https://github.com/ossf/scorecard-action/blob/main/docs/authentication/fine-grained-auth-token.md

Check details ↗

Code-Review2

Determines if the project requires human code review before pull requests (aka merge requests) are merged.

Reasoning: Found 8/30 approved changesets -- score normalized to 2

Check details ↗

Dependency-Update-Tool0

Determines if the project uses a dependency update tool.

Reasoning: no update tool detected

  • Warn: no dependency update tool configurations found

Check details ↗

Maintained10

Determines if the project is "actively maintained".

Reasoning: 30 commit(s) and 11 issue activity found in the last 90 days -- score normalized to 10

Check details ↗

Token-Permissions0

Determines if the project's workflows follow the principle of least privilege.

Reasoning: detected GitHub workflow tokens with excessive permissions

  • Info: jobLevel 'contents' permission set to 'read': .github/workflows/ci.yml:28
  • Warn: topLevel 'contents' permission set to 'write': .github/workflows/benchmark-concurrent-insert.yml:4
  • Warn: topLevel 'deployments' permission set to 'write': .github/workflows/benchmark-concurrent-insert.yml:5
  • Warn: topLevel 'contents' permission set to 'write': .github/workflows/benchmark.yml:4
  • Warn: topLevel 'deployments' permission set to 'write': .github/workflows/benchmark.yml:5
  • Info: topLevel 'contents' permission set to 'read': .github/workflows/chinese-ci.yml:33
  • Warn: no topLevel permission defined: .github/workflows/ci.yml:1
  • Warn: no topLevel permission defined: .github/workflows/coverity.yml:1
  • Warn: no topLevel permission defined: .github/workflows/formatting.yml:1
  • Info: topLevel 'contents' permission set to 'read': .github/workflows/nightly-stress.yml:46
  • Warn: topLevel 'contents' permission set to 'write': .github/workflows/package-release.yml:15
  • Warn: no topLevel permission defined: .github/workflows/pgspot.yml:1
  • Warn: topLevel 'contents' permission set to 'write': .github/workflows/release.yml:10
  • Warn: topLevel 'deployments' permission set to 'write': .github/workflows/release.yml:11
  • Warn: no topLevel permission defined: .github/workflows/sanitizer-build-and-test.yml:1
  • Warn: no topLevel permission defined: .github/workflows/upgrade-tests.yml:1
  • Info: no jobLevel write permissions found

Check details ↗

Vulnerabilities10

Determines if the project has open, known unfixed vulnerabilities.

Reasoning: 0 existing vulnerabilities detected

Check details ↗

Fuzzing0

Determines if the project uses fuzzing.

Reasoning: project is not fuzzed

  • Warn: no fuzzer integrations found

Check details ↗

Pinned-Dependencies0

Determines if the project has declared and pinned the dependencies of its build process.

Reasoning: dependency not pinned by hash detected -- score normalized to 0

  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:56: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:222: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:244: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:405: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1665: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1682: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2219: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2235: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2250: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2265: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2280: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2295: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2310: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2337: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2354: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2626: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2651: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2666: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2681: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2696: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2711: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2726: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2741: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2756: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2771: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2798: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:84: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:351: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:547: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:556: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:867: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:934: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:949: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:964: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:979: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:994: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1009: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1024: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1039: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1054: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1081: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1102: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1421: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1522: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1537: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1552: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1567: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1582: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/chinese-ci.yml:52: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/chinese-ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:705: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:712: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:921: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:934: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:32: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:67: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:277: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:404: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:537: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:597: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:629: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:644: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1006: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1116: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1318: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1380: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/ci.yml:1394: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1402: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1409: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:302: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:311: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/ci.yml:382: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:441: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:451: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1443: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1446: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:956: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/coverity.yml:27: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/coverity.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/formatting.yml:19: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/formatting.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:67: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:112: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:252: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:265: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:281: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:25: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:58: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/package-release.yml:72: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/package-release.yml:77: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:208: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:220: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:256: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:268: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:271: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/pgspot.yml:18: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/pgspot.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/pgspot.yml:21: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/pgspot.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:110: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:196: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:20: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:74: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/release.yml:83: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:50: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:57: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:294: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:307: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/upgrade-tests.yml:36: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/upgrade-tests.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/upgrade-tests.yml:823: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/upgrade-tests.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/upgrade-tests.yml:898: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/upgrade-tests.yml/main?enable=pin
  • Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:2362
  • Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:564
  • Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:1110
  • Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:1690
  • Warn: pipCommand not pinned by hash: .github/workflows/ci.yml:648
  • Warn: pipCommand not pinned by hash: .github/workflows/ci.yml:1452
  • Warn: pipCommand not pinned by hash: .github/workflows/formatting.yml:23
  • Warn: pipCommand not pinned by hash: .github/workflows/pgspot.yml:27
  • Info: 0 out of 70 GitHub-owned GitHubAction dependencies pinned
  • Info: 0 out of 36 third-party GitHubAction dependencies pinned
  • Info: 0 out of 8 pipCommand dependencies pinned

Check details ↗

SAST0

Determines if the project uses static code analysis.

Reasoning: SAST tool is not run on all commits -- score normalized to 0

  • Warn: 0 commits out of 30 are checked with a SAST tool

Check details ↗

Security-Policy10

Determines if the project has published a security policy.

Reasoning: security policy file detected

  • Info: security policy file detected: SECURITY.md:1
  • Info: Found linked content: SECURITY.md:1
  • Info: Found disclosure, vulnerability, and/or timelines in security policy: SECURITY.md:1
  • Info: Found text in security policy: SECURITY.md:1

Check details ↗

CI-Tests9

Determines if the project runs tests before pull requests are merged.

Reasoning: 28 out of 30 merged PRs checked by a CI test -- score normalized to 9

Check details ↗

CII-Best-Practices0

Determines if the project has an OpenSSF (formerly CII) Best Practices Badge.

Reasoning: no effort to earn an OpenSSF best practices badge detected

Check details ↗

Contributors10

Determines if the project has a set of contributors from multiple organizations (e.g., companies).

Reasoning: project has 6 contributing companies or organizations

  • Info: found contributions from: infinilabs, microsoft, nix-rust, timescale, topgrade-rs, which-distro

Check details ↗

License10

Determines if the project has defined a license.

Reasoning: license file detected

  • Info: project has a license file: LICENSE:0
  • Info: FSF or OSI recognized license: PostgreSQL License: LICENSE:0

Check details ↗

Extension recipe
PostgreSQL

License expressions in the shipped package inventory

  • PostgreSQL1 package

Expressions retain AND / OR terms. A package may appear under more than one expression. LicenseRef names refer to custom terms.

Image license files

View files →

1 file read directly from /licenses in the selected image. Browse their original contents and checksums in the Licenses tab.

Evidence

Overview

pg_textsearch is a PostgreSQL extension for full-text search with BM25 relevance ranking. This image supports PostgreSQL 18 on Debian bookworm and trixie.

Package details

Extension version
1.5.1
Image built
Publisher
cnpg-extensions
Build
Debian
Platform
PG 18 · Bookworm · amd64

Project links

Links from package metadata, recipe update rules, or reviewed upstream mappings.

Database setup

Required extensions
None specified
SQL installation
CREATE EXTENSION pg_textsearch;
SQL version
1.5.1

PostgreSQL parameters

ParameterValue
shared_preload_libraries'pg_textsearch'
hot_standby_feedbackon

These recipe settings are used in automated smoke tests.

OpenSSF scorecard

The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software.

View information about checks. Automated results are informational only; some categories may not apply to this project.

Scanned · Download cached scan ↓

Dangerous-Workflow10

Determines if the project's GitHub Action workflows avoid dangerous patterns.

Reasoning: no dangerous workflow patterns detected

Check details ↗

Binary-Artifacts10

Determines if the project has generated executable (binary) artifacts in the source repository.

Reasoning: no binaries found in the repo

Check details ↗

Branch-ProtectionUnknown

Determines if the default and release branches are protected with GitHub's branch protection settings.

Reasoning: internal error: error during branchesHandler.setup: internal error: some github tokens can't read classic branch protection rules: https://github.com/ossf/scorecard-action/blob/main/docs/authentication/fine-grained-auth-token.md

Check details ↗

Code-Review2

Determines if the project requires human code review before pull requests (aka merge requests) are merged.

Reasoning: Found 8/30 approved changesets -- score normalized to 2

Check details ↗

Dependency-Update-Tool0

Determines if the project uses a dependency update tool.

Reasoning: no update tool detected

  • Warn: no dependency update tool configurations found

Check details ↗

Maintained10

Determines if the project is "actively maintained".

Reasoning: 30 commit(s) and 11 issue activity found in the last 90 days -- score normalized to 10

Check details ↗

Token-Permissions0

Determines if the project's workflows follow the principle of least privilege.

Reasoning: detected GitHub workflow tokens with excessive permissions

  • Info: jobLevel 'contents' permission set to 'read': .github/workflows/ci.yml:28
  • Warn: topLevel 'contents' permission set to 'write': .github/workflows/benchmark-concurrent-insert.yml:4
  • Warn: topLevel 'deployments' permission set to 'write': .github/workflows/benchmark-concurrent-insert.yml:5
  • Warn: topLevel 'contents' permission set to 'write': .github/workflows/benchmark.yml:4
  • Warn: topLevel 'deployments' permission set to 'write': .github/workflows/benchmark.yml:5
  • Info: topLevel 'contents' permission set to 'read': .github/workflows/chinese-ci.yml:33
  • Warn: no topLevel permission defined: .github/workflows/ci.yml:1
  • Warn: no topLevel permission defined: .github/workflows/coverity.yml:1
  • Warn: no topLevel permission defined: .github/workflows/formatting.yml:1
  • Info: topLevel 'contents' permission set to 'read': .github/workflows/nightly-stress.yml:46
  • Warn: topLevel 'contents' permission set to 'write': .github/workflows/package-release.yml:15
  • Warn: no topLevel permission defined: .github/workflows/pgspot.yml:1
  • Warn: topLevel 'contents' permission set to 'write': .github/workflows/release.yml:10
  • Warn: topLevel 'deployments' permission set to 'write': .github/workflows/release.yml:11
  • Warn: no topLevel permission defined: .github/workflows/sanitizer-build-and-test.yml:1
  • Warn: no topLevel permission defined: .github/workflows/upgrade-tests.yml:1
  • Info: no jobLevel write permissions found

Check details ↗

Vulnerabilities10

Determines if the project has open, known unfixed vulnerabilities.

Reasoning: 0 existing vulnerabilities detected

Check details ↗

Fuzzing0

Determines if the project uses fuzzing.

Reasoning: project is not fuzzed

  • Warn: no fuzzer integrations found

Check details ↗

Pinned-Dependencies0

Determines if the project has declared and pinned the dependencies of its build process.

Reasoning: dependency not pinned by hash detected -- score normalized to 0

  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:56: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:222: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:244: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:405: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1665: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1682: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2219: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2235: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2250: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2265: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2280: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2295: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2310: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2337: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2354: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2626: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2651: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2666: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2681: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2696: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2711: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2726: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2741: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2756: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2771: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2798: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:84: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:351: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:547: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:556: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:867: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:934: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:949: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:964: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:979: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:994: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1009: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1024: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1039: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1054: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1081: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1102: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1421: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1522: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1537: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1552: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1567: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1582: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/chinese-ci.yml:52: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/chinese-ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:705: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:712: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:921: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:934: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:32: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:67: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:277: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:404: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:537: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:597: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:629: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:644: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1006: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1116: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1318: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1380: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/ci.yml:1394: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1402: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1409: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:302: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:311: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/ci.yml:382: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:441: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:451: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1443: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1446: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:956: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/coverity.yml:27: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/coverity.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/formatting.yml:19: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/formatting.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:67: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:112: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:252: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:265: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:281: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:25: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:58: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/package-release.yml:72: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/package-release.yml:77: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:208: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:220: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:256: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:268: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:271: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/pgspot.yml:18: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/pgspot.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/pgspot.yml:21: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/pgspot.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:110: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:196: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:20: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:74: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/release.yml:83: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:50: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:57: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:294: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:307: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/upgrade-tests.yml:36: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/upgrade-tests.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/upgrade-tests.yml:823: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/upgrade-tests.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/upgrade-tests.yml:898: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/upgrade-tests.yml/main?enable=pin
  • Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:2362
  • Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:564
  • Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:1110
  • Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:1690
  • Warn: pipCommand not pinned by hash: .github/workflows/ci.yml:648
  • Warn: pipCommand not pinned by hash: .github/workflows/ci.yml:1452
  • Warn: pipCommand not pinned by hash: .github/workflows/formatting.yml:23
  • Warn: pipCommand not pinned by hash: .github/workflows/pgspot.yml:27
  • Info: 0 out of 70 GitHub-owned GitHubAction dependencies pinned
  • Info: 0 out of 36 third-party GitHubAction dependencies pinned
  • Info: 0 out of 8 pipCommand dependencies pinned

Check details ↗

SAST0

Determines if the project uses static code analysis.

Reasoning: SAST tool is not run on all commits -- score normalized to 0

  • Warn: 0 commits out of 30 are checked with a SAST tool

Check details ↗

Security-Policy10

Determines if the project has published a security policy.

Reasoning: security policy file detected

  • Info: security policy file detected: SECURITY.md:1
  • Info: Found linked content: SECURITY.md:1
  • Info: Found disclosure, vulnerability, and/or timelines in security policy: SECURITY.md:1
  • Info: Found text in security policy: SECURITY.md:1

Check details ↗

CI-Tests9

Determines if the project runs tests before pull requests are merged.

Reasoning: 28 out of 30 merged PRs checked by a CI test -- score normalized to 9

Check details ↗

CII-Best-Practices0

Determines if the project has an OpenSSF (formerly CII) Best Practices Badge.

Reasoning: no effort to earn an OpenSSF best practices badge detected

Check details ↗

Contributors10

Determines if the project has a set of contributors from multiple organizations (e.g., companies).

Reasoning: project has 6 contributing companies or organizations

  • Info: found contributions from: infinilabs, microsoft, nix-rust, timescale, topgrade-rs, which-distro

Check details ↗

License10

Determines if the project has defined a license.

Reasoning: license file detected

  • Info: project has a license file: LICENSE:0
  • Info: FSF or OSI recognized license: PostgreSQL License: LICENSE:0

Check details ↗

Extension recipe
PostgreSQL

License expressions in the shipped package inventory

  • PostgreSQL1 package

Expressions retain AND / OR terms. A package may appear under more than one expression. LicenseRef names refer to custom terms.

Image license files

View files →

1 file read directly from /licenses in the selected image. Browse their original contents and checksums in the Licenses tab.

Evidence

Overview

pg_textsearch is a PostgreSQL extension for full-text search with BM25 relevance ranking. This image supports PostgreSQL 18 on Debian bookworm and trixie.

Package details

Extension version
1.5.1
Image built
Publisher
cnpg-extensions
Build
Debian
Platform
PG 18 · Bookworm · arm64

Project links

Links from package metadata, recipe update rules, or reviewed upstream mappings.

Database setup

Required extensions
None specified
SQL installation
CREATE EXTENSION pg_textsearch;
SQL version
1.5.1

PostgreSQL parameters

ParameterValue
shared_preload_libraries'pg_textsearch'
hot_standby_feedbackon

These recipe settings are used in automated smoke tests.

OpenSSF scorecard

The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software.

View information about checks. Automated results are informational only; some categories may not apply to this project.

Scanned · Download cached scan ↓

Dangerous-Workflow10

Determines if the project's GitHub Action workflows avoid dangerous patterns.

Reasoning: no dangerous workflow patterns detected

Check details ↗

Binary-Artifacts10

Determines if the project has generated executable (binary) artifacts in the source repository.

Reasoning: no binaries found in the repo

Check details ↗

Branch-ProtectionUnknown

Determines if the default and release branches are protected with GitHub's branch protection settings.

Reasoning: internal error: error during branchesHandler.setup: internal error: some github tokens can't read classic branch protection rules: https://github.com/ossf/scorecard-action/blob/main/docs/authentication/fine-grained-auth-token.md

Check details ↗

Code-Review2

Determines if the project requires human code review before pull requests (aka merge requests) are merged.

Reasoning: Found 8/30 approved changesets -- score normalized to 2

Check details ↗

Dependency-Update-Tool0

Determines if the project uses a dependency update tool.

Reasoning: no update tool detected

  • Warn: no dependency update tool configurations found

Check details ↗

Maintained10

Determines if the project is "actively maintained".

Reasoning: 30 commit(s) and 11 issue activity found in the last 90 days -- score normalized to 10

Check details ↗

Token-Permissions0

Determines if the project's workflows follow the principle of least privilege.

Reasoning: detected GitHub workflow tokens with excessive permissions

  • Info: jobLevel 'contents' permission set to 'read': .github/workflows/ci.yml:28
  • Warn: topLevel 'contents' permission set to 'write': .github/workflows/benchmark-concurrent-insert.yml:4
  • Warn: topLevel 'deployments' permission set to 'write': .github/workflows/benchmark-concurrent-insert.yml:5
  • Warn: topLevel 'contents' permission set to 'write': .github/workflows/benchmark.yml:4
  • Warn: topLevel 'deployments' permission set to 'write': .github/workflows/benchmark.yml:5
  • Info: topLevel 'contents' permission set to 'read': .github/workflows/chinese-ci.yml:33
  • Warn: no topLevel permission defined: .github/workflows/ci.yml:1
  • Warn: no topLevel permission defined: .github/workflows/coverity.yml:1
  • Warn: no topLevel permission defined: .github/workflows/formatting.yml:1
  • Info: topLevel 'contents' permission set to 'read': .github/workflows/nightly-stress.yml:46
  • Warn: topLevel 'contents' permission set to 'write': .github/workflows/package-release.yml:15
  • Warn: no topLevel permission defined: .github/workflows/pgspot.yml:1
  • Warn: topLevel 'contents' permission set to 'write': .github/workflows/release.yml:10
  • Warn: topLevel 'deployments' permission set to 'write': .github/workflows/release.yml:11
  • Warn: no topLevel permission defined: .github/workflows/sanitizer-build-and-test.yml:1
  • Warn: no topLevel permission defined: .github/workflows/upgrade-tests.yml:1
  • Info: no jobLevel write permissions found

Check details ↗

Vulnerabilities10

Determines if the project has open, known unfixed vulnerabilities.

Reasoning: 0 existing vulnerabilities detected

Check details ↗

Fuzzing0

Determines if the project uses fuzzing.

Reasoning: project is not fuzzed

  • Warn: no fuzzer integrations found

Check details ↗

Pinned-Dependencies0

Determines if the project has declared and pinned the dependencies of its build process.

Reasoning: dependency not pinned by hash detected -- score normalized to 0

  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:56: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:222: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:244: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark-concurrent-insert.yml:405: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark-concurrent-insert.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1665: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1682: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2219: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2235: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2250: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2265: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2280: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2295: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2310: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2337: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2354: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2626: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2651: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2666: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2681: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2696: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2711: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2726: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2741: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2756: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2771: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:2798: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:84: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:351: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:547: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:556: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:867: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:934: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:949: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:964: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:979: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:994: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1009: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1024: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1039: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1054: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1081: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1102: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1421: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1522: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1537: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1552: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1567: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/benchmark.yml:1582: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/benchmark.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/chinese-ci.yml:52: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/chinese-ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:705: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:712: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:921: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:934: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:32: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:67: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:277: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:404: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:537: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:597: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:629: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:644: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1006: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1116: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1318: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1380: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/ci.yml:1394: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1402: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1409: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:302: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:311: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/ci.yml:382: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:441: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:451: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1443: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:1446: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/ci.yml:956: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/ci.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/coverity.yml:27: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/coverity.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/formatting.yml:19: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/formatting.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:67: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:112: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:252: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:265: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/nightly-stress.yml:281: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/nightly-stress.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:25: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:58: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/package-release.yml:72: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/package-release.yml:77: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:208: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:220: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:256: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:268: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/package-release.yml:271: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/package-release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/pgspot.yml:18: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/pgspot.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/pgspot.yml:21: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/pgspot.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:110: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:196: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:20: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/release.yml:74: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
  • Warn: third-party GitHubAction not pinned by hash: .github/workflows/release.yml:83: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/release.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:50: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:57: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:294: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/sanitizer-build-and-test.yml:307: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/sanitizer-build-and-test.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/upgrade-tests.yml:36: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/upgrade-tests.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/upgrade-tests.yml:823: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/upgrade-tests.yml/main?enable=pin
  • Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/upgrade-tests.yml:898: update your workflow using https://app.stepsecurity.io/secureworkflow/timescale/pg_textsearch/upgrade-tests.yml/main?enable=pin
  • Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:2362
  • Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:564
  • Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:1110
  • Warn: pipCommand not pinned by hash: .github/workflows/benchmark.yml:1690
  • Warn: pipCommand not pinned by hash: .github/workflows/ci.yml:648
  • Warn: pipCommand not pinned by hash: .github/workflows/ci.yml:1452
  • Warn: pipCommand not pinned by hash: .github/workflows/formatting.yml:23
  • Warn: pipCommand not pinned by hash: .github/workflows/pgspot.yml:27
  • Info: 0 out of 70 GitHub-owned GitHubAction dependencies pinned
  • Info: 0 out of 36 third-party GitHubAction dependencies pinned
  • Info: 0 out of 8 pipCommand dependencies pinned

Check details ↗

SAST0

Determines if the project uses static code analysis.

Reasoning: SAST tool is not run on all commits -- score normalized to 0

  • Warn: 0 commits out of 30 are checked with a SAST tool

Check details ↗

Security-Policy10

Determines if the project has published a security policy.

Reasoning: security policy file detected

  • Info: security policy file detected: SECURITY.md:1
  • Info: Found linked content: SECURITY.md:1
  • Info: Found disclosure, vulnerability, and/or timelines in security policy: SECURITY.md:1
  • Info: Found text in security policy: SECURITY.md:1

Check details ↗

CI-Tests9

Determines if the project runs tests before pull requests are merged.

Reasoning: 28 out of 30 merged PRs checked by a CI test -- score normalized to 9

Check details ↗

CII-Best-Practices0

Determines if the project has an OpenSSF (formerly CII) Best Practices Badge.

Reasoning: no effort to earn an OpenSSF best practices badge detected

Check details ↗

Contributors10

Determines if the project has a set of contributors from multiple organizations (e.g., companies).

Reasoning: project has 6 contributing companies or organizations

  • Info: found contributions from: infinilabs, microsoft, nix-rust, timescale, topgrade-rs, which-distro

Check details ↗

License10

Determines if the project has defined a license.

Reasoning: license file detected

  • Info: project has a license file: LICENSE:0
  • Info: FSF or OSI recognized license: PostgreSQL License: LICENSE:0

Check details ↗

Extension recipe
PostgreSQL

License expressions in the shipped package inventory

  • PostgreSQL1 package

Expressions retain AND / OR terms. A package may appear under more than one expression. LicenseRef names refer to custom terms.

Image license files

View files →

1 file read directly from /licenses in the selected image. Browse their original contents and checksums in the Licenses tab.

Evidence