public inbox for [email protected]  

help / color / mirror / Atom feed

From: Andreas Joseph Krogh <[email protected]>
To: Skelton, Adam J <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Sv: DDL in active production database
Date: Mon, 25 Sep 2023 11:58:56 +0200 (CEST)
Message-ID: <VisenaEmail.a6e.1bf6172a1534952b.18acbc594bb@origo02.app.internal.visena.net> (raw)
In-Reply-To: <VE1PR08MB559746D4BEA543C96A8DB57F81FCA@VE1PR08MB5597.eurprd08.prod.outlook.com>
References: <VE1PR08MB559746D4BEA543C96A8DB57F81FCA@VE1PR08MB5597.eurprd08.prod.outlook.com>



På mandag 25. september 2023 kl. 02:01:28, skrev Skelton, Adam J <
[email protected] <mailto:[email protected]>>:

Hi,



I hope I have the correct group here.



I have a question that I am struggling to find answers for in the 
documentation. Does Postgres have problems with creation / 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 serious issues, SQL server 
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 confidential. 
If you are not the intended recipient, please: (i) delete the message and all 
copies; (ii) do not disclose, distribute or use the message in any manner; and 
(iii) notify the sender immediately. In addition, please be aware that any 
message addressed to our domain is subject to archiving and review by persons 
other than the intended recipient. Thank you.

It will cause problems if you mix DDL and DML when having deferred constraints 
with following updates in the same TX.






--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
[email protected] <mailto:[email protected]>
www.visena.com <https://www.visena.com;
 <https://www.visena.com;

view thread (3+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Sv: DDL in active production database
  In-Reply-To: <VisenaEmail.a6e.1bf6172a1534952b.18acbc594bb@origo02.app.internal.visena.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox