Any common errors on psycopg2 importing?
<p>So I am inserting into PostgreSQL 9.2 with <code>psycopg2</code> and I am on Python 2.7. I use <code>try: except:</code> on this insert and it doesn't give me any errors and runs through like all is well. Same with connecting to the database.</p>

<p>Any common errors that everyone runs into when using this that I'm not thinking of? </p>

<p>The problem is that the <code>insert</code> doesn't actually insert. It doesn't give errors but it doesn't import anything either</p>

<pre><code>cur.execute("""
INSERT INTO data ( date, time, name, qty, dayornight, bl, idc, prices, contractlength)
VALUES ( %s, %s, %s, %s, %s, %s, %s, %s, %s);""",
    (datet, timet, "lod", qty, "day", btores, 0, prices, contracts))
</code></pre>

<p>Thanks guys! Like I said, literally no errors and everything runs great. I checked <em>psycopg2</em> and it doesn't have anything in the FAQ.</p>
