and whenever I run a simple query "SELECT test_shm_mq(1024, 'a');"
I see the following log 2019-03-11 16:33:17.800 CST [65021] LOG: background worker "test_shm_mq" (PID 65052) exited with exit code 1 does it indicates something wrong? On Mon, Mar 11, 2019 at 4:30 PM Andy Fan <zhihui.fan1...@gmail.com> wrote: > Works, thank you Thomas! I have spent more than 2 hours on this. do you > know which document I miss for this question? > > Thanks > > On Mon, Mar 11, 2019 at 4:05 PM Thomas Munro <thomas.mu...@gmail.com> > wrote: > >> On Mon, Mar 11, 2019 at 8:59 PM Andy Fan <zhihui.fan1...@gmail.com> >> wrote: >> > 4. CREATE EXTENSION test_shm_mq; ==> . could not open extension >> control file "/.../share/postgresql/extension/test_shm_mq.control": No such >> file or directory >> > >> > how can I get it work? Thanks >> >> Hi Andy, >> >> Try this first: >> >> cd src/test/modules/test_shm_mq >> make install >> >> -- >> Thomas Munro >> https://enterprisedb.com >> >