# TIP: Servoy needs to know name of PostgreSQL SEQUENCES

**URL:** <https://forum.servoy.com/t/tip-servoy-needs-to-know-name-of-postgresql-sequences/4032>\
**Category:** Classic Servoy\
**Created:** [April 13, 2005, 12:47pm UTC](https://forum.servoy.com/t/tip-servoy-needs-to-know-name-of-postgresql-sequences/4032 "2005-04-13T12:47:24Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![swingman](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/swingman/32/4536_2.png) [@swingman](https://forum.servoy.com/u/swingman)\
**Post date:** [April 13, 2005, 12:47pm UTC](https://forum.servoy.com/t/tip-servoy-needs-to-know-name-of-postgresql-sequences/4032/1 "2005-04-13T12:47:24Z")

</div>

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.

```auto
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.