Thought I would try and save someone a great waste of time.
Scenario:
Create a database in PostgreSQL with a SERIAL primary key.
- Code: Select all
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.
