Skip to main content
Archived

Support of global sequences in postgresql

Related products:Integrations
  • August 3, 2020
  • 0 replies
  • 4 views
P

In the postgresql database, I work with sequences that are used by several tables (global). Unfortunately it is not possible to fill with FME data sets and to address the global sequence.

The following error message currently appears if the ID is left blank on the writer:


Bulk copy failed on table 'edit_gbki.spielplatzstammdaten' using delimiter ':'. Error was 'FEHLER: NULL-Wert in Spalte »t_id« verletzt Not-Null-Constraint

DETAIL: Fehlgeschlagene Zeile enthält (null, b474294c-8d3f-4c66-8085-69f59266582d, 15, 210, 1, 2920, Mosergarten Spielplatz, null, ...'

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

Community Stats

32,734
Posts
124,168
Replies
41,231
Members
Terms & ConditionsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.