# Servoy 3.5 and postgres

**URL:** <https://forum.servoy.com/t/servoy-3-5-and-postgres/8004>\
**Category:** Classic Servoy\
**Created:** [August 13, 2007, 8:22am UTC](https://forum.servoy.com/t/servoy-3-5-and-postgres/8004 "2007-08-13T08:22:24Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![friedrich\_toussaint](https://avatars.discourse-cdn.com/v4/letter/f/73ab20/32.png) [@friedrich\_toussaint](https://forum.servoy.com/u/friedrich_toussaint)\
**Post date:** [August 13, 2007, 8:22am UTC](https://forum.servoy.com/t/servoy-3-5-and-postgres/8004/1 "2007-08-13T08:22:24Z")

</div>

hello everybody,

i have some nice tables with  
Servoy Developer  
Version 3.1.6-build 410  
Java version 1.5.0\_07-87 (Mac OS X)  
PostgreSQL 8.2.3  
and database driven pkeys.  
everthing is working fine.

## last saterday i wanted to migrate to servoy 3.5. wow, everthing is running, but the databse driven pkeys don’t. i get this message from servoy:

## com.servoy.j2db.ApplicationException: Cannot save form data com.servoy.j2db.dataprocessing.DataException: ERROR: relation “asset\_client\_asset\_client\_id\_seq” does not exist

the name of the sequence in postgresql is:  
“seq\_testtable\_id” and (see attach) also in servoy.

if i change “db\_identity” to “db\_seq” and specify the seq to the name above and apply the changes, servoy gets back to “db\_identity”.

can anyone help me?

* * *

## Thanks and best regards, Friedrich Toussaint

## MacBook Pro OS X 10.4.10 2 GB RAM Servoy Developer Version 3.1.6-build 410 / Version 3.5-build 513 Java version 1.5.0\_07-87 (Mac OS X) PostgreSQL 8.2.3

 ![Bild 1.png](https://canada1.discourse-cdn.com/flex010/uploads/servoy/original/1X/4ddd9f8771abb49b16f3930ccdff2473864b67a1.png)

---

<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:** [August 13, 2007, 5:19pm UTC](https://forum.servoy.com/t/servoy-3-5-and-postgres/8004/2 "2007-08-13T17:19:54Z")

</div>

Hi friedrich,

We use database sequences in PostgreSQL (8.2.4) in all out Servoy projects - haven’t tried 3.5 yet. There have been some problems with Servoy and database sequences in the past. try the following:

- make sure the pk fields also have primary key constraints
- I don’t specify the key the way you have done it in the screenshot, I do it by selecting from the ‘Sequence’ popup and use the ‘Specify’ to enter the sequence name, in your case ‘seq\_testtable\_id’

Hope this helps,

---

<div class="post-metadata">

**Author:** ![friedrich\_toussaint](https://avatars.discourse-cdn.com/v4/letter/f/73ab20/32.png) [@friedrich\_toussaint](https://forum.servoy.com/u/friedrich_toussaint)\
**Post date:** [August 14, 2007, 5:13am UTC](https://forum.servoy.com/t/servoy-3-5-and-postgres/8004/3 "2007-08-14T05:13:18Z")

</div>

hallo, christian,

thanks for the answer. i did so in servoy 3.1.6 too, but if i change in 3.5 to db\_seq it returns to db\_identity after storing the value.  
the same thing happens if i change to database value (the correct valuestring automatically is shown in the field)

i don’t have any idea.

* * *

## Thanks and best regards, Friedrich Toussaint

---

<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:** [August 14, 2007, 8:52am UTC](https://forum.servoy.com/t/servoy-3-5-and-postgres/8004/4 "2007-08-14T08:52:22Z")

</div>

What happens if you click the ‘Database Default’ radio button?  
Does this save?

Otherwise this looks like a bug.

---

<div class="post-metadata">

**Author:** ![friedrich\_toussaint](https://avatars.discourse-cdn.com/v4/letter/f/73ab20/32.png) [@friedrich\_toussaint](https://forum.servoy.com/u/friedrich_toussaint)\
**Post date:** [August 14, 2007, 10:23am UTC](https://forum.servoy.com/t/servoy-3-5-and-postgres/8004/5 "2007-08-14T10:23:39Z")

</div>

hallo, christian,

this does also not save. i also think, this is a bug. i’ll post it in Issues and Bugs.

* * *

## many thanks and best regards, Friedrich Toussaint

---

<div class="post-metadata">

**Author:** ![IT2Be](https://avatars.discourse-cdn.com/v4/letter/i/dc4da7/32.png) [@IT2Be](https://forum.servoy.com/u/IT2Be)\
**Post date:** [August 14, 2007, 10:46am UTC](https://forum.servoy.com/t/servoy-3-5-and-postgres/8004/6 "2007-08-14T10:46:51Z")

</div>

Hi Friedrich,

When this is really a bug you’d better add it to the support system (see first post in issues and bugs).

---

<div class="post-metadata">

**Author:** ![friedrich\_toussaint](https://avatars.discourse-cdn.com/v4/letter/f/73ab20/32.png) [@friedrich\_toussaint](https://forum.servoy.com/u/friedrich_toussaint)\
**Post date:** [August 17, 2007, 10:42am UTC](https://forum.servoy.com/t/servoy-3-5-and-postgres/8004/7 "2007-08-17T10:42:19Z")

</div>

thanks Johan Compagner,

he had posted two links to fix the problem with postgresql:

[http://downloads.servoy.com/beta/3xx\_pr … 2dbdev.jar](http://downloads.servoy.com/beta/3xx_product/j2dbdev.jar)  
[http://downloads.servoy.com/beta/3xx\_product/j2db.jar](http://downloads.servoy.com/beta/3xx_product/j2db.jar)

* * *

## Thanks and best regards, Friedrich Toussaint

## MacBook Pro OS X 10.4.10 2 GB RAM Servoy Developer Version 3.1.6-build 410 / Version 3.5-build 513 Java version 1.5.0\_07-87 (Mac OS X) PostgreSQL 8.2.3

---

<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:** [August 17, 2007, 11:24am UTC](https://forum.servoy.com/t/servoy-3-5-and-postgres/8004/8 "2007-08-17T11:24:36Z")

</div>

This discussion moved to

[http://forum.servoy.com/viewtopic.php?t=8953](http://forum.servoy.com/viewtopic.php?t=8953)

(just to save us double-posting in two places 😉