situation:
Symfony 3.2
jsor/doctrine-postgis 1.3 - configured with service and required data type in config
PostgreSQL database with PostGIS extension.
Two schemas:
- geo
- sch1
Schema geo has tabels with geometry.
Schema geo has postgis extension.
Schema geo has views geometry_columns and etc
when I try to run
./bin/console doctrine:mapping:import --force GeoBundle xml
I get errors
[Doctrine\DBAL\Exception\TableNotFoundException]
An exception occurred while executing 'SELECT coord_dimension, srid, type
FROM geometry_columns
WHERE f_table_name = ?
AND f_geometry_column = ?' with params ["boisko", "geom"]:
SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "geometry_columns" does not exist
LINE 2: FROM geometry_columns
&
[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "geometry_columns" does not exist
LINE 2: FROM geometry_columns
&
[PDOException]
SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "geometry_columns" does not exist
LINE 2: FROM geometry_columns
I wonder if anybody had similar problem and could help me out to sort it.
problem was search_path
as soon I set it up everything works as expected