public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: Igor Korot <[email protected]>
Cc: Adrian Klaver <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: Insert records in the tavke only if they are not exist
Date: Sat, 7 Dec 2024 17:40:19 -0700
Message-ID: <CAKFQuwawwehfZc+XyjdpzD4EU=XS1Xzu6s5fUsyATyDXOWyH3w@mail.gmail.com> (raw)
In-Reply-To: <CA+FnnTxYhzgaFJ97Sx3wuyyFLqsnqyAdqbOc=pnftwD8ZYXYMQ@mail.gmail.com>
References: <CA+FnnTwcNNGsM_ck0ye1OsUN3Jjg94PzGMKRm--2ojJM_zVOMA@mail.gmail.com>
<[email protected]>
<CA+FnnTy7w3jaZCOuMGMMNGySfiTjcHh5D06AUMc+w+i6yoKrMA@mail.gmail.com>
<[email protected]>
<CA+FnnTycFrDX4YRXAaqkijv5dLGCStuDV_nZaBQOe_CHcUKTag@mail.gmail.com>
<[email protected]>
<CA+FnnTxYhzgaFJ97Sx3wuyyFLqsnqyAdqbOc=pnftwD8ZYXYMQ@mail.gmail.com>
On Sat, Dec 7, 2024 at 4:59 PM Igor Korot <[email protected]> wrote:
>
> I am making the tables and naming them with a specific pattern.
>
> Now I'm curious - if I start psql and will want to create a table
> named pg_am, what will happen?
> I presume psql will produce error saying that the system table with
> that name exists and the user can't create ome.
> Am I right?
>
>
You are wasting people's time asking a question like this when it takes but
seconds to experiment.
Most of what you are doing should be considered something to test out and
observe the behavior yourself. Formalize it as a test if possible if you
rely heavily on it so you can be aware if a bug were to be introduced that
broke such a behavior, or even just to get lots of exposure to concurrency
if you are designing a system especially reliant on specific concurrent
behavior.
As it stands the methodology you describe is quite non-traditional for a
relational client-server database system.
David J.
view thread (4+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Insert records in the tavke only if they are not exist
In-Reply-To: <CAKFQuwawwehfZc+XyjdpzD4EU=XS1Xzu6s5fUsyATyDXOWyH3w@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox