Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2SGI1U74375 for ; Wed, 28 Mar 2001 11:18:03 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f2SGHtw18367; Wed, 28 Mar 2001 11:17:55 -0500 (EST) To: chris G nther cc: pgsql-sql@postgresql.org Subject: Re: DELETE FROM fails with error In-reply-to: <20010328115051.6ad6ad5d.guenther@uscreen.de> References: <20010328115051.6ad6ad5d.guenther@uscreen.de> Comments: In-reply-to chris G nther message dated "Wed, 28 Mar 2001 11:50:51 +0200" Date: Wed, 28 Mar 2001 11:17:55 -0500 Message-ID: <18364.985796275@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200103/581 X-Sequence-Number: 2251 chris Günther writes: > When I try to delete a row from tblshop I get the error that postgres > can't find the attribute id_shop. My SQL-command looks like follows: > DELETE FROM tblshop WHERE tblshop."ID_Shop" = 12 That looks like the correct way of quoting a mixed-case field name. I think the field is not named quite like you think it is. Try doing pg_dump -s -t tblshop databasename to see what the field names really are. regards, tom lane