LIKE search in bytea datatype (PostgreSQL)

4 votes

3 answers

7968 views

                          Table:

    \d blob
                                         
     Column  |       Type   | Collation |                 Default                  
    ---------+--------------+-----------+------------------------------------------
     id      | integer      |           | nextval('modlink_blob_id_seq'::regclass)
     content | bytea        |           | 

This statement:

    SELECT COUNT(*) "job" INNER JOIN "blob" ON ("job"."input_id" = "blob"."id")
      WHERE UPPER("blob"."content"::text) LIKE UPPER('%csv%');

Error message:

    ERROR:  invalid memory alloc request size 1989028364

What can I do to make this statement not fail?

Asked by guettli (1591 rep)

Oct 15, 2018, 01:35 PM
Last activity: Jul 30, 2025, 01:07 PM

LIKE search in bytea datatype (PostgreSQL)

Related Questions