Collected from the PG bugs email list.
|Reported by||pg user|
Body of first available message related to this bug follows.
The following bug has been logged on the website: Bug reference: 16464 Logged by: pg user Email address: (redacted) PostgreSQL version: 12.3 Operating system: Centos 6 Description: Hello, Restoring from pg_dump fails if you have a table with expression based index where a stored function calls another function. Ex. SQL with steps to reproduce: https://pastebin.com/raw/CFgxtwSY Related to: https://wiki.postgresql.org/wiki/A_Guide_to_CVE-2018-1058:_Protect_Your_Search_Path Workaround: Removing "SELECT pg_catalog.set_config('search_path', '', false);" from the sql dump.
|2020-05-26 17:00:38+00||PG Bug reporting form||BUG #16464: Unable to restore database backed up with pg_dump into sql that contains expression based index|
|2020-05-26 17:53:54+00||"David G(dot) Johnston"||Re: BUG #16464: Unable to restore database backed up with pg_dump into sql that contains expression based index|