DELETE FROM statement not working

From: Shaan Repswal <shaun(dot)reapswaal(at)gmail(dot)com>
To: psycopg(at)postgresql(dot)org
Subject: DELETE FROM statement not working
Date: 2016-03-14 16:56:58
Message-ID: CALa+hESZQ9=v0hF3rsFhuUyDNQX-5-Y5iyC091B9mWhVDn-wCQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse psycopg by date

  From Date Subject
Next Message Christophe Pettus 2016-03-14 16:58:28 Re: DELETE FROM statement not working
Previous Message Jonathan Rogers 2016-03-14 15:29:34 Re: Encountered an error