From: | Vijay Deval <deval(at)giaspn01(dot)vsnl(dot)net(dot)in> |
---|---|
To: | chris Günther <guenther(at)uscreen(dot)de> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: DELETE FROM fails |
Date: | 2001-03-31 14:45:04 |
Message-ID: | 3AC5ED70.29A13F4E@giaspn01.vsnl.net.in |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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 |
> | |
> |
From | Date | Subject | |
---|---|---|---|
Next Message | Knut Suebert | 2001-03-31 18:13:42 | Re: hint4debian [was: Error during update from version 6.5.3 to version 7.03] |
Previous Message | Tom Lane | 2001-03-31 05:58:31 | Re: Select ... From (Select ...)? |