pg_pathman
pg_pathman copied to clipboard
postgrespro
Partitioning tool for PostgreSQL
## Environments - pg version: 9.6 - os version: windows 10 ## step to reproduce 1. unzip downloaded source code of this repo 2. install make and awk in windows...
the following code /* * HACK: We have to mark each Query with a unique * id in order to recognize them properly. */ #define QUERY_ID_INITIAL 0 static uint64 latest_query_id...
Hi，the latest release version is too old, and contain some bugs such as https://github.com/postgrespro/pg_pathman/issues/230, I have met the same problem on PostgreSQL 13.3, and this problem has been solved on...
### Problem description 1.parent table(90 columns) create table test_t1( id_hbs_sale_order varchar(36) not null default uuid_generate_v4(), ...... pcode varchar(40), ccode varchar(3), status varchar(10), created_by varchar(150) not null default 'system', created_date timestamp(0)...
### Problem description When I execute a use case of pg_pathman on postgresql 12.7, a core file is generated core file： [dytestpg@host-10-57-68-13 corefile]$ gdb /home/dytestpg/postgres/bin/postgres /corefile/core-1625843430-postgres-18236-6 Errors： void heap_insert(Relation relation,...
in master branch: pg_pathman/v1.5.12/src/partition_creation.c:765 The privilege will escalate to superuser and I wonder why this should happen. Normal user can also bypass privilege check in the following function and use...
### env postgresql 12 ### Problem I create a table like ``` create table cycle_flow ( id serial8 primary key not null, order_no serial8 not null default 0, order_time timestamp...
For ubuntu installation postgresql-server-dev-12 packet should be installed to compile pg_pathman
DELETE FROM TEST AS A USING TEST AS T WHERE A.ID =T.ID ERROR: DELETE AND UPDATE QUERIES WITH A JOIN OF PARTITIONED TABLES ARE NOT SUPPORTED
