"Christian Sengstock" <csengstock@xxxxxxxxx> writes: > does that mean a prior "SET search_path =3D geo, pg_catalog;" would create = > the > function inside of the geo schema ? i have this setting but it's not workin= > g > for me, despite the function is in the public schema. > i use /> psql -d mydb -U user -f restore.sql > to restore it. Could the behaviour be different when using 'pg_restore' ? Shouldn't be different. Can you provide a test case? regards, tom lane
