Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

cannot refresh materialized views when not on public schema #18

Open
balazsdukai opened this issue Aug 18, 2017 · 0 comments
Open

cannot refresh materialized views when not on public schema #18

balazsdukai opened this issue Aug 18, 2017 · 0 comments
Labels
Milestone

Comments

@balazsdukai
Copy link
Member

In R:

attr(ibex_int_space, 'proj4string') <- CRS("+init=epsg:3395")
ltraj2pgtraj(conn_data, ltraj = ibex_int_space, schema = "ibex_traj_materialized_bursts",
             infolocs = TRUE)
rpostgisLT:::createShinyBurstsView(conn_data,"ibex_traj_materialized_bursts")
rpostgisLT:::createShinyStepsView(conn_data, "ibex_traj_materialized_bursts", "ibex_int_space")

Then in DB:

set search_path to ibex_traj_materialized_bursts;
refresh materialized view step_geometry_shiny_ibex_int_space;

Gives:

ERROR:  relation "spatial_ref_sys" does not exist
LINE 1: SELECT proj4text FROM spatial_ref_sys WHERE srid = 3395 LIMI...
                              ^
QUERY:  SELECT proj4text FROM spatial_ref_sys WHERE srid = 3395 LIMIT 1
********** Error **********

ERROR: relation "spatial_ref_sys" does not exist
SQL state: 42P01

It affects the database backup-restore procedure as the same error is thrown when restoring a traj schema. Although the materialized view is restored completely.

@balazsdukai balazsdukai added this to the v1.0.0 milestone Aug 28, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant