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
