Re: Function PostgreSQL 9.2
От | David G. Johnston |
---|---|
Тема | Re: Function PostgreSQL 9.2 |
Дата | |
Msg-id | CAKFQuwZYvQ3DhSau3R3KpetapEQhefKvH=Dnkr_NJT9mSM=Rvg@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Function PostgreSQL 9.2 ("drum.lucas@gmail.com" <drum.lucas@gmail.com>) |
Список | pgsql-general |
This is what I've done:-- 1 - Creating the Sequence:CREATE SEQUENCE users_code_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 1000;
CACHE 1;-- 2 - Setting the DEFAULTALTER TABLE public.users ALTER COLUMN code SET DEFAULT NEXTVAL('users_code_seq');-- 3 - Setting the column as NOT NULL;
ALTER TABLE public.users ALTER COLUMN code SET NOT NULL;-- 4 - Setting the triggerCREATE TRIGGER public.update_code_column
BEFORE UPDATE OR INSERT
ON public.users
FOR EACH ROW
EXECUTE PROCEDURE public.users_code_seq;-- 5 - Creating a CONSTRAINT UNIQUEALTER TABLE public.users
ADD CONSTRAINT uc_users_code UNIQUE("code");Is that right?Am I missing something?
The definition for "public.users_code_seq" - which is an odd name to choose, especially given you already have a sequence of the same name.
David J.
В списке pgsql-general по дате отправления: