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

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: error null value in column" concat_id" violates not-null constraint
Дата
Msg-id AANLkTi=+=m8z1hmhDKtvUwiaKTAVCr2M+Armsm+5X1fq@mail.gmail.com
обсуждение исходный текст
Ответ на error null value in column" concat_id" violates not-null constraint  (Ana Louro <anaoliveiralouro@gmail.com>)
Список pgsql-sql
Дерево обсуждения 
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
>

В списке pgsql-sql по дате отправления: