Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tK5M5-006o7A-8H for pgsql-general@arkaria.postgresql.org; Sun, 08 Dec 2024 00:41:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tK5M2-000FgP-Mi for pgsql-general@arkaria.postgresql.org; Sun, 08 Dec 2024 00:40:59 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tK5M2-000FgD-8e for pgsql-general@lists.postgresql.org; Sun, 08 Dec 2024 00:40:59 +0000 Received: from mail-ot1-x32b.google.com ([2607:f8b0:4864:20::32b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tK5M0-001a58-UE for pgsql-general@lists.postgresql.org; Sun, 08 Dec 2024 00:40:58 +0000 Received: by mail-ot1-x32b.google.com with SMTP id 46e09a7af769-71d5476ebb1so1647752a34.2 for ; Sat, 07 Dec 2024 16:40:56 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1733618456; x=1734223256; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=dZGMfT86RhYkFO5RG7PNFhVbBMI/KLNhTDRDsLiJksw=; b=lzplWpB84KUIRzN3zWsFk5Xxf8POP35ZQK4xUNpit2Cjmawr1sMUr4tp/DUP0U5Z2I wpoZlMyevbmse+9dGaiXpv0igblwJTNLA35QhWtdvXybk6WQOiciRewsZ4UykwzvNESi KtoaXeDEdLPoucJjGiolyh3/K6yDenHdZmRi887TQzqoFJ6dAsUqxp4bkPtuEiRBbz8h Iw1LWHodGKtuI0Pt9XlrqeJeTwu7Y8GMQmtv8gkqaoWARXneYdNABcSoCKwhrR71VMDy PiDjkt6nE6k7BJzy5gzHLXebSD9W7JFZgIWsGRSKmcnq6W46I4Yct6B537568Wu4khdF cfHw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1733618456; x=1734223256; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=dZGMfT86RhYkFO5RG7PNFhVbBMI/KLNhTDRDsLiJksw=; b=LKzO5qxhCh7e3o/kmx+gmIuCYhXuYpclysFt46mvncJR+UITNK6l4GH6sRMCs7AWs/ Z/BQ8of0ErTEcv1bGULv4ryTYnAOWTHIpB3xQge4oYalveyxipVP5p6JG4PSH/BSxQC0 B1E1GN6UribpWoVjlfl05lthRNyRIaSAwlm+tOSzCuNDGvAwzPbAJz8Mm1draKoDZ9yn VqUqm1F3SXEfNTTItci78lBsVu/LGUS35Q+ih64LrzP19vs+PnYQL+yAwvfgvIyNG4Jr JsMnA7K8xk4xSCaKcAQzsVPHQuepc4v3MRN3XUX6ppuyd+rMsYHz4qoOM78YodQxj3mp uhHQ== X-Forwarded-Encrypted: i=1; AJvYcCXsiafeCMB2y9+4OuyauhWcVq4lzc3vi0AXE+bXDL8yyGDMAnaZ6FyI/mxFOtAGVQzb/qwHDy8eSy7sv62r@lists.postgresql.org X-Gm-Message-State: AOJu0YzgGLf3mNSKQyer8qzo2jerIyHad3Xd5XyRVpwfPVG9jluro/If g81U9mvJxXqBt7gxjm0pX2mNuoFWSZn7B0KnBADivYCzF+r2dr+bG1yfBVdC9WRdpLbb39EfavS Ytx2MVNz+v8iU0SVfg0Zy8pFJUtpgott+ X-Gm-Gg: ASbGncvuLB5ltb6G9Q+sGrBjiuZQYqgT+mFvY1rPQEenCgJrJHW6WA80LeTtSJd3PtI jpOWZGHVjP/GQVA30S32EuKS95huJtGE= X-Google-Smtp-Source: AGHT+IH70Irrgoh4VeqVVBs5Q7JNOVOeKn1coG3FuQMXp5VnDvpKw7sPcWSYnIZDf+BmKV5jNoWeKza54Sz8YNc5o0Y= X-Received: by 2002:a05:6830:65c1:b0:71d:5812:1595 with SMTP id 46e09a7af769-71dcf53c385mr7216470a34.24.1733618456201; Sat, 07 Dec 2024 16:40:56 -0800 (PST) MIME-Version: 1.0 References: <8770b693-0c44-40de-b883-36cc5e718a0a@aklaver.com> In-Reply-To: From: "David G. Johnston" Date: Sat, 7 Dec 2024 17:40:19 -0700 Message-ID: Subject: Re: Insert records in the tavke only if they are not exist To: Igor Korot Cc: Adrian Klaver , "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000420f3c0628b78091" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000420f3c0628b78091 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sat, Dec 7, 2024 at 4:59=E2=80=AFPM Igor Korot wrot= e: > > 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. --000000000000420f3c0628b78091 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Sat, Dec 7, 2024 at 4:59=E2=80=AFPM Igor Korot <ikorot01@gmail.com> wrote:<= /div>

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= 9;s time asking a question like this when it takes but seconds to experimen= t.

Most of what you are doing should be considered som= ething to test out and observe the=C2=A0behavior yourself.=C2=A0 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=C2= =A0reliant on specific concurrent behavior.

As it stan= ds the methodology you describe is quite non-traditional for a relational c= lient-server database system.

David J.
--000000000000420f3c0628b78091--