Directly associate primary key with user-defined tablespace

2022-12-07 Thread MichaelDBA
Hi all! PG by default always creates the primary key in the default tablespace unless you specify it to use an index that is defined in a user-defined tablespace. We can create indexes in user-defined tablespaces, why can't we create  a primary key in a user-defined tablespace without having

pgadmin4 and scram

2018-10-29 Thread MichaelDBA
I am using pgadmin4 version 3.4 with PG 11.0 and I get this error when I try to connect with scram authorization: User "myuser" does not have a valid SCRAM verifier. How do I get around this? Regards, Michael Vitale