From: | Christophe Pettus <xof(at)thebuild(dot)com> |
---|---|
To: | Shaan Repswal <shaun(dot)reapswaal(at)gmail(dot)com> |
Cc: | psycopg(at)postgresql(dot)org |
Subject: | Re: DELETE FROM statement not working |
Date: | 2016-03-14 16:58:28 |
Message-ID: | AA091492-154E-4291-9FA8-A9F3CC6D3B38@thebuild.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | psycopg |
Single quotes for a string. Double quotes are used in SQL to indicate a table name with capitalization, spaces, etc.
On Mar 14, 2016, at 9:56 AM, Shaan Repswal <shaun(dot)reapswaal(at)gmail(dot)com> wrote:
> 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
--
-- Christophe Pettus
xof(at)thebuild(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2016-03-14 16:58:45 | Re: DELETE FROM statement not working |
Previous Message | Shaan Repswal | 2016-03-14 16:56:58 | DELETE FROM statement not working |