Hi all,
While looking at some recent commit related to pgbench I noticed this
example in the docs:
\set aid (1021 * :aid) % (100000 * :scale) + 1
This actually would fail because aid references itself.
Attached is a patch to change this example as follows:
-\set aid (1021 * :aid) % (100000 * :scale) + 1
+\set aid (1021 * :ntellers) % (100000 * :scale) + 1
Regards,
--
Michael
diff --git a/doc/src/sgml/pgbench.sgml b/doc/src/sgml/pgbench.sgml
index ed12e27..22ac371 100644
--- a/doc/src/sgml/pgbench.sgml
+++ b/doc/src/sgml/pgbench.sgml
@@ -769,7 +769,7 @@ pgbench <optional> <replaceable>options</> </optional> <replaceable>dbname</>
Examples:
<programlisting>
\set ntellers 10 * :scale
-\set aid (1021 * :aid) % (100000 * :scale) + 1
+\set aid (1021 * :ntellers) % (100000 * :scale) + 1
</programlisting></para>
</listitem>
</varlistentry>
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
