Limit pgbench COPY FREEZE to ordinary relations
Melanie Plageman <melanieplageman@gmail.com>
Limit pgbench COPY FREEZE to ordinary relations pgbench client-side data generation uses COPY FREEZE to load data for most tables. COPY FREEZE isn't supported for partitioned tables and since pgbench only supports partitioning pgbench_accounts, pgbench used a hard-coded check to skip COPY FREEZE and use plain COPY for a partitioned pgbench_accounts. If the user has manually partitioned one of the other pgbench tables, this causes client-side data generation to error out with: ERROR: cannot perform COPY FREEZE on a partitioned table Fix this by limiting COPY FREEZE to ordinary tables (RELKIND_RELATION). Author: Sergey Tatarintsev <s.tatarintsev@postgrespro.ru> Reviewed-by: Álvaro Herrera <alvherre@alvh.no-ip.org> Discussion: https://postgr.es/m/flat/97f55fca-8a7b-4da8-b413-7d1c57010676%40postgrespro.ru
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/ref/pgbench.sgml | modified | +4 −5 |
| src/bin/pgbench/pgbench.c | modified | +31 −10 |
Documentation touched
Discussion
Cited messages not in the archive:
flat/97f55fca-8a7b-4da8-b413-7d1c57010676@postgrespro.ru