Add subquery alias to support older versions of Postgres

Open on Drupal.org →

Created on 22 May 2025, 16 days ago

As described here: https://pganalyze.com/blog/5mins-postgres-waiting-for-postgres-16-subque... versions of Postgres prior to 17 required an alias for subqueries. This is the case when I tried using the pgvector Postgres support within Supabase.

Without this patch, doing a query to the VDB gives the error:

ERROR: subquery in FROM must have an alias LINE 1: ...drupal_entity_id","drupal_long_id","content" FROM (SELECT em... ^ HINT: For example, FROM (SELECT ...) [AS] foo.
Of the following exception type:
Drupal\ai_vdb_provider_postgres\Exception\VectorSearchException

I am uploading a simple patch to fix this. After applying the patch it all started working for me.

🐛 Bug report

Status

Active

Version

1.0

Component

Code

Created by

🇺🇸United States mpotter

Live updates comments and jobs are added and updated live.

Sign in to follow issues

Comments & Activities

Issue created by @mpotter
Comment 16 days ago →
🇺🇸United States mpotter
Comment 16 days ago →
🇺🇸United States mpotter

Comment 12 days ago →

822fd4d3 committed on 1.0.x

Issue #3526172 by mpotter: Add subquery alias to support older versions...

Comment 12 days ago →
joshhytr
Hi @mpotter,

Thanks for reporting this issue and taking the time to investigate and provide a fix.

I've been through the documentation you provided and taken a look at the code changes. This all looks good to me.

I've applied the patch to the 1.0.x development branch and am changing this issue status to 'Fixed'.

I aim to release an alpha version with this included later today.

Thanks again,
Josh
Comment 12 days ago →
joshhytr

contrib.social Blog FAQ Discussions

Production build 0.71.5 2024