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.

Reply via email to