Puzzling "INSERT has more expressions than target columns" error

From: Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Puzzling "INSERT has more expressions than target columns" error
Date: 2026-05-13 20:03:10
Message-ID: 41fcedd6-179c-440f-8e4b-b3032db25839@gelassene-pferde.biz
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi

Did you make sure, the order of the columns is identical? Well, maybe that should result in a different error.

My two dimes

Thiemo

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Hajek, Nick 2026-05-13 20:04:37 Re: Puzzling "INSERT has more expressions than target columns" error
Previous Message Ron Johnson 2026-05-13 19:57:13 Puzzling "INSERT has more expressions than target columns" error