From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)com> |
Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Function PostgreSQL 9.2 |
Date: | 2016-05-03 01:08:41 |
Message-ID: | CAKFQuwZYvQ3DhSau3R3KpetapEQhefKvH=Dnkr_NJT9mSM=Rvg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, May 2, 2016 at 5:44 PM, drum(dot)lucas(at)gmail(dot)com <drum(dot)lucas(at)gmail(dot)com>
wrote:
> 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 DEFAULT
>
> ALTER 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 trigger
>
> CREATE 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 UNIQUE
>
>> ALTER 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Sameer Kumar | 2016-05-03 01:21:13 | Re: index question |
Previous Message | David G. Johnston | 2016-05-03 00:45:38 | Re: index question |