| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Arbol One <ArbolOne(at)hotmail(dot)ca> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, PostGreSQL MailingList <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: JDBC using REFERENCES |
| Date: | 2024-11-25 02:22:13 |
| Message-ID: | CAKFQuwY7jG3+23k6U1Lrs7SsuHjxd4Oy+F_YVz7V4mwJ3+i=ZA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sunday, November 24, 2024, Arbol One <ArbolOne(at)hotmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jayesh thakare | 2024-11-25 05:39:39 | Pg_basebackup failed or completed? |
| Previous Message | Rob Sargent | 2024-11-25 02:21:30 | Re: JDBC using REFERENCES |