Thread: DELETE FROM fails
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@uscreen.de | | Fon (02 02) 24 49 88 - 23 | +-----------------------------+
chris Günther <guenther@uscreen.de> writes: > 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 try to figure out exactly how postgres thinks that columns are named, use pg_dump program as $ pg_dump -s -t <table-name-goes-here> Then use the names as they are dumped HTH, Manuel.
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 | > | | > |