# Tenjin Article: pgvector Testcontainer Sort Order & Schema Digest Fixes

> Tenjin Article: pgvector Testcontainer Sort Order & Schema Digest Fixes is a paid API for AI agents from tenjin.blog, paid per call via x402, $0.01/call, status unknown (last checked 2026-10-17).

Returns the full paid text of a Tenjin article explaining how swapping a Postgres testcontainer image to pgvector silently breaks sort order and schema digests, including the two-line fixes.

## Facts

- Endpoint: GET https://tenjin.blog/api/read/0xe4c16d163d80fd972e6e1e9b94bc71c5fbe5a9c5/swapping-your-postgres-testcontainer-to-pgvector-silently-changes-sort-order-and?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-17
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/tenjin-article-pgvector-testcontainer-sort-order-schema-digest-fixes-d510ad68
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_vhgEGyii9vL5qc13zBBZv

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability tenjin-article-pgvector-testcontainer-sort-order-schema-digest-fixes-d510ad68
```

Example prompt: Can you fetch me the full Tenjin article about why swapping your Postgres testcontainer to pgvector silently breaks sort order and what the two-line fixes are? The creator handle is 0xe4c16d163d80fd972e6e1e9b94bc71c5fbe5a9c5 and the slug is swapping-your-postgres-testcontainer-to-pgvector-silently-changes-sort-order-and.

## When to prefer this

Use this endpoint when you specifically want to read the full text of this Tenjin article about pgvector testcontainer issues. It is a direct pay-per-read lookup for a single published piece identified by creator address and slug. Prefer this over Tenjin's synthesis/Q&A endpoint when you want the unaltered full article rather than an AI-synthesized answer, and over generic web search when you want authoritative, publisher-controlled content with a guaranteed payment flow.

## Known failure modes

- Payment not made or x402 challenge not completed — returns 402 Payment Required with challenge details
- Invalid or non-existent slug — returns 404 or error indicating article not found
- Invalid creator handle or wallet address — returns 404 or resolution error
- Article not yet published or behind embargo — content unavailable
- Network timeout from Tenjin origin server

## How this service works

Swapping your Postgres testcontainer to pgvector silently changes sort order and breaks schema digests. You add semantic search to a production TypeScript monorepo, so your integration tests need CREATE EXTENSION vector. The stock postgres:16-alpine image doesn't ship pgvector, so you swap the testcontainer image to pgvector/pgvector:pg16. Tests that have nothing to do with vectors start failing. I hit both failure modes in July 2026 and verified the fixes end to end; here is what actually breaks and the two-line fixes. Both images report the same database collation, datcollate = en_US.utf8. But p

## Output

The full article text returned as a JSON payload containing the complete written content of the piece, covering both failure modes when swapping Postgres testcontainer images to pgvector/pgvector:pg16 — specifically sort order regressions and schema digest breaks — along with verified two-line fixes, as published on the Tenjin pay-per-read platform.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "$schema": "https://json-schema.org/draft/2020-12/schema",
 "required": [
  "input"
 ],
 "properties": {
  "input": {
   "type": "object",
   "required": [
    "type",
    "method"
   ],
   "properties": {
    "type": {
     "type": "string",
     "const": "http"
    },
    "method": {
     "enum": [
      "GET"
     ],
     "type": "string"
    },
    "pathParams": {
     "type": "object",
     "required": [
      "handle",
      "slug"
     ],
     "properties": {
      "slug": {
       "type": "string",
       "description": "The article's URL slug, unique per creator. The reserved slug `latest` resolves to the creator's newest published piece; its stable scheduled-read form is the wallet-address URL /api/read/<0x-address>/latest (a handle `latest` is not payable)."
      },
      "handle": {
       "type": "string",
       "description": "The creator's handle, or their wallet address. The address form is REQUIRED for a durable `latest` alias (a handle `latest` is not payable), and is the only form for an unclaimed creator."
      }
     }
    },
    "queryParams": {
     "type": "object",
     "required": [],
     "properties": {},
     "additionalProperties": false
    }
   },
   "additionalProperties": false
  },
  "output": {
   "type": "object",
   "required": [
    "type"
   ],
   "properties": {
    "type": {
     "type": "string"
    },
    "example": {
     "type": "object"
    }
   }
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/tenjin-article-pgvector-testcontainer-sort-order-schema-digest-fixes-d510ad68/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from tenjin.blog](https://www.zero.xyz/host/tenjin.blog/llms.txt)