Re: How to make a non-removable row in a table?

Hi,

create a delete trigger that raises an exception

Thomas


Am 19.12.2011 07:43, schrieb Капралов Александр:
> Hi all.
>
> How to make a non-removable row in a table?
>
> In my case, I should not accidentally delete a row with id = 0.
>
> CREATE TABLE profile (
>
>      id integer NOT NULL,
>
>      name character varying(265) NOT NULL
>
> );
>
> CREATE SEQUENCE profile_id_seq
>      START WITH 1
>      INCREMENT BY 1
>      NO MAXVALUE
>      NO MINVALUE
>      CACHE 1;
>
> ALTER TABLE profile ALTER COLUMN id SET DEFAULT
> nextval('profile_id_seq'::regclass);
>
> ALTER TABLE ONLY profile ADD CONSTRAINT profile_pkey PRIMARY KEY (id);
>
> INSERT INTO profile VALUES (0,'non-removable Profile');
>