search

plepe / pgsql-partitioning

Partitions a database table by a where clause, or an integer or geometry column
3 stars 0 forks source link

ERROR: relation "partition_tables" does not exist #1

Open capan opened 6 years ago

capan commented 6 years ago

I've created the hstore and postgis extensions, Then I've tried the example script and created marker table. When I try to add a geometry partition on the geometry column I get the error above ?

My script;

create extension postgis
create extension hstore
create table marker (
  title text        not null
);
select AddGeometryColumn('marker', 'way', 900913, 'GEOMETRY', 2);

select partition_geometry_init_table('marker','geom_column=>way, srid=>900913');

Note: I use PostgreSQL10 on Windows10

plepe commented 6 years ago

Hi, wow someone is using this code! Haven't worked on it since 2012, so I can't say if it compatible with newer PostgreSQL.

Did you load the functions.sql and the init.sql files of the module in question (e.g. 'modules/partition')?