ing the documentation: http://www.postgresqltutorial.
>> com/postgresql-cast/ but it gives me error `psycopg2.DataError: invalid
>> input syntax for integer: ""`
>>
>
> Would need to see your code to be sure, but I am gong to guess you are
> trying to CAST the stri
copg2.DataError: invalid input syntax for integer: ""`
Would need to see your code to be sure, but I am gong to guess you are
trying to CAST the string to integer in the SQL e.g CAST(some_str_value
AS INTEGER) or some_str_value::integer. The error you are getting is :
test=# se
On Mon, May 7, 2018 at 6:35 AM, Adrian Klaver
wrote:
>
>> 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 fe
On 05/06/2018 11:05 PM, tango ward wrote:
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
mailto:david.g.johns...@gmail.com>> wrote:
Please keep replies on-list, don
tgresql-cast/ but it gives me error `psycopg2.DataError: invalid
> input syntax for integer: ""`
>
>
You haven't asked a question and your statement is unsurprising to me. Are
you good now or do you still harbor confusion?
David J.
I think I've found the culprit of the problem.
I have a field which is varchar from the source DB while on the destination
DB its integer.
Reading the documentation:
http://www.postgresqltutorial.com/postgresql-cast/ but it gives me error
`psycopg2.DataError: invalid input syntax for in
On Sunday, May 6, 2018, tango ward wrote:
> Yes, my apologies.
>
> May I also ask if there's a limitation for the number of timestamp with
> timezone fields in a table?
>
Not one that is likely to matter in practice. There's a page discussing
limitations on the website/docs somewhere if you wis
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.johns...@gmail.com> wrote:
> Please keep replies on-list, don't top-post, and double-check that the
> database table
On Sunday, May 6, 2018, tango ward wrote:
> cur_p.execute("""
>
> INSERT INTO a_recipient (created, mod, agreed, address,
> honor,)
> VALUES (%s, %s)""", (current_timestamp, current_timestamp,
> current_timestamp, '', ''))
>
>
That code doesn't even run (extra co
Good day to all,
I need advice on how to solve this problem. I am new to this kind of task.
I want to insert data into my PostgreSQL DB. The field that I will store
data is a textfield but I am getting an error invalid input syntax for
integer: ""
My code so far is this:
cur_p.execute("""
10 matches
Mail list logo
