Good morning Experts, I'm so sorry for asking a stupid question in postgres again. I am working on AWS server/Postgresql. When I execute a query for creaing the database and/or from the pgAdmin wizzard, I get an error, " CREATE database cannot run inside a transaction block"Finally, I created a database and when I try to create tablespace, I get the same error that cannot run inside a transaction block. I used to create tablespaces fine before migrate to Postgres 11.x, CREATE TABLESPACE pkihtts_data OWNER "PSmasteruser" LOCATION '/rdsdbdata/db/base/tablespace/pkihtts_data'; or CREATE TABLESPACE pkihtts_data OWNER "PSmasteruser" LOCATION '/rdsdbdata/db/base/tablespace/'; orCREATE TABLESPACE pkihtts_data OWNER "PSmasteruser" LOCATION '/rdsdbdata/'; none of them work. Normally, in Oracle we need to create database, tablespace then username/schema and tables, objects, etc... is the procedure as same as in Postgres? I see the login and schema are totally different in Postgres. any input would appreciated. thank you, Bach-Nga No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold) **Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely rich *** Faithful talent *** Sharing success
