Opened 4 years ago

Closed 4 years ago

Last modified 4 years ago

#4551 closed enhancement (fixed)

Regress: Use --schema= option to change were the extension is installed

Reported by: Algunenano Owned by: pramsey
Priority: medium Milestone: PostGIS 3.1.0
Component: postgis Version: master
Keywords: Cc:

Description

Currently the "—schema" option is used to check functions that might access objects or relations in the extension. We should extend it and use it also to install the extension into that schema.

Change History (4)

comment:1 by Algunenano, 4 years ago

The option was added in r17954

comment:2 by strk, 4 years ago

Resolution: fixed
Status: newclosed

In 17971:

[run_test] Use —schema as target for creating and finding postgis

Closes #4551

comment:3 by Algunenano, 4 years ago

Related to this: We should change the files that we load for regress testing and, instead of reading the ones with @extschema@ stripped, we should replace @extschema@ with whatever schema is passed.

That way we can test pgplsql functions with something like:

BEGIN;
SET search_path = pg_catalog;
-- Query with the function
ROLLBACK;

in order to check that is independent on the search_path (e.g. everything is qualified properly)

comment:4 by strk, 4 years ago

Let's go there incrementally, or file a ticket if you prefer

Note: See TracTickets for help on using tickets.