DELETE FROM fails

From: chris Gnther <guenther(at)uscreen(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: DELETE FROM fails
Date: 2001-03-28 09:51:56
Message-ID: 20010328115156.0e5b44b0.guenther@uscreen.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi folks,

I have the problem that I can't delete datasets out of my tables. It's like that:
I have a table:
tblshop
ID_Shop oid with sequence
-------
Sh_Name
ID_Country
...

there is an index on ID_Country

I have a second table:
tblcountry
ID_Country oid with sequence
----------
C_Name
...

I have a reference between these two tables pointing from tblshop.ID_Country to
tblcountry.ID_Country

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

the same happens when I try to do:

DELETE FROM tblshop WHERE tblshop."ID_Country" = 3

I also tried this query without quotes, with simple quotes (') without the leading
tablename and so on, but I always get the error-message:

ERROR: Attribute 'id_shop' not found

Please, can anyone help me out? It is really anoying when you can't delete datasets
especially because my application is already online (I use postgres with PHP) and
there are 20 tables with alltogether 120 MB of data in it

chris

--
+-----------------------------+
| chris |
| Database Developer |
| uscreen GmbH |
| |
| --------------------------- |
| eMail guenther(at)uscreen(dot)de |
| Fon (02 02) 24 49 88 - 23 |
+-----------------------------+

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Pete Jewell 2001-03-28 10:14:05 Re: Problems accessing TCL functions
Previous Message dhninh 2001-03-28 04:11:11 connect to MS SQL server