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