Обсуждение: error null value in column" concat_id" violates not-null constraint
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 concatPRIMARY KEY (concat_id); Now i want to insert values on concat_id resulting from a function called "concat_id" INSERT INTO concat_id SELECT(concat_id) FROM auxiliar ; I get "error null value in column"concat_id" violatres not null constraint Could anyone tell me what am i doing wrong? Ana
Hello 2010/11/25 Ana Louro <anaoliveiralouro@gmail.com>: > 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 resulting from a function > called "concat_id" > > INSERT INTO concat_id > SELECT(concat_id) FROM auxiliar ; insert has a syntax: INSERT INTO <tablename> function call has a syntax funcname(parameters) so if I would to fill table auxiliar from some function, then I'll use a statement INSERT INTO auxilar SELECT * FROM funcname(..) Regards Pavel Stehule > > I get "error null value in column"concat_id" violatres not null > constraint > > > > Could anyone tell me what am i doing wrong? > > Ana > > > > > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql >