Re: DELETE FROM fails

Are the  attribute names case sensative?  The query may not tolerate any accidental
space in the wrong place.

Vijay

"chris Günther" wrote:

> 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                |
> |                             |
> |