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 > <clojure@googlegroups.com> 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 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. -- 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.