Greg Sabino Mullane wrote:
> Tom Lane wrote:
> > postgres=# set work_mem = '1g';
> > ERROR: invalid value for parameter "work_mem": "1g"
>
> Perhaps this would be a great place for a HINT listing all
> valid inputs, if not there already?
alvherre=# set work_mem = '1g';
ERROR: invalid value for parameter "work_mem": "1g"
HINT: Valid units for this parameter are "kB", "MB", and "GB".
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support