From: Karl Denninger <karl@denninger.net>
To: pgsql-admin@postgresql.org
Subject: Re: Tsearch2 removal bit me - how to correct?
Date: Sun, 15 Oct 2017 11:10:47 -0500
Message-ID: <fa74e1be-c5e2-c610-9ff2-f4cfb44bb1a6@denninger.net> (raw)
In-Reply-To: <f8b749e8-c524-bad4-7a6c-02c7608b0194@denninger.net>
References: <64d687df-3a87-0e4a-e954-f2f23c2581c9@denninger.net>
<19742.1508082461@sss.pgh.pa.us>
<f8b749e8-c524-bad4-7a6c-02c7608b0194@denninger.net>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On 10/15/2017 10:54, Karl Denninger wrote:
>
> On 10/15/2017 10:47, Tom Lane wrote:
>> Karl Denninger <karl@denninger.net> writes:
>>> Attempting to migrate to 10.0 from 9.6, which has had "tsearch2" loaded
>>> for backward compatibility since "forever" (which I suspect is no longer
>>> really required as the capability is internal and has been for a long
>>> time) results in this blowup logged in loadable_libraries.txt:
>>> could not load library "$libdir/tsearch2": ERROR: could not access file
>>> "$libdir/tsearch2": No such file or directory
>>> So what's causing this to be requested on startup and how do I kill it?
>> Look for '$libdir/tsearch2' in the pg_proc.probin column of each
>> DB in the installation ...
>>
>> regards, tom lane
>
> Thanks... found it.
>
> --
New problem -- davical appears to rely on something that got changed to
disallowed....
Oct 15 11:07:08 NewFS postgres[92560]: [5-1] 2017-10-15 11:07:08.473 CDT
[92560]
ERROR: set-returning functions are not allowed in CASE at character 129
Oct 15 11:07:08 NewFS postgres[92560]: [5-2] 2017-10-15 11:07:08.473 CDT
[92560]
HINT: You might be able to move the set-returning function into a
LATERAL FROM
item.
Oct 15 11:07:08 NewFS postgres[92560]: [5-3] 2017-10-15 11:07:08.473 CDT
[92560]
QUERY:
Oct 15 11:07:08 NewFS postgres[92560]: [5-4] SELECT group_id FROM
group_mem
ber WHERE member_id = $1
Oct 15 11:07:08 NewFS postgres[92560]: [5-5] UNION
Oct 15 11:07:08 NewFS postgres[92560]: [5-6] SELECT expanded.g_id
FROM (SEL
ECT CASE WHEN $2 > 0 THEN expand_memberships( group_id, $2 - 1) END AS g_id
Oct 15 11:07:08 NewFS postgres[92560]:
[5-7] F
ROM group_member WHERE member_id = $1) AS expanded
Oct 15 11:07:08 NewFS postgres[92560]: [5-8]
WHERE exp
anded.g_id IS NOT NULL;
Oct 15 11:07:08 NewFS postgres[92560]: [5-9]
Oct 15 11:07:08 NewFS postgres[92560]: [5-10] 2017-10-15 11:07:08.473
CDT [92560
] CONTEXT: SQL function "expand_memberships" during startup
That's a killer until the Davical people work on their code....
--
Karl Denninger
karl@denninger.net <mailto:karl@denninger.net>
/The Market Ticker/
/[S/MIME encrypted email preferred]/
Attachments:
smime.p7s (application/pkcs7-signature, 4.8K) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: karl@denninger.net
Subject: Re: Tsearch2 removal bit me - how to correct?
In-Reply-To: <fa74e1be-c5e2-c610-9ff2-f4cfb44bb1a6@denninger.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox