MIME-Version: 1.0
From: Igor Korot <ikorot01@gmail.com>
Date: Fri, 6 Dec 2024 21:36:40 -0600
Message-ID: <CA+FnnTwcNNGsM_ck0ye1OsUN3Jjg94PzGMKRm--2ojJM_zVOMA@mail.gmail.com>
Subject: Insert records in the tavke only if they are not exist
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000008be9a80628a5d7b6"
Archived-At: <https://www.postgresql.org/message-id/CA%2BFnnTwcNNGsM_ck0ye1OsUN3Jjg94PzGMKRm--2ojJM_zVOMA%40mail.gmail.com>
Precedence: bulk

--0000000000008be9a80628a5d7b6
Content-Type: text/plain; charset="UTF-8"

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.

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?

Thank you.

--0000000000008be9a80628a5d7b6
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Hi, All,<div dir=3D"auto"><br></div><div dir=3D"auto">Whe=
n my application starts up, ot creates some tables and insert records in th=
em.</div><div dir=3D"auto"><br></div><div dir=3D"auto">When the app starts =
for the second time it should check if the tables and the records in them a=
re exist and skip the process.</div><div dir=3D"auto"><br></div><div dir=3D=
"auto">Everything is good, except what if I have a connection from 2 differ=
ent users?</div><div dir=3D"auto"><br></div><div dir=3D"auto">I can run thi=
s inside transaction, but will this be enough? Will stating transaction loc=
k the DB and the second user will wait for transaction to complete?</div><d=
iv dir=3D"auto"><br></div><div dir=3D"auto">Thank you.</div><div dir=3D"aut=
o"><br></div></div>

--0000000000008be9a80628a5d7b6--