ERROR: trailing junk after numeric literal at or near

 

Error : ERROR:  trailing junk after numeric literal at or near

Solution: Enter/specify the parameter value in "" 

Example: 

postgres=# show work_mem;

 work_mem

----------

 4MB

(1 row)

postgres=# set work_mem = 8MB;

ERROR:  trailing junk after numeric literal at or near "8M"

LINE 1: set work_mem = 8MB;

                       ^

postgres=# set work_mem = "8MB";

SET

postgres=# show work_mem;

 work_mem

----------

 8MB

(1 row)

postgres=#