Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iDClx-0002aV-UL for pgsql-admin@arkaria.postgresql.org; Wed, 25 Sep 2019 19:16:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iDClw-0000g0-EQ for pgsql-admin@arkaria.postgresql.org; Wed, 25 Sep 2019 19:16:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iDClw-0000fl-1r for pgsql-admin@lists.postgresql.org; Wed, 25 Sep 2019 19:16:20 +0000 Received: from mail-wr1-x442.google.com ([2a00:1450:4864:20::442]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iDCls-0007gk-KE for pgsql-admin@postgresql.org; Wed, 25 Sep 2019 19:16:19 +0000 Received: by mail-wr1-x442.google.com with SMTP id r3so8213926wrj.6 for ; Wed, 25 Sep 2019 12:16:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=Ym1LUESmw/jD3y7N0fltaXpFanbnbK3917NrNwNPyMQ=; b=vSDOE5B+N+EKtid8jis2xu1/rBa0xv3eKHzm376wvmLpPwC32MoIiP37dpfOVeXZ1d zyDFGzISGZsm0k01KQezpM0ptP0A+ndtAlSh3DHg5m/5rxt7CFEla+PSp0LNw7xmo1u9 cTaRMg5rxDTsttjUDc0ukS6QmhfnU1IcJxdvWtaKA+nipc2lY1ZUxAZZi6qQQyxm8MpI fEe51+Nmo1ao8iNZ1FS7vFTlqH+kf8X5SjEtOOr6J8X5rvnjQZEDsaVTlIKhyu5VrlRj p5Xs99DQXATog15et/svlCdK0vobwx1MenMqL24JKJfmX98+gKg3+7IihtOMfB7DnWRI 6ZkQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=Ym1LUESmw/jD3y7N0fltaXpFanbnbK3917NrNwNPyMQ=; b=rb/a+ZSoeBB3I6Icb3JGWZADA83m/ZzdNlHHSA19t2ufXcryKb6BpNB4ZxQMhuJ7pV aCWHKlbFvPaCZikaKLV3E/0zoyz1cqd3ykHMBsaAxlaC0TuHkQjCaphXunEyfBGec8FI qi7oF6l4cyu82lDTJ7xjgZ7wb7p+oL7POk0EtW7nYcD/vT9p1DK/1Mu67sYTsoqPz2Q4 Z6HFq5mJxL924JjTSh9Xf2nSrMLyhywT2stpxyresk1bswGeacKIn+iha5ZqXgcZLY8a SI9MyezTbpyCJ2rhjawyf3ChsF9y2n1lC+I/Y/brSUX/WvxF9NO2TMWfN2bfboEGz5wI aQWQ== X-Gm-Message-State: APjAAAWx5/Yf8RKTNgKNmE69WbTPbjFyjiYtk64GpsMX8nZcqbHiAy7t bUhWZsel/kAysaimXz65jTCVGQ== X-Google-Smtp-Source: APXvYqw5bRK1Q4HJLPCtKCN9ZxkYohq5zSN/LAdnSyFSfQbyvEnX0voc/mNf6vCYMG99yp5FcOeIyQ== X-Received: by 2002:a5d:67c3:: with SMTP id n3mr10103784wrw.294.1569438975525; Wed, 25 Sep 2019 12:16:15 -0700 (PDT) Received: from localhost.localdomain (mobiledyn-185-69-244-97.mrsn.at. [185.69.244.97]) by smtp.gmail.com with ESMTPSA id s12sm14347847wra.82.2019.09.25.12.16.14 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 25 Sep 2019 12:16:14 -0700 (PDT) Message-ID: <19fd8930b2fcc8f05737b54c8ec847e486dda687.camel@cybertec.at> Subject: Re: create tablespace - cannot run inside a transaction block From: Laurenz Albe To: Pepe TD Vo , Pgsql-admin , Pgsql-admin Date: Wed, 25 Sep 2019 21:16:13 +0200 In-Reply-To: <1709062667.8516797.1569423052743@mail.yahoo.com> References: <1709062667.8516797.1569423052743.ref@mail.yahoo.com> <1709062667.8516797.1569423052743@mail.yahoo.com> Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.32.4 (3.32.4-1.fc30) MIME-Version: 1.0 Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Wed, 2019-09-25 at 14:50 +0000, Pepe TD Vo wrote: > 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. No, normally you don't create tablespaces in PostgreSQL. They are a few use cases for them, but not many. There is nothing wrong with creating a schema with the same name as the user in PostgreSQL, as long as you make sure that the user owns the schema. Then you have emulated Oracle's behaviour somewhat. Yours, Laurenz Albe -- +43-670-6056265 Cybertec Schönig & Schönig GmbH Gröhrmühlgasse 26, A-2700 Wiener Neustadt Web: https://www.cybertec-postgresql.com