Han Han
09/23/2022, 1:06 AMdbgenerated
Postgresql look like that:
CREATE OR REPLACE FUNCTION create_payment_id_code(INTEGER) RETURNS text AS $$
SELECT CASE
WHEN $1 < 10000 THEN 'PM' || to_char($1, 'FM00000')
ELSE concat('TT', $1)
END;
$$ LANGUAGE sql immutable;
ALTER TABLE public.payments
ADD COLUMN "paymentIdCode" TEXT UNIQUE NOT NULL GENERATED ALWAYS AS (create_payment_id_code("paymentId")) STORED;
When I use prisma db pull
paymentIdCode String? @unique @default(dbgenerated("create_payment_id_code(\"paymentId\")"))
when run migrate then get the error: ERROR: cannot use column reference in DEFAULT expression.
Nurul
09/23/2022, 3:52 PMVladi Stevanovic