@@ -254,6 +254,11 @@ Set partition creation callback to be invoked for each attached or created parti
254
254
}
255
255
```
256
256
257
+ ``` plpgsql
258
+ set_set_spawn_using_bgw(relation REGCLASS, valueBOOLEAN )
259
+ ```
260
+ When INSERTing new data beyond the partitioning range, use SpawnPartitionsWorker to create new partitions in a separate transaction.
261
+
257
262
##Views and tables
258
263
259
264
####` pathman_config ` --- main config storage
@@ -262,19 +267,18 @@ CREATE TABLE IF NOT EXISTS pathman_config (
262
267
partrel REGCLASSNOT NULL PRIMARY KEY ,
263
268
attnameTEXT NOT NULL ,
264
269
parttypeINTEGER NOT NULL ,
265
- range_intervalTEXT ,
266
-
267
- CHECK (parttypeIN (1 ,2 ))/* check for allowed part types*/ );
270
+ range_intervalTEXT );
268
271
```
269
272
This table stores a list of partitioned tables.
270
273
271
274
####` pathman_config_params ` --- optional parameters
272
275
``` plpgsql
273
276
CREATE TABLE IF NOT EXISTS pathman_config_params (
274
- partrel REGCLASSNOT NULL PRIMARY KEY ,
275
- enable_parentBOOLEAN NOT NULL DEFAULT TRUE,
276
- autoBOOLEAN NOT NULL DEFAULT TRUE,
277
- init_callback REGPROCEDURENOT NULL DEFAULT0 );
277
+ partrel REGCLASSNOT NULL PRIMARY KEY ,
278
+ enable_parentBOOLEAN NOT NULL DEFAULT TRUE,
279
+ autoBOOLEAN NOT NULL DEFAULT TRUE,
280
+ init_callback REGPROCEDURENOT NULL DEFAULT0 ,
281
+ spawn_using_bgwBOOLEAN NOT NULL DEFAULT FALSE);
278
282
```
279
283
This table stores optional parameters which override standard behavior.
280
284