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 f
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
>
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 Richt