Search Postgresql Archives

Re: Insert records in the tavke only if they are not exist

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 12/6/24 19:36, Igor Korot wrote:
Hi, All,

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.

Does this also apply to starts after the second time?

Is the data expected to change over time?


Everything is good, except what if I have a connection from 2 different users?
Is it possible to have the app start up without external users connecting?


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?

Thank you.


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux