DDL in active production database
От | Skelton, Adam J |
---|---|
Тема | DDL in active production database |
Дата | |
Msg-id | VE1PR08MB559746D4BEA543C96A8DB57F81FCA@VE1PR08MB5597.eurprd08.prod.outlook.com обсуждение исходный текст |
Ответы |
Re: DDL in active production database
Sv: DDL in active production database |
Список | pgsql-sql |
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
В списке pgsql-sql по дате отправления: