Symfony PostGIS - db reverse engineering

0
votes

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.

1
doctrine-ormsymfonypostgisreverse-engineering

1 Answers

0
votes

problem was search_path
as soon I set it up everything works as expected