PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEV, WEBDEV and WINDEV Mobile

Home | Recent messages | Connect |  | English US
Home → WINDEV 2024 → Identitiy Fields problems with PostgreSQL
Identitiy Fields problems with PostgreSQL
Started by Antonio Díaz, Feb., 02 2024 9:09 PM - 2 replies
#1
Registered member
71 messages
Popularité : +2 (2 votes)
Posted on February, 02 2024 - 9:09 PM
Hi, I am not an experienced windev user (yet). I have a postgresql db. When adding a record through a form, the identity field is not being incremented, so I get the duplicate error (identity field value is 0, the first add was ok since 0 value didn't exist).

I went to pg admin and typed an INSERT statement and the field was incremented without issues. Is there something I should consider in the analysis that I might be missing? I thank you in advance.

--

Antonio Diaz
Emphasys Software, S.C.
#2
Posted on February, 06 2024 - 11:15 AM
Bonjour .

la colonne doit être de type bigserial NOT NULL UNIQUE
Postrges créera la séquence et la contrainte PK
#3
Registered member
71 messages
Popularité : +2 (2 votes)
Posted on February, 07 2024 - 3:51 AM
Thank you, I will try that...

--

Antonio Diaz
Emphasys Software, S.C.
→ Go back to WINDEV 2024