On Tue, 15 Aug 2023 at 08:54, Japin Li <japi...@hotmail.com> wrote: > On Tue, 15 Aug 2023 at 08:49, Andy Fan <zhihui.fan1...@gmail.com> wrote: >>> >>> >>> >>> DROP SCHEMA test_schema; >>> +ERROR: cannot drop schema test_schema because other objects depend on it >>> +DETAIL: collation test_schema.test11 depends on schema test_schema >>> +HINT: Use DROP ... CASCADE to drop the dependent objects too. >>> DROP ROLE regress_test_role; >>> +ERROR: role "regress_test_role" cannot be dropped because some objects >>> depend on it >>> +DETAIL: owner of collation test_schema.test11 >>> +ERROR: role "regress_test_role" cannot be dropped because some objects >>> depend on it >>> +DETAIL: owner of collation test_schema.test11 >>> >>> +ERROR: role "regress_test_role" already exists >>> >>> >>> >>> >> Did you run 'make installcheck' rather than 'make check' and there >> was a failure before this round of test? This looks to me that there >> are some objects are not cleaned well before this run. you can try >> 'make installcheck' with a pretty clean setup or run 'make check' >> directly to verify this. >
Thanks Andy, I think I find the root cause. In my environment, LANG has different setting from others. $ locale LANG=C.UTF-8 LANGUAGE= LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US.UTF-8" LC_MESSAGES="en_US.UTF-8" LC_PAPER="en_US.UTF-8" LC_NAME="en_US.UTF-8" LC_ADDRESS="en_US.UTF-8" LC_TELEPHONE="en_US.UTF-8" LC_MEASUREMENT="en_US.UTF-8" LC_IDENTIFICATION="en_US.UTF-8" LC_ALL=en_US.UTF-8 Then, I set LANG to en_US.UTF-8, all tests passed. What I'm curious about is why PG 15 can pass. -- Regrads, Japin Li