Re: record new has no field cat

Fabrice Pollet <pollet@ensta.fr> writes:
> ERROR:  INSERT has more expressions than target columns
> I get this message when I insert in table inventaire.

What version are you running?  I don't see a problem with 7.0.2:

play=> insert into inventaire (catgorie) values ('informatique');
ERROR:  empname cannot be NULL value
play=> insert into inventaire (catgorie,dimension,nb_pieds) values ('informatique','z','3');
ERROR:  empname cannot be NULL value
play=> insert into inventaire (catgorie,dimension,nb_pieds,nb_tiroir) values ('informatique','z','3','4');
ERROR:  ExecAppend: rejected due to CHECK constraint $3
play=> insert into inventaire (catgorie,dimension,nb_pieds,nb_tiroir,nie) values ('informatique','z','3','4','q');
INSERT 335042 1
play=>

Possibly more to the point, what is your INSERT command exactly?

            regards, tom lane