Re: error: insert has more expressions than target column

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dino Vliet <dino_vliet(at)yahoo(dot)com>
Cc: Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: error: insert has more expressions than target column
Date: 2004-09-07 14:36:33
Message-ID: 482.1094567793@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dino Vliet <dino_vliet(at)yahoo(dot)com> writes:
> I'm getting the same error without brackets.

The message says you are trying to insert more values than the "lessons"
table has columns.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-09-07 14:38:38 Re: restricting non superuser from accessing other
Previous Message Pierre-Frédéric Caillaud 2004-09-07 14:30:54 Re: The usual sequential scan, but with LIMIT !