Re: psycopg2.DataError: invalid input syntax for integer: ""

[tango ward <tangoward15@xxxxxxxxx>]

Yes, my apologies.

May I also ask if there's a limitation for the number of timestamp with timezone fields in a table?

On Mon, May 7, 2018 at 1:37 PM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

Please keep replies on-list, don't top-post, and double-check that the database table doesn't somehow have an integer column where you think its text.

On Sunday, May 6, 2018, tango ward <tangoward15@xxxxxxxxx> wrote:

Yeah, the error doesn't really explain much. I have tried putting the string formatter in ' ', still no good.

On Mon, May 7, 2018 at 12:14 PM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Sunday, May 6, 2018, tango ward <tangoward15@xxxxxxxxx> wrote:

Hi,

There's a mistake in the code, my bad.

I updated the code into

cur_p.execute("""
                INSERT INTO a_recipient (created, mod, agreed, address, honor)
                VALUES (current_timestamp, current_timestamp, current_timestamp, %s, %s)""", ('', ''))

The code still won't work. The address and honor fields are textfields in Django models.py. 

Not sure but I'm thinking you at least need to add single quotes around the %s symbols.  That doesn't really explain the integer input error though I'm not familiar with the exact features of the execute method in Python.

David J.