Missing "paused" status in stripe-sync-engine enum

[Cerfio]

Bug report

• I confirm this is a bug with Supabase, not with my own application.
• I confirm I have searched the Docs, GitHub Discussions, and Discord.

Describe the bug

The supabase/stripe-sync-engine creates PostgreSQL enums from Stripe's API, but is missing the "paused" subscription status that exists in the official Stripe API. This causes SQL errors when trying to use a valid Stripe status.

To Reproduce

Steps to reproduce the behavior:

1. Use supabase/stripe-sync-engine:v0.41.1 to sync Stripe data to PostgreSQL
2. Check the generated stripe.subscription_status enum values
3. Attempt to insert or query with "paused" status (valid per Stripe docs)
4. Observe error: invalid input value for enum stripe.subscription_status: "paused"

Current enum values (missing "paused"):

SELECT enumlabel FROM pg_enum e 
JOIN pg_type t ON t.oid = e.enumtypid 
WHERE t.typname = 'subscription_status';
-- Returns: trialing, active, canceled, incomplete, incomplete_expired, past_due, unpaid

Expected behavior

The stripe.subscription_status enum should include all valid Stripe subscription statuses, including "paused".

According to Stripe's official documentation, the "paused" status exists:

"The subscription has ended its trial period without a default payment method and the trial_settings.end_behavior.missing_payment_method is set to pause. Invoices are no longer created for the subscription."

Screenshots

N/A - SQL error reproducible via command line

System information

• OS: Docker (Linux container)
• Version of stripe-sync-engine: v0.41.1
• Database: PostgreSQL 16.x
• Deployment: Docker Compose

Additional context

Impact

• Severity: Medium-High
• Business Impact: Cannot use legitimate Stripe "paused" status in database queries
• Affects: Any application using stripe-sync-engine with paused subscriptions

Quick Fix (Community Workaround)

For immediate relief, run this SQL after stripe-sync:

ALTER TYPE stripe.subscription_status ADD VALUE 'paused';

Root Cause

The stripe-sync-engine appears to generate enums based on observed Stripe data rather than the complete Stripe API specification, missing edge case statuses like "paused".

[Cerfio]

Quick Fix – Add "paused" to stripe.subscription_status

Temporary fix until the official migration is merged.
This script safely adds the "paused" status to the stripe.subscription_status enum in PostgreSQL.

---

⚡ Usage

1. Save the script below as fix-paused-status.sh

2. Make it executable:

   chmod +x fix-paused-status.sh

3. Run it:

   ./fix-paused-status.sh

---

📝 Script

#!/bin/bash

# Quick fix script to add "paused" status to stripe.subscription_status enum
# Usage: ./fix-paused-status.sh

set -e

echo "🔧 Quick Fix: Adding 'paused' status to stripe.subscription_status enum"
echo ""

# Database connection details
DB_HOST="localhost"
DB_PORT="5440"
DB_USER="postgres"
DB_PASSWORD="postgres"
DB_NAME="postgres"

echo "📋 Connection details:"
echo "  Host: $DB_HOST:$DB_PORT"
echo "  Database: $DB_NAME"
echo "  User: $DB_USER"
echo ""

# Test database connection
echo "🔍 Testing database connection..."
if PGPASSWORD="$DB_PASSWORD" psql -h "$DB_HOST" -p "$DB_PORT" -U "$DB_USER" -d "$DB_NAME" -c "SELECT 1;" >/dev/null 2>&1; then
    echo "✅ Database connection successful"
else
    echo "❌ Cannot connect to database. Make sure postgres-stripe container is running."
    exit 1
fi

# Check if stripe schema exists
echo ""
echo "🔍 Checking if stripe schema exists..."
if PGPASSWORD="$DB_PASSWORD" psql -h "$DB_HOST" -p "$DB_PORT" -U "$DB_USER" -d "$DB_NAME" -c "SELECT 1 FROM information_schema.schemata WHERE schema_name = 'stripe';" | grep -q "1"; then
    echo "✅ Stripe schema exists"
else
    echo "❌ Stripe schema not found. Run stripe-sync first:"
    exit 1
fi

# Show current enum values
echo ""
echo "📋 Current subscription_status enum values:"
PGPASSWORD="$DB_PASSWORD" psql -h "$DB_HOST" -p "$DB_PORT" -U "$DB_USER" -d "$DB_NAME" -c "
SELECT enumlabel as status
FROM pg_enum e
JOIN pg_type t ON t.oid = e.enumtypid
JOIN pg_namespace n ON n.oid = t.typnamespace
WHERE n.nspname = 'stripe' AND t.typname = 'subscription_status'
ORDER BY e.enumsortorder;
" 2>/dev/null

# Check if "paused" already exists
echo ""
echo "🔍 Checking if 'paused' status already exists..."
if PGPASSWORD="$DB_PASSWORD" psql -h "$DB_HOST" -p "$DB_PORT" -U "$DB_USER" -d "$DB_NAME" -c "
SELECT 1 FROM pg_enum e
JOIN pg_type t ON t.oid = e.enumtypid
JOIN pg_namespace n ON n.oid = t.typnamespace
WHERE n.nspname = 'stripe'
  AND t.typname = 'subscription_status'
  AND e.enumlabel = 'paused';
" 2>/dev/null | grep -q "1"; then
    echo "✅ 'paused' status already exists"
    echo ""
    echo "🎉 Nothing to do – enum already fixed!"
    exit 0
fi

# Add the "paused" value
echo ""
echo "🔧 Adding 'paused' status to the enum..."
if PGPASSWORD="$DB_PASSWORD" psql -h "$DB_HOST" -p "$DB_PORT" -U "$DB_USER" -d "$DB_NAME" -c "ALTER TYPE stripe.subscription_status ADD VALUE 'paused';" 2>/dev/null; then
    echo "✅ Successfully added 'paused' status"
else
    echo "❌ Failed to add 'paused' status. It may already exist or there might be a permission issue."
    exit 1
fi

# Verify result
echo ""
echo "📋 Updated subscription_status enum values:"
PGPASSWORD="$DB_PASSWORD" psql -h "$DB_HOST" -p "$DB_PORT" -U "$DB_USER" -d "$DB_NAME" -c "
SELECT enumlabel as status
FROM pg_enum e
JOIN pg_type t ON t.oid = e.enumtypid
JOIN pg_namespace n ON n.oid = t.typnamespace
WHERE n.nspname = 'stripe' AND t.typname = 'subscription_status'
ORDER BY e.enumsortorder;
" 2>/dev/null

echo ""
echo "🎉 Quick fix applied successfully!"
echo "💡 'paused' status is now available in stripe.subscription_status enum"

---

✅ What This Script Does

• Checks database connectivity
• Ensures stripe schema exists
• Displays current enum values
• Adds "paused" status only if it’s missing
• Verifies that the update was applied

---

⚠️ Note: This is a temporary workaround.
The official migration will include this fix once the PR is merged.

[kevcodez]

Fixed in v0.45.0!