From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
---|---|
To: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | FK constraints "NOT VALID" by default? |
Date: | 2011-03-17 21:22:10 |
Message-ID: | 1300396759-sup-3063@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I just ran this quick test in HEAD:
alvherre=# create table study (id int primary key);
NOTICE: CREATE TABLE / PRIMARY KEY creará el índice implícito «study_pkey» para la tabla «study»
CREATE TABLE
alvherre=# insert into study select a from generate_series(1, 1000000) as a;
INSERT 0 1000000
alvherre=# create table studyform (id int primary key, study_id int not null references study);
NOTICE: CREATE TABLE / PRIMARY KEY creará el índice implícito «studyform_pkey» para la tabla «studyform»
CREATE TABLE
alvherre=# insert into studyform select a, 1 + a * random() from generate_series(1, 100000) a;
INSERT 0 100000
and was very surprised to see that the foreign key is marked as NOT
VALID:
alvherre=# \d studyform
Tabla «public.studyform»
Columna │ Tipo │ Modificadores
──────────┼─────────┼───────────────
id │ integer │ not null
study_id │ integer │ not null
Índices:
"studyform_pkey" PRIMARY KEY, btree (id)
Restricciones de llave foránea:
"studyform_study_id_fkey" FOREIGN KEY (study_id) REFERENCES study(id) NOT VALID
Is this really intended?
--
Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2011-03-17 21:23:45 | Re: really lazy vacuums? |
Previous Message | Kevin Grittner | 2011-03-17 21:02:18 | Re: 2nd Level Buffer Cache |