[PostGIS] #5790: Postgis-functions in Materialized views fail in Postgres 17 due to not fully qualified search path

[PostGIS]

#5790: Postgis-functions in Materialized views fail in Postgres 17 due to not
fully qualified search path
----------------------+---------------------------
  Reporter:  maxbo    |      Owner:  robe
      Type:  defect   |     Status:  closed
  Priority:  high     |  Milestone:  PostGIS 3.4.4
 Component:  postgis  |    Version:  3.4.x
Resolution:  fixed    |   Keywords:
----------------------+---------------------------
Comment (by landry):

 i've tried your testcase, and it works here. now that i look again at the
 MV definition, something feels.. wrong with the type ?


 {{{
 panoramax=> \d+ public.pictures
 Table "public.pictures"
         Column        |              Type               | Collation |
 Nullable |                     Default                      | Storage  |
 Compression | Stats target | Description
 ----------------------+---------------------------------+-----------+----------+--------------------------------------------------+----------+-------------+--------------+-------------
  id                   | uuid                            |           | not
 null | public.uuid_generate_v4()                        | plain    |
 |              |
  status               | public.picture_status           |           | not
 null | 'waiting-for-process'::public.picture_status     | plain    |
 |              |
  ts                   | timestamp with time zone        |           | not
 null | CURRENT_TIMESTAMP                                | plain    |
 |              |
  heading              | integer                         |           |
 |                                                  | plain    |
 |              |
  metadata             | jsonb                           |           |
 |                                                  | extended |
 |              |
  geom                 | public.geometry(Point,4326)     |           | not
 null |                                                  | main     |
 |              |
  account_id           | uuid                            |           | not
 null |                                                  | plain    |
 |              |
  inserted_at          | timestamp with time zone        |           | not
 null | CURRENT_TIMESTAMP                                | plain    |
 |              |
  processed_at         | timestamp with time zone        |           |
 |                                                  | plain    |
 |              |
  nb_errors            | integer                         |           | not
 null | 0                                                | plain    |
 |              |
  process_error        | character varying               |           |
 |                                                  | extended |
 |              |
  heading_computed     | boolean                         |           | not
 null | false                                            | plain    |
 |              |
  exif                 | jsonb                           |           |
 |                                                  | extended |
 |              |
  preparing_status     | public.picture_preparing_status |           | not
 null | 'not-processed'::public.picture_preparing_status | plain    |
 |              |
  last_account_to_edit | uuid                            |           |
 |                                                  | plain    |
 |              |
  original_content_md5 | uuid                            |           |
 |                                                  | plain    |
 |              |
  upload_set_id        | uuid                            |           |
 |                                                  | plain    |
 |              |
  gps_accuracy_m       | double precision                |           |
 |                                                  | plain    |
 |              |
  h_pixel_density      | integer                         |           |
 |                                                  | plain    |
 |              |
  blurring_id          | character varying               |           |
 |                                                  | extended |
 |              |
  updated_at           | timestamp with time zone        |           |
 | CURRENT_TIMESTAMP                                | plain    |
 |              |
  visibility           | public.visibility_status        |           |
 | 'anyone'::public.visibility_status               | plain    |
 |              |
 Indexes:

 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5790#comment:11>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.