TIP: Servoy needs to know name of PostgreSQL SEQUENCES

Classic Servoy
1

Hi all,

Thought I would try and save someone a great waste of time.
Scenario:

Create a database in PostgreSQL with a SERIAL primary key.

CREATE SEQUENCE clients_client_id
GO 
CREATE TABLE public.clients ( 
    client_id           	int4 DEFAULT nextval('clients_client_id'),
    client_name         	text NULL,
    client_new_date     	date NULL,
    PRIMARY KEY(client_id)
)
GO

Start up Servoy, connect to DB.
Create a layout based on table and try to edit a record.

If saving the record fails, it may be because Servoy needs to know the name of your sequence! Edit “client_id” in servoy and add the sequence name.