20 Replies
2 years ago
please provide reproducible steps
2 years ago
yes please provide steps so that anyone can see that error for themselves
create a postgres table with this sturcture and try to update it with the railway postgres editor.
2 years ago
the structure you have shown is a screenshot, a screenshot is not reproducible
CREATE TABLE public.access_link (
id text PRIMARY KEY,
created_on timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
issued_tokens text[] NOT NULL DEFAULT '{}'::text[],
expires_on timestamp with time zone,
times_used integer NOT NULL GENERATED ALWAYS AS (cardinality(issued_tokens)) STORED,
maximum_uses integer,
is_revoked boolean,
user_id text NOT NULL,
name text NOT NULL,
is_mutation_allowed boolean,
is_demo boolean,
CONSTRAINT access_link_to_user_foreign_key FOREIGN KEY (user_id)
REFERENCES "user" (id) ON UPDATE CASCADE ON DELETE CASCADE
);
CREATE INDEX access_link_pkey ON public.access_link USING btree (id);2 years ago
and then simply adding a row to that results in the error you shown?
2 years ago
what was in the row you edited and what did you edit
acl_UnMjQPh6yW5_ 2024-07-18 15:30:23.814856+00 {eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOiJ1c3JfT0tuRGlGM3BybFFxIiwiZXhwIjoxNzI5MDE3OTA3LCJpYXQiOjE3MjE1MDExMDcsImp0aSI6IjEyZmJhYzZkLTQ4YTktNDM0NS05MTUzLTllOWY0MmJlMTAzYyIsImFjY2Vzc19saW5rX2lkIjoiYWNsX1VuTWpRUGg2eVc1XyJ9.I4NFD31lCOD-fsb0DrEirHploinHhBp82s29I22K01g} 2024-10-16 15:30:16.37+00 1 \N \N usr_OKnDiF3prlQq Spotify Testing \N tThis is the data of the failing error
2 years ago
I'm sorry but I'm not sure how that answers my question