Postgresql alter table column size8/12/2023 ![]() ![]() ![]() In Openbravo you are able to change the size of a column. In case you are working with configuration scripts or templates on a regular basis, the following link to an article might be of interest to you, since it describes how to create a configuration script. It enables the user to have a certain amount of flexibility within his/her database.īefore reading this guide, it is necessary to have a proper understanding of Openbravo's Modularity concept and how to create and package a module,Īs we take the knowledge from these articles as a given in this guide. If we are working with a large or busy database, or we just want to have some extra assurances that we will not lose data, I prefer simply adding a new column rather than changing the type of an existing one.The objective of this article is to show you how to change the size of a column inside the database. ![]() An Alternative to Changing Column Type in PostgreSQL - Adding a New Column InsteadĬhanging a column type is fairly simple, but for a large database with millions of records and a lot of concurrent queries it is also very expensive because of the ACCESS EXCLUSIVE table lock. Honestly it’s hard to know for certain if a table lock will be required by just looking through documentation.įear not, there is an alternative. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |