Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qkZ2g-00Ex2N-P9 for pgsql-sql@arkaria.postgresql.org; Mon, 25 Sep 2023 00:01:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qkZ2f-00Boie-D1 for pgsql-sql@arkaria.postgresql.org; Mon, 25 Sep 2023 00:01:37 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qkZ2e-00Bohx-NP for pgsql-sql@lists.postgresql.org; Mon, 25 Sep 2023 00:01:37 +0000 Received: from mail-vi1eur04on0700.outbound.protection.outlook.com ([2a01:111:f400:fe0e::700] helo=EUR04-VI1-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qkZ2b-006RuX-6f for pgsql-sql@lists.postgresql.org; Mon, 25 Sep 2023 00:01:35 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=l4OMV2ODA7k/913WH1pSDIqS2uTRRARIl56k9dYS44+WMYkrD53KsjE1GfLZegA38RskILT030BHvHxTS6mGznQOhEPX40kpFshzCxYdeLYUsdiHWsxvYHBEwfGi3sMMffCPrpMfap2IKlHQ2615leA3vk04IvKszIfPQDHZYqFEgmxEoGBPDGhctffztWz5vm3S1Y/nlkCZRTWIaoKVkqoZW89ePBFoIWl5cSAJgYExm27evrzmwZIkH6Kd75a181/mkRVUc1hxFA2+JLQbqOC9jfgBniR4QJoQONOSfZ4FjOMZcCImeg4A3b1ucFCdouzu9vfAKlvY1Lbw/NtHsw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=8+0kYnlwQj2fQ0W5S6/njOZsC4gFpL4QsJy4QT6kVpo=; b=PBf02zTgjaxWMNzhXSJpQkC+0sKJcGGMy/nh1G9wJd92pCIyMeg1Ono2/bbWHY4djjl5ewfKbcuCX0TR0avK2XNPEWsUqSZCX0FP9PGmAQgefHlI0A5MimiVw6wXO4vTzE763jEWQtVhJUqQ7e21/+Glwc8YNOW+M4dOkPiOq+4Y03kdXC3CCuUUIkcC0lW+cthv4QjzIpx5USyKqp736Fk3SRJsxTsfftLmkenQNhcdym0s/XIBoNFSSX1bScfUMHYMLW0BmlXnde+aDkXvgRHHwlU+41B/Gn9sVV9gMmLrJ/Rzy6XWmLYXaB4RV+xmmdB/ff+krWlss3cOKYys5g== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=fisglobal.com; dmarc=pass action=none header.from=fisglobal.com; dkim=pass header.d=fisglobal.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fisglobal.com; s=selector2; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=8+0kYnlwQj2fQ0W5S6/njOZsC4gFpL4QsJy4QT6kVpo=; b=TLnD6kfVFSmoNIhn/58yiX9NMVd8t8i1wyPmnxWdPh8rZDa/Nf+CJfqCwB0eZIHPNur7yGqz6Ls8iXq1vIYNwYQTtFbBROijTlv9VCPRKSGQZUJPY2WNXmGWYZBkDpxwVZwVCzAm53KF5rTjECOzu7wDBkVJ97+SidiRKNNZ8fuWjQs11Tmht+JWbFBio3jweWbRxVXc6bAbyCXICOZubJOUWXGc1PnvhpmUSUNwpZlmZHJRDx6mwKj49hqve68NpooDuLzlMNIO5lrPvpDPIs3m6SgzzEInR9skp5DZDsyFLflVQIwG8sMKjeSPyGILpBqK1TuhzCOY+Lkej9NS3Q== Received: from VE1PR08MB5597.eurprd08.prod.outlook.com (2603:10a6:800:1b3::9) by DU0PR08MB8613.eurprd08.prod.outlook.com (2603:10a6:10:403::7) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6813.28; Mon, 25 Sep 2023 00:01:28 +0000 Received: from VE1PR08MB5597.eurprd08.prod.outlook.com ([fe80::89e9:8bdc:6f63:dcdc]) by VE1PR08MB5597.eurprd08.prod.outlook.com ([fe80::89e9:8bdc:6f63:dcdc%4]) with mapi id 15.20.6813.027; Mon, 25 Sep 2023 00:01:28 +0000 From: "Skelton, Adam J" To: "pgsql-sql@lists.postgresql.org" Subject: DDL in active production database Thread-Topic: DDL in active production database Thread-Index: AdnvQlr4+JmqcrSuTz+MtOwcnXYM4g== Date: Mon, 25 Sep 2023 00:01:28 +0000 Message-ID: Accept-Language: en-NZ, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: MSIP_Label_9e1e58c1-766d-4ff4-9619-b604fc37898b_ActionId=74d36de8-65de-4220-a74e-ad0a6e571185;MSIP_Label_9e1e58c1-766d-4ff4-9619-b604fc37898b_ContentBits=0;MSIP_Label_9e1e58c1-766d-4ff4-9619-b604fc37898b_Enabled=true;MSIP_Label_9e1e58c1-766d-4ff4-9619-b604fc37898b_Method=Standard;MSIP_Label_9e1e58c1-766d-4ff4-9619-b604fc37898b_Name=Internal Use;MSIP_Label_9e1e58c1-766d-4ff4-9619-b604fc37898b_SetDate=2023-09-24T23:42:17Z;MSIP_Label_9e1e58c1-766d-4ff4-9619-b604fc37898b_SiteId=e3ff91d8-34c8-4b15-a0b4-18910a6ac575; authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=fisglobal.com; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: VE1PR08MB5597:EE_|DU0PR08MB8613:EE_ x-ms-office365-filtering-correlation-id: 3981e0bf-fc49-4f44-380a-08dbbd5a914e disclaimersource: eop x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: 2ui1klx40qOHp/uCoSvmmacylWIfZq9MHe4ZwtCm7RB+V2OjbM3Bn3bPogh3IypTqHopyfee2GcVzoUkuAb9pATwYxkH+P6MQHL0AMlwRGKqALx42zw8eKypa0viYtfOyVwpLbusPOSRK4ywFVLRYMxHsR99ZXu8SIsaLpBZpefSQhOgAKf/6BujHlVp1iFDbAnAgMJDSOvBqDnerY2gcbqfSEh+Ngah8BFkG8JWRS0O2KNm06qHcZEc3ZTu9t2UxiNyV5GbLg37IRdkDpBixc2kCMmWrvM+Of9MjiUEg+BPnpcLwedRGFf4tZ7ICU7BaYDaf3IFtWfxem3+QFP8B29TR6SeadEXiNavW82G4fA0fjrHcZMkuacBNigiUEdVTSTyThDF2UPoFdmZpm3N1jNeizszazFc/ES44VLyDZkK7YIHnwfdtcubZIxQTnanAViarBxGwPLxU5PJNHIvo7aavKixyA81ksOkbWvXVZfHbebJkmVwHN5t99x6VDnMCpdI/j8iOWONmugi5pGYuNw+zdk0yVDWuCZqT+9ZG4oEq8iIBfLw8yuxxJzEOM8rgmPEu7x4s2fY/gRFFIlePgiozBsKv5Zwb2znXaKH/sEi07dP+AyU/tBAiYAn2iLTFI4DPeCIfSWs/VETtVU/Gw== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:VE1PR08MB5597.eurprd08.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230031)(39860400002)(346002)(136003)(366004)(396003)(376002)(230922051799003)(186009)(1800799009)(451199024)(7696005)(26005)(6506007)(9686003)(122000001)(38070700005)(38100700002)(82960400001)(86362001)(33656002)(55016003)(83380400001)(8936002)(8676002)(41300700001)(6916009)(316002)(9326002)(64756008)(66946007)(66446008)(66476007)(66556008)(5660300002)(52536014)(76116006)(2906002)(71200400001)(478600001)(130980200001);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?hhFdqeOHg/z3YW7M5T98FmAblcVilyjzDDzzJoTPKO5JnwNil8TLyuiiSqxr?= =?us-ascii?Q?j1CFsZ56ekmV7K28SgHzInuhbQ4Yj5IgL2pt1JkQDFwxDT7T7bf+E5/bbrpJ?= =?us-ascii?Q?/68oEa+M5kr1keg8GZkeMmoBH/mJO5BDReM8CZ8jwkdckuLaykYWb1AFPPo7?= =?us-ascii?Q?Wdu/tze4pUt3Xc9Sn6jT3Fm7k+wCY5rBTJYju458NFe384gQvInnSN1cGwwG?= =?us-ascii?Q?o4uCXX7X7GhXIdhWjJ48uBHxG/Qc6Yl7GZ7neUCTId4FEn8bDCwuaZgR3npV?= =?us-ascii?Q?xIchXPMEn7HRmm2zytApfU7cK+Nnti2681KPRf8yneVv27MhxwIAri2piA0F?= =?us-ascii?Q?PkxcKHUAV+QdXfr1QEhVXD0FgXYskpmynp0yeRHqJ3MVwXlkQhYoLabIS4RD?= =?us-ascii?Q?RcLbmykmNLq8e+0ucwyxcaveoZBBgORVT0Ry5G76dRD8aEHBDi3sYXMzYZIw?= =?us-ascii?Q?Y3VG2YL8e4D6uF68xUlXP8hYYVenULTNEJDX2NsYXb8LDsxwwn2He1SKsWtx?= =?us-ascii?Q?gW36vVY934I1naziW6Q4UmxXL/6jzZLBhO66Aq4DHiJ3EiAT4A0Ld1JMJGEf?= =?us-ascii?Q?MkYkLn1JI9Ebpj786hy6hgZtKg5HYN9FwdiheSkr5pGxx0kMOovF+P4xhRFJ?= =?us-ascii?Q?2LpQZEf9M6sZoeCCTtk/zjxJ9HEIPqg+ZD8BByLDPdxjB2oBlYa918c25plc?= =?us-ascii?Q?N1Xh+pv7RhpDIdV6awXyYXWzYzi1q0FEsw9IUE7SkFGybUPzSeWKfy7f5GvL?= =?us-ascii?Q?0aTMBIlBfmJBYno4dtSxEBXKS7RG0TZJXS9Zy9khJ3djpV2hju7scmgixLmf?= =?us-ascii?Q?sMcX2lCGWd9S/Ev5HzosCaNldQB+SenudUixqutWa4sJ7JuB8jFIAwKhgUB6?= =?us-ascii?Q?N2CjEjuGTN3bJkiIIQwdoDiZjpkR3jmG6rIjEjR0tPS9fDsdEpR7aF1+JBPW?= =?us-ascii?Q?6ehHpEmjyXQRBAHRlkgAPwrVrWmPccN9v46TPoUN4Y5KMX35ic6E0pV7a8DW?= =?us-ascii?Q?lFmhPyLUa4671DJ0v7F9DKGO59QM20kEWFQ7Nrvo90z4h9EXUkocsML4gx1c?= =?us-ascii?Q?I1ewVGMOQbVXsI3M4UbFmNf3ZmtLq2+FQ7dVDz5m/zkVaNGJnkJged4lOf8Q?= =?us-ascii?Q?saD4HdvxzPAec0EuXjM9DZWrgBH4fDART8M4wQxu1qBVGzEl9xyjeIktO8W0?= =?us-ascii?Q?C3WOsK/bXMVGot4l2Q1xwNBSclFaBAbNzJOLxt7V0lf3sBIJHg5Io6SuyvZb?= =?us-ascii?Q?ouNpFSpe8FBS6oTDxmhH2wUfgIvyPfSoUDXb/mE7uHc5cC1oK2fSaUsFgJ6O?= =?us-ascii?Q?J9JIXOePOFdbLkL+N+g+kzWKuCqU95ziGAwaFNMe0bmpJKDpeC699fldFQ6c?= =?us-ascii?Q?ZD1oigwLwhB4doAn6rYYUn0v5pnsuXAjQfGkzwy/mHdScxTHGvZaETyq3+xu?= =?us-ascii?Q?rIbEo1Vaz/VOWVguaSo27m8ICF9NwXnhyOtRuRSQL23Qy+s2tcdEsjyFVuQV?= =?us-ascii?Q?t4U03ZR636qLC2Sf1zfifLEAKI1e03RZP5BYjyqx/9OsBfakS7NBnTASXCbD?= =?us-ascii?Q?guXwvLXfWjCqZ3Tb0WH1TZiBIarDBI0mTEVP63ubMTWKxgNc8S0eMSeHOU7f?= =?us-ascii?Q?fw=3D=3D?= Content-Type: multipart/alternative; boundary="_000_VE1PR08MB559746D4BEA543C96A8DB57F81FCAVE1PR08MB5597eurp_" MIME-Version: 1.0 X-OriginatorOrg: fisglobal.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: VE1PR08MB5597.eurprd08.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 3981e0bf-fc49-4f44-380a-08dbbd5a914e X-MS-Exchange-CrossTenant-originalarrivaltime: 25 Sep 2023 00:01:28.5079 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: e3ff91d8-34c8-4b15-a0b4-18910a6ac575 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: u9jVslmC+lCASqMTX5Ufxlqhs9FBVFfG6QlhsQgYjVHGI7Md5hPNzDmGs9bp79POARewb3ss6+rrC4pb7Djfh1rBs7ueoXI0b5BK0ZpkJaI= X-MS-Exchange-Transport-CrossTenantHeadersStamped: DU0PR08MB8613 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_VE1PR08MB559746D4BEA543C96A8DB57F81FCAVE1PR08MB5597eurp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, I hope I have the correct group here. I have a question that I am struggling to find answers for in the documenta= tion. Does Postgres have problems with creation / changes to database sche= ma objects when the database is actively being used? In particular - rightly or wrongly - our developers want our application to= occasionally issue the following kinds of DDL when it's in active use Alter table ... add column ... Create / drop materialised view ... Create / drop table created with INHERITANCE I know oracle hates this and you can run into some serious issues, SQL serv= er generally lets you away with it. Should we expect problems if we decided to do this in the latest version of= Postgres? Thanks for your time. Adam The information contained in this message is proprietary and/or confidentia= l. If you are not the intended recipient, please: (i) delete the message an= d all copies; (ii) do not disclose, distribute or use the message in any ma= nner; and (iii) notify the sender immediately. In addition, please be aware= that any message addressed to our domain is subject to archiving and revie= w by persons other than the intended recipient. Thank you. --_000_VE1PR08MB559746D4BEA543C96A8DB57F81FCAVE1PR08MB5597eurp_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

 

I hope I have the correct group here.

 

I have a question that I am struggling to find answe= rs for in the documentation.  Does Postgres have problems with creatio= n / changes to database schema objects when the database is actively being = used?

 

In particular – rightly or wrongly – our= developers want our application to occasionally issue the following kinds = of DDL when it’s in active use

 

= Alter table ... add column ...

= Create / drop materialised view ...

= Create / drop table created with INHERITANCE

=  

=  

I know oracle hates this and you can run into some s= erious issues, SQL server generally lets you away with it.  

 

Should we expect problems if we decided to do this i= n the latest version of Postgres?

 

Thanks for your time.

Adam

The information contained in this message is proprietary and/or confidentia= l. If you are not the intended recipient, please: (i) delete the message an= d all copies; (ii) do not disclose, distribute or use the message in any ma= nner; and (iii) notify the sender immediately. In addition, please be aware that any message addressed to ou= r domain is subject to archiving and review by persons other than the inten= ded recipient. Thank you. --_000_VE1PR08MB559746D4BEA543C96A8DB57F81FCAVE1PR08MB5597eurp_--