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.
