Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres CTE issues - Mailing list pgsql-sql

From Shekar Tippur
Subject Re: Postgres CTE issues
Date
Msg-id CAHmfATq8fVyeDn724Xt5pYpattmWb9=7RuZBs9NYYEZv9kM57w@mail.gmail.com
Whole thread Raw
In response to Re: Postgres CTE issues  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-sql
Tree view

I changed the not null constraint but I dont insert the FK id (it is null)

drop table C;                                       

DROP TABLE

s=> create table C (                                       

 "id" SERIAL PRIMARY KEY,

 name varchar(40)

 , b_id integer references B(id)DEFERRABLE INITIALLY DEFERRED);

CREATE TABLE

s=> insert into A (var1, var2) values ('Hello1', 'World1');

INSERT 0 1

s=> select * from C;                                       

  1 | World1 |     



On Tue, May 26, 2015 at 10:56 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:


On Tue, May 26, 2015 at 10:40 AM, Shekar Tippur <ctippur@gmail.com> wrote:
Marc,

I have changed the table C:

create table C (                                     

 "id" SERIAL PRIMARY KEY,

 name varchar(40)

 , b_id integer references B(id) DEFERRABLE INITIALLY DEFERRED  NOT NULL);


I still get the same error:

insert into A (var1, var2) values ('Hello1', 'World1');

ERROR:  null value in column "b_id" violates not-null constraint

DETAIL:  Failing row contains (2, World1, null).

CONTEXT:  SQL statement "INSERT INTO C (name, b_id) VALUES (NEW.var2, b_id)"

PL/pgSQL function fn_test() line 17 at SQL statement


​Because you cannot defer a NOT NULL constraint.

​http://www.postgresql.org/docs/9.4/static/sql-set-constraints.html

David J.


pgsql-sql by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Postgres CTE issues
Next
From: Ravi Krishna
Date:
Subject: PG and Temporal