Hi Erik, I thought about using UUIDs too for some time, but decided against it for now. So I guess this is not really a solution for me. But thanks for the hint :-)
Sven. Am Montag, 14. März 2016 10:57:09 UTC+1 schrieb Erik Assum: > > Just doing some of the same, but I have a table def like > > CREATE TABLE ghost_channel (id UUID PRIMARY KEY DEFAULT > uuid_generate_v4(), name text > Which seems to generate keys for me. > > Maybe you could do something like that with your sequence as well? > > Erik. > > On 14. mar. 2016, at 10.53, 'Sven Richter' via Clojure < > clo...@googlegroups.com <javascript:>> wrote: > > > > Hi, > > > > I am using joplin (which depends on ragtime) migrate and seed my > postgresql database. One of my migration files looks like this: > > > > CREATE TABLE tags ( > > id SERIAL PRIMARY KEY, > > name VARCHAR(150)) > > --;; > > INSERT INTO tags ("name", "id") VALUES > > ('Java', '1') > > > > Running a migration creates the table and inserts the entry. But what it > does not do is to set the next value of the primary key column. Trying to > add a new row will result in a "duplicate primary key error". I am not sure > what ragtime is doing here exactly, Also this did not happen with H2 or > SQLITE IIRC from other projects. > > One solution is to set the counter manually by running: > > > > SELECT setval('tags_id_seq', 1); > > > > It works from the postgres console, but running this as part of the > migration does not work, I get an exception: PGSQLException: Statement > returned a result, but none was expected. > > > > Anyone experienced something similar? Any ideas how to solve it? > > > > Thanks, > > Sven > > > > -- > > You received this message because you are subscribed to the Google > > Groups "Clojure" group. > > To post to this group, send email to clo...@googlegroups.com > <javascript:> > > Note that posts from new members are moderated - please be patient with > your first post. > > To unsubscribe from this group, send email to > > clojure+u...@googlegroups.com <javascript:> > > For more options, visit this group at > > http://groups.google.com/group/clojure?hl=en > > --- > > You received this message because you are subscribed to the Google > Groups "Clojure" group. > > To unsubscribe from this group and stop receiving emails from it, send > an email to clojure+u...@googlegroups.com <javascript:>. > > For more options, visit https://groups.google.com/d/optout. > > -- You received this message because you are subscribed to the Google Groups "Clojure" group. To post to this group, send email to clojure@googlegroups.com Note that posts from new members are moderated - please be patient with your first post. To unsubscribe from this group, send email to clojure+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/clojure?hl=en --- You received this message because you are subscribed to the Google Groups "Clojure" group. To unsubscribe from this group and stop receiving emails from it, send an email to clojure+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.