Horton
Menu

Re: JDBC using REFERENCES

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Arbol One <ArbolOne@hotmail.ca>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>, PostGreSQL MailingList <pgsql-general@postgresql.org>
Date: 2024-11-25T02:22:13Z
Lists: pgsql-general 
On Sunday, November 24, 2024, Arbol One <ArbolOne@hotmail.ca> wrote:

>
>
>
>
> *                 sql.append("index SERIAL NOT NULL, ");
> sql.append("id TEXT PRIMARY KEY, ");                 sql.append("CONSTRAIN
> id PRIMARY KEY (id)"); **<== Error*
>
>
>
This is quite confusing, having the index column be serial but not PK (or
even unique…) while the id column is the PK, which you’ve redundantly
specified.

David J.