public inbox for [email protected]  

help / color / mirror / Atom feed

From: Ron Johnson <[email protected]>
To: PostGreSQL MailingList <[email protected]>
Subject: Re: Help with syntax error
Date: Sun, 1 Dec 2024 19:18:36 -0500
Message-ID: <CANzqJaBL=OTXbeZfP+r7qPOc3JksmhSZxbN-tSx2Qv=mmWE+LQ@mail.gmail.com> (raw)
In-Reply-To: <BYAPR12MB2808DF98728597CE430A9B3DBA352@BYAPR12MB2808.namprd12.prod.outlook.com>
References: <BYAPR12MB2808DF98728597CE430A9B3DBA352@BYAPR12MB2808.namprd12.prod.outlook.com>

On Sun, Dec 1, 2024 at 7:14 PM Arbol One <[email protected]> wrote:

> 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, CONSTRAINT
> 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'); <= *
> *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.

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

view thread (3+ 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]
  Subject: Re: Help with syntax error
  In-Reply-To: <CANzqJaBL=OTXbeZfP+r7qPOc3JksmhSZxbN-tSx2Qv=mmWE+LQ@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