Re: [SQL] error null value in column" concat_id" violates not-null constraint

2010-11-25 Thread Pavel Stehule
Hello 2010/11/25 Ana Louro : > Hi, > I'm just beggining in PostgreSql 9.0 > > I've created a table ,like this: > > CREATE TABLE auxiliar > ( >  ano integer, >  codigodc character varying, >  id character varying, >  concat_id character varying NOT NULL, >  CONSTRAINT concat PRIMARY KEY (concat_id)

[SQL] error null value in column" concat_id" violates not-null constraint

2010-11-25 Thread Ana Louro
Hi, I'm just beggining in PostgreSql 9.0 I've created a table ,like this: CREATE TABLE auxiliar ( ano integer, codigodc character varying, id character varying, concat_id character varying NOT NULL, CONSTRAINT concat PRIMARY KEY (concat_id); Now i want to insert values on concat_id res