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.
