Re: Insert records in the tavke only if they are not exist
| От | David G. Johnston |
|---|---|
| Тема | Re: Insert records in the tavke only if they are not exist |
| Дата | |
| Msg-id | CAKFQuwZmv_R-v5050iF9YynOPqzEzi8atj_w1Sjo6CaNBgZLPg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Insert records in the tavke only if they are not exist (Igor Korot <ikorot01@gmail.com>) |
| Ответы |
Re: Insert records in the tavke only if they are not exist
|
| Список | pgsql-general |
On Friday, December 6, 2024, Igor Korot <ikorot01@gmail.com> wrote:
When my application starts up, ot creates some tables and insert records in them.When the app starts for the second time it should check if the tables and the records in them are exist and skip the process.Everything is good, except what if I have a connection from 2 different users?I can run this inside transaction, but will this be enough? Will stating transaction lock the DB and the second user will wait for transaction to complete?
Seems like letting the create table fail would be a reliable way to determine what is happening. But this procedure overall just seems better avoided. Can’t you just run an installer/updater separate from running the application?
David J.
В списке pgsql-general по дате отправления: