On Sunday, November 24, 2024, Arbol One <arbol...@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.
