jackc / jackc/pgx

ERROR: prepared statement "lrupsc_1_20" already exists, and plansource is not the same. (SQLSTATE 42P05)

Open
#1,973 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Go
Stars
14.3k
Forks
1.1k
Avg merge
6d 9h
Merged PRs (30d)
11

Description

sql like this:

DELETE FROM "project_djln6wy4"."ODS_station_rt_report" WHERE _id in ('17035072','17035093','17035095','17035099','17035104','17035109','17035122','17035133','17035145','17035146','17035151','17035167','17035171','17035174','17035176','17035178','17035182','17035186','17035191','17035204','17035218','17035235','17035256','17035258','17035482','17035280','17035283','17035287','17035292','17035301','17035304','17035309','17035318','17035329','17035330','17035334','17035363','17035365','17035373','17035383','17035392','17035399','17035403','17035404','17035410','17035419','17035424','17035438','17035448','17035074','17035075','17035080','17035084','17035086','17035088','17035089','17035091','17035092','17035106','17035113','17035124','17035125','17035127','17035155','17035161','17035164','17035165','17035173','17035180','17035192','17035193','17035202','17035203','17035206','17035209','17035215','17035216','17035223','17035224','17035226','17035228','17035236','17035242','17035248','17035263','17035265','17035483','17035487','17035504','17035505','17035525','17035527','17035528','17035541','17035545','17035552','17035557','17035558','17035567','17035573','17035575','17035593','17035615','17035630','17035631','17035272','17035273','17035275','17035278','17035291','17035299','17035311','17035314','17035316','17035322','17035323','17035324','17035325','17035337','17035345','17035348','17035353','17035357','17035360','17035362','17035370','17035381','17035385','17035426','17035447','17035451','17035469','17035672','17035683','17035689','17035698','17035708','17035712','17035718','17035722','17035724','17035732','17035747','17035752','17035755','17035076','17035105','17035115','17035116','17035117','17035121','17035134','17035143','17035148','17035152','17035153','17035154','17035156','17035175','17035185','17035189','17035194','17035207','17035249','17035252','17035254','17035262','17035264','17035266','17035269','17035473','17035474','17035475','17035480','17035486','17035288','17035298','17035335','17035338','17035342','17035349','17035351','17035371','17035400','17035413','17035417','17035427','17035428','17035429','17035437','17035441','17035456','17035457','17035468','17035696','17035697','17035699','17035702','17035707','17035710','17035715','17035716','17035493','17035497','17035502','17035508','17035511','17035538','17035539','17035547','17035551','17035553','17035560','17035561','17035565','17035595','17035605','17035608','17035621','17035628','17035637','17035652','17035657','17035661','17035662','17035728','17035734','17035736','17035739','17035743','17035745','17035761','17035763','17035633','17035647','17035650','17035459','17035467','17035488','17035491','17035524','17035530','17035532','17035533','17035536','17035546','17035550','17035566','17035571','17035578','17035586','17035592','17035603','17035607','17035611','17035613','17035616','17035646','17035659','17035664','17035666','17035667','17035669','17035674','17035679','17035686','17035713','17035717','17035735','17035737','17035757','17035762','17035087','17035096','17035097','17035111','17035114','17035126','17035138','17035142','17035147','17035172','17035181','17035184','17035196','17035197','17035210','17035211','17035221','17035222','17035240','17035243','17035253','17035471','17035476','17035492','17035495','17035496','17035506','17035516','17035519','17035542','17035548','17035591','17035594','17035277','17035279','17035295','17035296','17035297','17035327','17035346','17035356','17035384','17035389','17035405','17035418','17035421','17035422','17035431','17035436','17035439','17035445','17035449','17035670','17035673','17035687','17035720','17035748','17035756','17035600','17035617','17035620','17035622','17035624','17035627','17035634','17035660','17035079','17035083','17035090','17035100','17035102','17035128','17035130','17035150','17035158','17035166','17035170','17035179','17035199','17035200','17035212','17035213','17035227','17035233','17035239','17035247','17035257','17035260','17035267','17035268','17035472','17035477','17035481','17035503','17035512','17035513','17035515','17035518','17035520','17035521','17035522','17035523','17035535','17035537','17035574','17035276','17035286','17035290','17035300','17035317','17035319','17035328','17035331','17035332','17035341','17035347','17035352','17035355','17035361','17035366','17035377','17035378','17035387','17035412','17035425','17035432','17035460','17035461','17035464','17035466','17035682','17035685','17035691','17035579','17035580','17035581','17035583','17035589','17035596','17035598','17035599','17035612','17035614','17035619','17035625','17035635','17035639','17035648','17035649','17035655','17035694','17035700','17035723','17035727','17035751','17035760','17035098','17035118','17035137','17035139','17035160','17035190','17035201','17035208','17035225','17035232','17035237','17035244','17035245','17035251','17035478','17035489','17035509','17035510','17035514','17035517','17035526','17035529','17035534','17035540','17035543','17035556','17035559','17035562','17035572','17035584','17035590','17035270','17035289','17035293','17035303','17035305','17035306','17035310','17035326','17035336','17035368','17035375','17035376','17035379','17035380','17035382','17035395','17035396','17035397','17035402','17035409','17035420','17035423','17035430','17035440','17035442','17035443','17035444','17035453','17035462','17035609','17035610','17035623','17035636','17035641','17035642','17035654','17035656','17035663','17035665','17035668','17035677','17035680','17035688','17035690','17035701','17035703','17035711','17035719','17035725','17035740','17035741','17035742','17035744','17035746','17035750','17035753','17035070','17035071','17035073','17035078','17035081','17035082','17035107','17035112','17035119','17035120','17035129','17035136','17035140','17035141','17035144','17035157','17035159','17035163','17035168','17035169','17035187','17035188','17035195','17035198','17035214','17035217','17035220','17035229','17035231','17035234','17035246','17035255','17035261','17035470','17035479','17035484','17035485','17035494','17035499','17035531','17035544','17035549','17035284','17035285','17035302','17035312','17035315','17035320','17035321','17035333','17035339','17035354','17035359','17035364','17035369','17035372','17035374','17035386','17035388','17035391','17035394','17035398','17035408','17035411','17035416','17035433','17035435','17035452','17035454','17035458','17035463','17035465','17035671','17035675','17035676','17035678','17035684','17035692','17035695','17035705','17035706','17035709','17035726','17035729','17035730','17035570','17035576','17035582','17035597','17035601','17035604','17035606','17035629','17035638','17035640','17035651','17035653','17035731','17035733','17035738','17035754','17035759','17035077','17035085','17035094','17035101','17035103','17035108','17035110','17035123','17035131','17035132','17035135','17035149','17035162','17035177','17035183','17035205','17035219','17035230','17035238','17035241','17035250','17035259','17035490','17035498','17035500','17035501','17035507','17035271','17035274','17035281','17035282','17035294','17035307','17035308','17035313','17035340','17035343','17035344','17035350','17035358','17035367','17035390','17035393','17035401','17035406','17035407','17035414','17035415','17035434','17035446','17035450','17035455','17035681','17035693','17035704','17035714','17035721','17035749','17035758','17035554','17035555','17035563','17035564','17035568','17035569','17035577','17035585','17035587','17035588','17035602','17035618','17035626','17035632','17035643','17035644','17035645','17035658') and asset_uuid='88805682-5f9f-4a26-84e7-27f6d9c237f9'

get a error : ERROR: prepared statement "lrupsc_1_20" already exists, and plansource is not the same. (SQLSTATE 42P05)

Contributor guide

Open the contributing guide

Research direction

No repository files, tests, or entry points are named. Start by reproducing the DELETE statement through pgx against PostgreSQL and investigate the prepared statement named lrupsc_1_20 and SQLSTATE 42P05. Done means identifying a reproducible cause and adding a fix or documented resolution, with coverage if an appropriate test location is found.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, postgresql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
18/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.