Thanks to the help of a friendly slack user I figured out what the problem
is.
The SERIAL type does not support providing data on inserts, so:
INSERT INTO tags ("name", "id") VALUES
('Java', '1')
should be:
INSERT INTO tags ("name") VALUES
('Java')
Then everything works as expected.
Coming from mysql, H2 this is a bit suprising, I feel almost like 10 years
ago when trying to fit CSS styles into different browsers.
Sven.
Am Montag, 14. März 2016 10:53:38 UTC+1 schrieb Sven Richter:
>
> 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 [email protected]
Note that posts from new members are moderated - please be patient with your
first post.
To unsubscribe from this group, send email to
[email protected]
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
