On 9/24/26 2:19 AM, Alban Hertroys wrote:
>
>> On 24 Sep 2026, at 10:24, rob stone <floriparob@tpg.com.au> wrote:
>>
>> Hello,
>>
>> I've been using a single schema in a database for years and I decided
>> to try using multiple schemas in the same database.
>>
>> So, I set up a test database and followed the same procedure that I
>> have used in the past but this time specifying multiple schemas.
>
> …
>
>> show search_path;
>> search_path
>> ----------------
>> "bsmdl, foots"
>> (1 row)
>
> I think there’s your problem. You have schemas named “bsmdl” and “foots”, not a schema named "bsmdl, foots”.
In other words you did:
SET search_path TO 'bsmdl, foots'
and got
SHOW search_path ;
search_path
----------------
"bsmdl, foots"
Instead you should do:
SET search_path TO bsmdl, foots;
to get:
SHOW search_path ;
search_path
--------------
bsmdl, foots
>
> Alban Hertroys
> --
> If you can't see the forest for the trees,
> cut the trees and you'll find there is no forest.
>
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
