On Wed, 2023-01-04 at 00:43 +0100, Benny Pedersen wrote: > > i have dumped all i have in posgres without data so only structure is > here > > https://usercontent.irccloud-cdn.com/file/WJmDq7xc/spamassassin_dump_tables%20only.txt > > dont know what package means on gentoo, its stable versions i use, > just > not latest stable > > if more info is needed i can provide it
There's enough detail there to make an informed guess about what could be wrong. The tables public.awl and public.txrep contain identical sets of column names, so a reference to any of these column names will be rejected unless it is qualified by referring to it as table_name.column_name Without specifying the fully qualified name, e.g public.awl.email, the database engine can't know which table contains the column that the script its executing is meant to use. Martin