Issue - Embedding NULL - error

[BrenoVentura01]

I have a chatbot project using AI, and I need the embedding column in my knowledge_base table to be populated with an array, but it's currently NULL. My code:

UPDATE public.knowledge_base
SET embedding = (

-- This subquery is where the generate_embedding function was called

SELECT embedding FROM public.generate_embedding(content)

WHERE embedding IS NULL;

and I'm getting this error:

ERROR: P0001: API ERROR EMBEDDING: Status 26 -

[GaryAustin1]

You asked the same question on Discord and probably best to follow up in that thread.

You showed a pretty complex function you are using with pg_net and at a quick glance looks like you are expecting data back. Pg_net is asynchronous and does not return data or status from the http call when you call it. It returns and then when the http request finishes stores the results in net._http_response.

In general though you don't want to call for generating embeds from the database, but instead use edge functions and possibly a queue to deal with errors.