DELETE FROM statement not working
| От | Shaan Repswal |
|---|---|
| Тема | DELETE FROM statement not working |
| Дата | |
| Msg-id | CALa+hESZQ9=v0hF3rsFhuUyDNQX-5-Y5iyC091B9mWhVDn-wCQ@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: DELETE FROM statement not working
Re: DELETE FROM statement not working Re: DELETE FROM statement not working |
| Список | psycopg |
I was trying to delete a record I got inside my database and so I first typed all of this inside the interpreter... It was followed by the error mentioned at the bottom. I can't figure this out. Can anyone help me out?
>>> conn = psycopg2.connect("dbname=prototypedb user=postgres password=superman123")
>>> cur = conn.cursor()
>>> cur.execute("DELETE FROM inventory WHERE name = \"Polyester Direct High Gloss\";")
Traceback (most recent call last):
File "<pyshell#84>", line 1, in <module>
cur.execute("DELETE FROM inventory WHERE name = \"Polyester Direct High Gloss\";")
psycopg2.ProgrammingError: column "Polyester Direct High Gloss" does not exist
LINE 1: DELETE FROM inventory WHERE name = "Polyester Direct High Gl...
^
>>> name = "DELETE FROM inventory WHERE name = \"Polyester Direct High Gloss\";"
>>> cur.execute(name)
Traceback (most recent call last):
File "<pyshell#86>", line 1, in <module>
cur.execute(name)
psycopg2.InternalError: current transaction is aborted, commands ignored until end of transaction block
>>> conn = psycopg2.connect("dbname=prototypedb user=postgres password=superman123")
>>> cur = conn.cursor()
>>> cur.execute("DELETE FROM inventory WHERE name = \"Polyester Direct High Gloss\";")
Traceback (most recent call last):
File "<pyshell#84>", line 1, in <module>
cur.execute("DELETE FROM inventory WHERE name = \"Polyester Direct High Gloss\";")
psycopg2.ProgrammingError: column "Polyester Direct High Gloss" does not exist
LINE 1: DELETE FROM inventory WHERE name = "Polyester Direct High Gl...
^
>>> name = "DELETE FROM inventory WHERE name = \"Polyester Direct High Gloss\";"
>>> cur.execute(name)
Traceback (most recent call last):
File "<pyshell#86>", line 1, in <module>
cur.execute(name)
psycopg2.InternalError: current transaction is aborted, commands ignored until end of transaction block
В списке psycopg по дате отправления: