Oleg Ufaev
Oleg Ufaev
@keithf4 > This had been a template table feature before that, but was fixed to just let PG handle this natively in version 4.3. Nothing should have changed for that...
@keithf4, I tried applying the `updates/pg_partman--5.0.1--5.1.0-beta.sql` scripts and found several syntax errors. ### 1. create_partition_id The following error was generated ``` ERROR: syntax error at or near "'i'" LINE 284:...
After that, I re-executed the script with the test table ``` CREATE TABLE public.my_table ( date timestamptz NOT NULL ) PARTITION BY RANGE (date) TABLESPACE my_tablespace; SELECT partman.create_parent( p_parent_table =>...
No worries, happy to help. BTW, I tested changing the behavior of `infinite_time_partitions = true` on empty tables, works as expected and creates as many partitions ahead as specified in...
> BUT for my_table_default partition is still specified pg_default tablespace, which is NOT expected. @keithf4 , I've just checked on the 5.1.0-beta branch, now all partitions have the expected tablespace....
BTW, I had trouble running the update scripts again ### 1. create_partition_id The following error was generated ``` ERROR: syntax error at or near "'i'" LINE 284: WHEN 'i' THEN...
@keithf4, I just checked the upgrade script `pg_partman--5.0.1--5.1.0-beta.sql`, everything went without errors, but there is one critical problem with the inherit_replica_identity function. There is no schema declaration in the creation...
Just checked again - works as expected! Thank you! I'm looking forward to the 5.1 release )