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

pg partionned tables #179

Open
Gis-Druide opened this issue Jul 4, 2023 · 3 comments
Open

pg partionned tables #179

Gis-Druide opened this issue Jul 4, 2023 · 3 comments

Comments

@Gis-Druide
Copy link

good morning Paul,

i am running european cadastre data and i need the partionning feature (attach partition syntax). pg15 postgis 3.3
it seems reading the main table does not work (bounds error in docker logs), but reading a view of the main table works.

thank you for your excellent work.

@pramsey
Copy link
Collaborator

pramsey commented Jul 4, 2023

Would you mind sharing the whole error from the logs?

@Gis-Druide
Copy link
Author

INFO[8356] GET /gouv.cad_parcelle.html method=GET url=/gouv.cad_parcelle.html
INFO[8356] GET /gouv.cad_parcelle.json method=GET url=/gouv.cad_parcelle.json
ERRO[8356] Unable to calculate table bounds
ERROR: could not open file "pg_tblspc/0/PG_13_202007201/0/0": No such file or directory (SQLSTATE 58P01)
INFO[8461] GET /gouv.cad_parcelle_75.html method=GET url=/gouv.cad_parcelle_75.html
INFO[8461] GET /gouv.cad_parcelle_75.json method=GET url=/gouv.cad_parcelle_75.json
INFO[8462] GET /gouv.cad_parcelle_75/12/2073/1408.pbf? method=GET url="/gouv.cad_parcelle_75/12/2073/1408.pbf?"
INFO[8462] GET /gouv.cad_parcelle_75/12/2074/1408.pbf? method=GET url="/gouv.cad_parcelle_75/12/2074/1408.pbf?"
INFO[8863] GET /public.v_cad.html method=GET url=/public.v_cad.html
INFO[8864] GET /public.v_cad.json method=GET url=/public.v_cad.json
WARN[8864] Estimated extent query failed, run 'ANALYZE public.v_cad' event=request key="Estimated extent query failed, run 'ANALYZE public.v_cad'" topic=detail
INFO[8865] GET /public.v_cad/8/129/88.pbf? method=GET url="/public.v_cad/8/129/88.pbf?"
INFO[8865] GET /public.v_cad/8/128/88.pbf? method=GET url="/public.v_cad/8/128/88.pbf?"
INFO[8865] GET /public.v_cad/8/130/88.pbf? method=GET url="/public.v_cad/8/130/88.pbf?"
INFO[8865] GET /public.v_cad/8/128/87.pbf? method=GET url="/public.v_cad/8/128/87.pbf?"
INFO[8865] GET /public.v_cad/8/130/87.pbf? method=GET url="/public.v_cad/8/130/87.pbf?"
INFO[8865] GET /public.v_cad/8/129/87.pbf? method=GET url="/public.v_cad/8/129/87.pbf?"
INFO[8865] GET /public.v_cad/8/131/88.pbf? method=GET url="/public.v_cad/8/131/88.pbf?"
INFO[8865] GET /public.v_cad/8/131/87.pbf? method=GET url="/public.v_cad/8/131/87.pbf?"

in this example, the main table (cad), the child table (cad_75), and the view on main table (v_cad) are correctly referenced into the geometry_columns view.
i have the same log with pg13 and pg15.

@pramsey
Copy link
Collaborator

pramsey commented Jul 4, 2023

Could you also give me the SQL defns of the tables of interest?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants