MIME-Version: 1.0
References: <BYAPR12MB2808DF98728597CE430A9B3DBA352@BYAPR12MB2808.namprd12.prod.outlook.com>
In-Reply-To: <BYAPR12MB2808DF98728597CE430A9B3DBA352@BYAPR12MB2808.namprd12.prod.outlook.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Sun, 1 Dec 2024 19:18:36 -0500
Message-ID: <CANzqJaBL=OTXbeZfP+r7qPOc3JksmhSZxbN-tSx2Qv=mmWE+LQ@mail.gmail.com>
Subject: Re: Help with syntax error
To: PostGreSQL MailingList <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000fa495206283e7dc2"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaBL%3DOTXbeZfP%2Br7qPOc3JksmhSZxbN-tSx2Qv%3DmmWE%2BLQ%40mail.gmail.com>
Precedence: bulk

--000000000000fa495206283e7dc2
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sun, Dec 1, 2024 at 7:14=E2=80=AFPM Arbol One <ArbolOne@hotmail.ca> wrot=
e:

> I have these tables:
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> *CREATE TABLE IF NOT EXISTS registrar ( index SERIAL, registrar_id TEXT,
> day TEXT NOT NULL, month TEXT NOT NULL, year TEXT NOT NULL, hour TEXT NOT
> NULL, minute TEXT NOT NULL, second TEXT NOT NULL, millisecond TEXT NOT
> NULL, am_pm TEXT NOT NULL, admin BOOLEAN NOT NULL DEFAULT false, CONSTRAI=
NT
> key PRIMARY KEY (registrar_id) ); CREATE TABLE IF NOT EXISTS user_name (
> user_name_id TEXT PRIMARY KEY REFERENCES registrar(registrar_id),
> first_name TEXT NOT NULL, middle_name TEXT NOT NULL, last_name TEXT NOT
> NULL);*
>
> When I enter the following pg commands :
>
>
> *INSERT INTO registrar VALUES (DEFAULT, '18551420601012L23', '1', '12',
> '2024', '18', '55', '14', '207', 'PM'); INSERT INTO user_name
> '18551420601012L23', 'John', 'Fitzgerald', 'Kennedy'); <=3D *
> *UserNameTable.write()*
>
> I get this message :
>
>
>
>
> *Exception in thread "main" java.sql.SQLException: In
> company.contact.Company$UserNameTable.write() ERROR: syntax error at or
> near "'18551420601012L23'"   Position: 23 *
>
> The error is in the user_name_id, which is a primary that references the
> table "*registrar*" 's "*registrar_id" *primary key.
> According to the documentation
> <https://www.postgresql.org/docs/current/tutorial-fk.html>, the insertion
> should be OK, no?
>
> What am I doing wrong?
>

What happens when you run those INSERT commands directly in psql?

Hint: it's probably going to complain about a syntax error in the second
INSERT statement.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Sun, Dec 1, 2024 at 7:14=E2=80=AFPM Ar=
bol One &lt;<a href=3D"mailto:ArbolOne@hotmail.ca">ArbolOne@hotmail.ca</a>&=
gt; wrote:</div><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote=
" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);=
padding-left:1ex"><u></u>

 =20
  <div style=3D"padding-bottom:1px">
    <p><font face=3D"Helvetica, Arial, sans-serif">I have these tables:</fo=
nt></p>
    <p><font face=3D"Helvetica, Arial, sans-serif"><b>CREATE TABLE IF NOT
          EXISTS registrar (<br>
          index SERIAL, <br>
          registrar_id TEXT, <br>
          day TEXT NOT NULL, <br>
          month TEXT NOT NULL, <br>
          year TEXT NOT NULL, <br>
          hour TEXT NOT NULL, <br>
          minute TEXT NOT NULL, <br>
          second TEXT NOT NULL, <br>
          millisecond TEXT NOT NULL, <br>
          am_pm TEXT NOT NULL, <br>
          admin BOOLEAN NOT NULL DEFAULT false, <br>
          CONSTRAINT key PRIMARY KEY (registrar_id) );<br>
          <br>
          CREATE TABLE IF NOT EXISTS user_name (<br>
          user_name_id TEXT PRIMARY KEY REFERENCES
          registrar(registrar_id),<br>
          first_name TEXT NOT NULL,<br>
          middle_name TEXT NOT NULL, <br>
          last_name TEXT NOT NULL);</b></font></p>
    <p><font face=3D"Helvetica, Arial, sans-serif">When I enter the
        following pg commands :</font></p>
    <p><font face=3D"Helvetica, Arial, sans-serif"><b>INSERT INTO
          registrar VALUES (DEFAULT, &#39;18551420601012L23&#39;, &#39;1=
9;, &#39;12&#39;,
          &#39;2024&#39;, &#39;18&#39;, &#39;55&#39;, &#39;14&#39;, &#39;20=
7&#39;, &#39;PM&#39;);<br>
          INSERT INTO user_name &#39;18551420601012L23&#39;, &#39;John&#39;=
,
          &#39;Fitzgerald&#39;, &#39;Kennedy&#39;); &lt;=3D </b></font><fon=
t face=3D"Helvetica, Arial, sans-serif"><b><i>UserNameTable.write()</i></b>=
</font></p>
    <p><font face=3D"Helvetica, Arial, sans-serif">I get this message :</fo=
nt></p>
    <p><font face=3D"Helvetica, Arial, sans-serif"><b><i>Exception in
            thread &quot;main&quot; java.sql.SQLException: In
            company.contact.Company$UserNameTable.write()<br>
            ERROR: syntax error at or near &quot;&#39;18551420601012L23&#39=
;&quot;<br>
            =C2=A0 Position: 23</i><br>
        </b></font></p>
    <p><font face=3D"Helvetica, Arial, sans-serif">The error is in the
        user_name_id, which is a primary that references the table &quot;<b=
>registrar</b>&quot;
        &#39;s &quot;</font><font face=3D"Helvetica, Arial, sans-serif"><b>=
registrar_id&quot;
        </b></font><font face=3D"Helvetica, Arial, sans-serif">primary
        key.<br>
        According to the <a href=3D"https://www.postgresql.org/docs/current=
/tutorial-fk.html" target=3D"_blank">documentation</a>,
        the insertion should be OK, no?<br>
      </font></p>
    <p><font face=3D"Helvetica, Arial, sans-serif">What am I doing wrong?<b=
r></font></p></div></blockquote><div></div></div><div><br></div><div>What h=
appens when you run those INSERT commands directly in psql?</div><div><br><=
/div><div>Hint: it&#39;s probably going to complain about a syntax error in=
 the second INSERT statement.</div><div><br></div><span class=3D"gmail_sign=
ature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div=
 dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boi=
l me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div></di=
v></div></div></div></div>

--000000000000fa495206283e7dc2--