Not debuginfo rpm for postgresql96-server package?

2018-09-20 Thread Zexuan Luo
Hello all: Is there any debuginfo rpm package for postgresql96-server package? I searched it on https://yum.postgresql.org/9.6/redhat/rhel-7-x86_64/ and also via 'yum search', but not matched package found. There is the postgresql96-debuginfo package, but it is for the postgresql96 package (the cli

Re: Not debuginfo rpm for postgresql96-server package?

2018-09-20 Thread Zexuan Luo
Finally I found that postgresql96-debuginfo actually contains the debuginfo of the postgres executable. So the postgresql96-debuginfo package contains both the debuginfo of the client and the debuginfo of the server. Zexuan Luo 于2018年9月20日周四 下午6:28写道: > > Hello all: > Is there any debu

Function `set_config` doesn't work in with query?

2019-01-04 Thread Zexuan Luo
For instance: ``` with t as ( select set_config('blah', '1', false) ) select current_setting('blah'); select current_setting('blah'); ``` Execute queries above gets these error messages: psql:test-query-dump.sql:4: ERROR: unrecognized configuration parameter "blah" psql:test-query-dump.sq

Re: Function `set_config` doesn't work in with query?

2019-01-04 Thread Zexuan Luo
Thank you! Something like ``` with t as ( select set_config('ns.blah', '1', false) as res ) select res from t; select current_setting('ns.blah'); ``` works for me. Andrew Gierth 于2019年1月4日周五 下午6:27写道: > > >>>>> "Zexuan"