python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - psycopg2

django.db.utils.DataError: value too long for type character varying(30). I am getting this error while migrating on heroku postgresql

The errors I am getting while migrating on PostgreSQL Heroku. Note: It is working fine on the local server. Traceback (most recent call last): File "/app/manage.py", line 22, in <mo...
test-img

Vaibhav Singh

python

django

postgresql

psycopg2

heroku-postgres

Votes: 0

Answers: 3

Latest Answer

I just deleted the junk file inside the migrations>pycache
test-img

Vaibhav Singh

How can I write an SQL update command using %s in psycopg2 with python

I am new to python, currently learning. So I am using the psycopg2 library to run postgresql query and have an insert command like this: cursor.execute( "INSERT INTO test_case (run_id...
test-img

Alapan Das

python

postgresql

sql-update

sql-insert

psycopg2

Votes: 0

Answers: 1

Latest Answer

Something like below: cursor.execute( """UPDATE test_run SET (status, project_name,total_time_in_ms, total_time_in_hr_min_sec) = (%s, %s, ...
test-img

Adrian Klaver

Postgresql: Foreign key violations when importing tables from csv files using copy_expert offered by psycopg2

Here is a recreation of the problem statement. The database schemas for two tables (say Tab1 and Tab2) have been given in a file called (say) schemas.ddl. Multiple integrity constraints (including for...
test-img

Akash Cherukuri

python

postgresql

csv

psycopg2

Votes: 0

Answers: 1

Latest Answer

Those FK constraints must be created with DEFERRABLE initially, only then it can be deferred by using the SET command. Alternatively, you can turn off all triggers on those 2 tables and then do the bu...
test-img

Anand Sowmithiran

How to UPDATE table in psycopg2

def GetUpdate(): enter = input("What attributes do you want to change ? ") select,p_id = input("Please enter your attributes separated by space: ").split() try: ...
test-img

Dias

python

sql

psycopg2

Votes: 0

Answers: 1

Latest Answer

cur.execute("UPDATE Diary SET ❌%s❌ = %s where diary_id = %s",(enter,select,p_id)) You can't use a bind variable to set a tablename or column name or the like. I.e. you can't compose/buil...
test-img

JL Peyret

Posts

Questions

Blogs

Jobs