python-psycopg2-doc 2.4.5-1build5 / usr / share / doc / python-psycopg2-docs / html / searchindex.js

Search.setIndex({envversion:42,terms:{untrust:[10,3],sleep:9,consider:5,whose:[8,9],accur:4,display_s:5,pprint:3,under:4,mxtimearrai:8,digit:[5,3],everi:[10,3,8,9],a0eebc99:7,null_ok:5,affect:[5,4],"10l":10,direct:2,xf9:10,second:[2,4,7,8,10,9],xf2:10,blue:7,eventlet:[8,9],libpq:[0,2,5,3,8,10,9],asia:10,typnam:9,abov:[10,3,9],internalerror:4,never:[10,2,8],here:[10,2],met:9,path:2,anymor:[2,4],precis:5,datetim:[10,0,1,8,4],parlanc:10,unix:4,type_cod:[5,4],middlewar:3,describ:[5,4],would:[5,10,8,9],call:[2,5,3,7,8,9,10,11],until:[2,3,7,8,9,10,11],fastcgi:10,realdictrow:7,unescap:10,relat:[5,10,3,8,4],notic:3,warn:4,tpc_recov:[10,3,8],hold:[1,4,3,7,8,10],unpack:[3,8],must:[2,4,5,3,7,8,10,9],join:9,bqual:[3,8],restor:3,setup:8,work:[2,8,9,11],isqlquot:[8,9],give:9,"08t01":10,indic:[5,0,6,7],liter:[10,3],want:[10,3,7,8,9],declar:10,register_inet:7,enc:3,end:[10,3,2,9],datefromtick:4,ordinari:10,how:[10,7,8,9],recoveri:[10,3],env:2,widespread:10,updat:[5,0,2],recogn:[10,6],timedelta:10,after:[2,5,3,7,8,10,9],befor:[2,3,7,8,10,9],wrong:[10,2,4],attempt:[5,3,9],third:9,imposs:7,perform:[5,10,3,8,9],maintain:9,green:[10,9],first:[2,3,6,8,10,9],order:[10,8,9],oper:[4,5,3,8,9,10,11],macaddr:8,frontend:3,over:[5,2],failur:8,becaus:[2,9],caster:[7,8],flexibl:[5,0,8],aargh:6,wsgipythonegg:2,fix:1,"__class__":9,better:[7,9],persist:[10,11],them:[2,4,5,3,8,10,9],thei:[2,5,7,8,10,9],proce:[3,9],safe:[0,2,5,3,8,9,10,11],"break":9,interrupt:3,mytabl:9,foo_pkei:3,timeout:[8,9],each:[5,3,2,8,4],side:[5,0,3],mean:[5,10,3,2,11],a_str:10,binaryarrai:8,typecast:[2,5,7,8,10,9],dsn:[3,8,9,4],got:9,copy_to:[5,10],pydat:8,free:[2,11],standard:[3,4,5,6,7,8,10,9],tpc_begin:[10,3],filter:7,refcursor:10,unabl:2,subtl:10,onto:10,rang:4,isolation_level:[3,8],wast:9,system:[0,2,5,3,8,10,9],hook:8,alreadi:[10,3,7,8,4],messag:[2,3,4,5,6,8,9],wasn:5,payload:[3,8,9],xid:[10,3,8],tpc_:3,too:[10,2,8],similarli:9,class_syntax_error_or_access_rule_viol:6,listen:[8,9],namespac:9,tool:[10,4],target:[5,10],keyword:4,provid:[2,4,5,3,7,8,10,9],nextset:5,project:9,minut:[10,1,4],psycogreen:9,loggingconnect:7,close:[2,5,3,8,10,11],raw:4,manner:[8,9],seen:5,seem:2,seek:8,plpgsql:10,typarrai:8,latter:[5,3],rome:10,register_adapt:[8,9],even:[5,10,2],though:[10,3],deleg:9,regular:[5,3,7,8,10,9],addict:7,mxdatetim:8,phase:[0,3,8],don:[10,3],doc:3,doe:[2,3,4,5,6,7,8,9],logobj:7,neg:[5,10,8],wait_select:[7,8,9],protocol:[3,9],involv:5,absolut:5,layout:4,transactionrollbackerror:[8,4],explain:3,configur:[10,3,8],new_array_typ:[2,8,9],tzinfo:[5,0],transaction_status_unknown:8,deal_with_it:5,report:[3,8],uuid_adapt:[7,9],bar:[5,10,2],hello:9,method:[1,2,4,5,3,7,8,9,10,11],isexecut:[3,9],bad:[8,9],steal:10,num:[5,10,7],result:[0,2,4,5,3,7,8,10,9],respons:[10,7,9],fail:[10,2,8,4],best:5,subject:6,databas:[5,6,3,9],timestampfromtick:4,"__conform__":9,implicit:[10,3],integer_datetim:3,mvcc:[0,1,2,3,4,5,6,7,8,9,10,11],awai:11,approach:10,pyintervalarrai:8,attribut:[1,3,4,5,6,7,8,10,9],accord:[3,5,6,7,8,10,9],extend:[5,10,8],extens:9,easi:[5,2,9],howev:[10,8],against:[5,10,8],quotedstr:8,col:10,con:8,poll_ok:[3,8,9],assum:[5,10],three:[10,6,2],been:[1,2,3,5,6,7,8,9],much:9,interest:9,basic:[0,8,9,4],register_composit:[10,7],search:[0,7],argument:[1,2,4,5,3,7,8,10,9],multithread:[5,9],craft:10,child:2,"catch":[5,4],emploi:10,east:1,get_backend_pid:[3,8],properti:10,printabl:8,tabl:[0,3,4,5,6,7,8,10],kwarg:[7,11],sever:[10,0,3,7,9],iterfac:7,incorrectli:3,receiv:[10,3,2,8,9],suggest:2,make:[0,2,3,4,5,6,7,8,10,9],transpar:9,complex:8,complet:[10,8,9,4],lobject_factori:3,hang:10,evil:7,hand:10,rais:[2,3,4,5,6,7,8,10,9],modwsgi:2,redefin:5,kept:3,thu:[10,6,9,4],dada:5,inherit:4,client:[0,2,4,5,3,8,9,10,11],thi:[1,2,3,4,5,6,7,8,9,10,11],programm:[9,4],left:[5,10,2],identifi:[10,3,8],just:[7,8],pqconnectstart:9,memoryview:10,yet:[5,8],languag:[10,0],previous:[1,4,5,3,8,10,9],awaken:9,expos:[4,5,3,8,10,9],had:[5,10],seq_of_paramet:5,els:[2,9],save:[2,1],applic:[0,4,5,6,8,9,11],mayb:9,specif:[3,4,5,6,8,10,9],manual:[3,7,9],singl:[2,4,5,3,8,9,10,11],underli:3,old:2,namedtupleconnect:7,interv:[10,8],intern:[8,4],autocommit:[10,3,2,9],total:5,cooper:9,subclass:[6,8,3,9],overcom:4,condit:[10,6,2,8,3],foo:[5,10,3,2],operationalerror:[3,8,9,4],plu:[8,4],pose:2,unsaf:3,obj:8,unpars:[10,2,8],internal_s:5,commit:[0,2,5,3,8,9],produc:[5,10,6,8,9],longinteg:8,"float":[10,0,2,8,9],encod:[5,10,3,8],bound:[5,10,4],down:9,transaction_status_act:8,wrap:[5,10,7,8,9],accordingli:4,jdbc:[10,3],deal:[10,7,8],wai:[10,7,9],transform:7,why:2,avail:[0,3,4,5,6,7,8,10,9],reli:[10,3,8,9],fraction:5,overhead:[5,10,2],fork:[10,2],form:[10,3,1,9],offer:[10,3,9,11,4],datestyl:3,taken:[5,10,3],sqlalchemi:9,"true":[5,3,7,11,10,9],callproc:[5,10,9],attr:7,arrays:5,maximum:11,tell:8,emit:[10,6],featur:[10,0],"100kb":10,log_min_duration_stat:3,exist:[10,4],localtimezon:1,check:[7,9,4],readonli:3,when:[2,4,5,3,7,8,10,9],test:[4,5,6,7,10,9],roll:3,intend:3,psycopg:[5,3,8,9],stringio:5,iters:[5,10],intens:5,consid:[3,4],format_id:[3,8],uniformli:10,longer:10,furthermor:3,withhold:[5,10,3],geometr:9,time:[5,3,8,9],push:3,lastrowid:5,backward:[3,8],skip:2,global:[10,3,7,8],ouch:6,invent:6,signific:5,computation:5,row:[5,7,4],decid:5,depend:[5,2,8,9],zone:5,decim:[0,2,5,3,8,10],readabl:[5,9],x08:8,curnam:10,mintimeloggingconnect:7,set_client_encod:[10,3,9],x00:8,sourc:[10,3,9,4],setoutputs:5,string:[0,2,4,5,3,7,8,10,9],exact:1,level:[5,3],did:[5,3],some_t:10,x0f:8,iter:[5,10],item:[2,4,5,3,7,8],round:10,sign:1,btree:7,port:4,pytim:8,appear:8,current:[2,4,5,3,7,8,9,10,11],"6bb9bd380a11":7,gener:[2,3,7,8,10,11],unauthor:10,gtrid:[3,8],explicitli:5,address:[7,8,4],viabl:9,wait:[3,7,8,9],box:[0,7],pqfsize:5,dictcursor:7,behav:[10,3,8],extrem:[10,7],semant:9,extra:[3,9],proportion:10,modul:[0,3,5,6,7,8,9],visibl:5,marker:4,instal:[10,3,2,7],should:[2,3,4,5,6,8,10,9],memori:[10,2,1,4],compositecast:7,live:[10,3,2],msg:7,scope:[10,7,8,9],registr:[7,9],status_in_transact:[3,8],examin:10,postgresql:[5,3,9],prepar:[5,10,3,8,9],timestamptz:10,descriptor:[3,8,9],can:[0,1,2,3,4,5,6,7,8,9,10,11],heart:7,a_dat:10,encapsul:[10,3],stream:10,backslash:8,abort:[10,2],occur:[6,4],alwai:[2,5,8,11,10,9],multipl:5,"42p01":[6,4],write:[2,5,3,8,10,9],bytea_output:[10,2],pure:11,server_encod:3,map:[0,5,7,8,10,9],usabl:[10,3],new_typ:[2,8,9],mai:[2,4,5,3,7,8,10,9],data:[5,3,8,9],stress:10,quot:[10,3,7,8],explicit:[3,2],inform:[5,2,8,9,4],"switch":[3,8,9],pg_namespac:9,callabl:4,still:[6,7,3,9],psycopg_display_s:5,disconnect:4,monitor:8,lo_export:[10,8],platform:1,main:[10,0,4],non:[10,3,8,9],standarderror:4,savepoint:2,initi:[3,2,7],therebi:9,now:[5,10,3,7],nor:[10,3],introduct:8,name:[1,2,3,4,5,6,7,8,10,9],revert:[3,8],separ:[5,10,9],compil:[5,8],set_sess:[10,3,9],replac:[5,8],continu:10,bb6d:7,protocol_vers:3,year:4,happen:[3,9],dispos:2,shown:8,tpc_rollback:[10,3,8],log_stat:3,formula:2,correct:[10,2,7],earlier:2,client_encod:3,dictconnect:7,sql_in:8,five:6,"byte":[0,5,3,8,10,9],"_psycopg":[2,8,7],pg_type:[5,8,9],card:7,care:10,synchron:9,recov:[3,2,8],turn:4,place:7,think:2,lambda:2,origin:[7,8],directli:[1,9,11],carri:9,onc:[10,8],arrai:[0,2,7,8,10,9],"long":[10,0,3,2,4],oppos:2,open:[10,3,2,8,7],size:[5,2,8],given:[5,3,8,4],returnd:8,convent:6,necessarili:[8,4],conveni:[10,9],memo:10,copi:[5,0,9,4],specifi:[4,5,3,7,8,10,9],enclos:8,mostli:[5,0,11,4,10],gin:7,than:[3,4,5,6,7,8,9,10,11],png:10,serv:10,wide:10,were:[10,3,8,4],posit:[5,10,2,8],sai:2,ani:[0,2,4,5,3,8,10,9],timestampfrompi:8,maxconn:11,dbapi:3,advic:5,destroi:[10,0],note:[2,3,4,5,6,7,8,9,10,11],take:[2,8,9,4],advis:9,environ:[9,4],noth:[5,3,7,8],channel:[3,8,9],begin:[10,3,9],sure:[10,2,7],normal:[2,7],buffer:[5,10],pytimearrai:8,reffunc:10,pair:7,later:8,runtim:[2,8],serializ:[3,8],show:[10,3],serialis:8,concurr:[0,3,2,8,9],register_tstz_w_sec:[10,7],onli:[2,4,5,3,7,8,9,10,11],slow:2,transact:[5,3,9],activ:10,state:[5,8,9,4],dict:7,overwritten:7,reset:3,mypic:10,get:[5,2,9,11],mintim:7,repr:10,soon:[10,3,2],ssl:2,cannot:[5,2],requir:[2,4,3,7,8,9,10,11],fileno:[3,8,9],tfoo:5,borrow:6,where:[2,5,7,8,10,9],isolation_level_read_uncommit:8,kernel:9,atabl:9,getquot:[7,8,9],mxtime:8,detect:[8,4],enough:8,unicodearrai:[10,2,8],between:[0,3,4,6,10,9],"import":[2,4,5,3,7,8,10,9],across:[6,2,11,7],realdictconnect:7,come:[10,9],inconsist:8,improv:[7,1],among:3,overview:[5,3,8],inspir:[10,8],pop:9,cancel:[3,8],poll:[3,9],fetchal:[5,10],classic:10,invers:8,closeal:11,sslmode:4,timearrai:8,gist:7,those:8,"case":[4,5,3,8,10,9],interoper:10,trick:2,invok:[5,3,8,9],"na\u00efv":10,apilevel:4,datetimearrai:8,advantag:[2,9,4],stdout:5,destin:4,"__init__":[1,9],point_oid:9,develop:2,harsh:2,author:[10,3,9],same:[1,2,4,5,3,8,9,10,11],binari:[10,0,2,8,4],epoch:4,html:3,document:[1,2,3,4,5,6,8,10,9],apoint:9,lo_trunc:[2,8],finish:[3,8],utf8:10,nest:[2,7],oid:[2,5,3,7,8,9],driver:[10,3],companion:7,capabl:4,mani:[0,4,5,3,7,8,10,9],appropri:10,choos:3,copy_from:[5,10],without:[10,3,9],timefrommx:8,deferr:3,model:[10,8],execut:[2,3,4,5,6,7,8,10,9],set_isolation_level:[10,3,8,9],europ:10,pqparameterstatu:3,hint:4,except:[5,6,3,9],littl:[2,7],blob:[10,4],real:9,read:[2,5,3,8,10,9],vacuum:[10,3,8],integ:[2,4,3,7,8,10],server:[0,2,3,4,5,6,7,8,9],getconn:11,either:[4,5,3,7,8,10,9],output:[5,7,9],manag:3,desider:[10,3],rowid:[8,4],egenix:10,statusmessag:5,sqlstate:6,inject:[10,7],datefrompi:8,refer:[5,10,9],inizi:7,nspname:9,"__name__":9,timefromtick:4,greatli:7,realdictcursor:7,effici:[10,0,7,8],contrib:7,your:[5,10,2,7],complianc:[5,8,4],hex:[10,2],floatarrai:8,overwrit:7,start:[10,3,2,8,9],interfac:[5,10,9,4],lot:[0,2],verbatim:4,tupl:[0,2,5,3,7,8,10],pqbackendpid:3,gori:2,tripl:3,pqgetlength:5,possibl:[2,5,3,7,8,10,9],"default":[1,2,4,5,3,7,8,10],embed:7,deadlock:[8,9],creat:[0,1,2,4,5,3,7,8,9,10,11],decreas:10,file:[2,5,3,7,8,10,9],proport:2,fill:10,denot:6,longintegerarrai:8,field:[10,8],valid:[10,3,8,4],writabl:[5,2,9],ignor:2,you:[2,4,5,3,7,8,10,9],nt_cur:7,sequenc:[5,10,3,2,7],symbol:[6,2,3,4],pool:[0,2,9],network:5,directori:[2,7],descript:[5,8,9,4],threadedconnectionpool:11,potenti:3,escap:[10,2,8],cpu:9,represent:[2,5,7,8,10,9],all:[2,3,4,5,6,7,8,9,10,11],forget:10,month:4,bytearrai:10,follow:[2,3,4,5,6,8,9,10,11],content:[5,0,8],program:[0,2,4,3,10,9],consum:10,fals:[5,10,3,7,11],faq:8,mechan:[10,8,9],fall:10,veri:[2,4],pg_catalog:9,list:[0,2,4,5,3,7,8,10,9],small:[2,1],default_transaction_:[3,9],sync:4,zero:4,postgr:[10,4],design:[0,9,11],pass:[0,1,2,3,4,5,6,7,8,9,11],further:[10,3,2,9],whenc:8,what:[5,6,2,3],abc:[5,10,7],sub:[7,9],section:4,abl:[10,6,8],version:[2,3,4,5,6,7,8,10,9],"public":7,querycancelederror:[3,8,4],full:0,behaviour:8,shouldn:[10,3],excess:3,modifi:[5,7,9],invoc:3,valu:[0,2,3,4,5,6,7,8,9],isolation_level_autocommit:[3,8,9],putconn:11,another_d:10,prior:3,amount:10,action:[10,3],introductori:3,n74:5,via:[5,10,9],inappropri:3,establish:[8,9],card_back:7,select:[2,3,4,5,6,7,8,10,9],distinct:8,regist:[2,5,7,8,10,9],two:[0,1,2,3,5,6,8,9],poll_read:[8,9],tzinfo_factori:[5,1],paramstyl:4,minor:3,desir:[7,8],particular:[10,4],known:[10,3,2,9,7],cach:[2,1],psql:9,none:[1,2,4,5,3,7,8,9,10,11],hour:[10,4],attnam:7,dev:2,mogrifi:[5,10,7,9],remain:[5,10,3,8],del:[5,10,3],pyinterv:8,def:[5,10,7,9],integrityerror:4,share:[0,2,4,3,9,10,11],accept:[10,3,8,9],minimum:8,huge:10,cours:9,secur:0,rather:[5,6,8,3,4],divis:4,datefrommx:8,dec2float:2,csv:5,simpl:[4,3,8,11,10,9],register_uuid:[7,9],resourc:[10,3,2,8,9],catalog:[8,9],unlink:8,associ:5,roundtrip:[5,10],caus:[3,8],callback:[7,8,9],egg:2,help:7,major:3,regtyp:7,held:[10,3],through:[5,8,9,4],paramet:[0,2,4,5,3,7,8,9],style:[10,9],psycopg2:[5,3,9],relev:[2,8],feel:2,pend:3,pgerror:4,finer:3,wouldn:3,good:2,"return":[1,2,3,4,5,6,7,8,10,9],timestamp:[5,10,7,8,4],pollut:9,framework:9,from_str:8,eventu:[10,3,11],dictrow:7,authent:4,easili:10,found:[1,2,4,5,6,7,8],unicod:[0,2,5,3,7,8],truncat:[8,4],idea:1,procedur:5,realli:7,expect:[4,5,7,8,10,11],event:2,safeti:[5,0,3,2,4],publish:10,primari:[10,3],transaction_status_idl:8,print:[5,10,9,4],file_nam:8,qualifi:[10,8],asp:2,uncommit:[3,8],reason:[10,3],base:[4,5,7,8,11,9],put:11,asi:[8,9],thread:[0,2,4,5,3,9,11],undefined_t:6,lifetim:[5,10],assign:[10,6,3,11],aconn:9,notifi:[3,8,9],get_wait_callback:8,estabilish:3,exchang:10,number:[0,2,4,5,3,8,10],placehold:[5,10,2],done:5,construct:4,stabl:8,miss:2,differ:[1,4,5,3,7,8,9,10,11],script:[10,3,7,9],interact:[10,9,11],least:[10,2],stori:10,namedtupl:5,statement:[5,3,2,4],colmun:7,store:[5,10,7,8],schema:7,option:[5,2,8,9,7],loggingcursor:[7,9],part:[5,3,2],pars:[10,2,8,9],kind:[10,2],grep:2,whenev:[5,3,8,9],remov:8,str:[2,3,7,8,10,9],session_author:3,packag:2,"null":[5,10,8,9],array_oid:7,built:[0,8],equival:8,self:9,also:[0,1,2,3,4,5,6,7,8,9,10,11],build:9,default_transaction_deferr:3,distribut:[10,0,7],previou:[2,5,3,7,8,10,9],most:[5,10],atttyp:7,addr:7,tpc:3,exc:[5,9],persistentconnectionpool:11,destruct:10,alphanumer:3,session:[2,4,5,3,8,10,9],fine:2,find:[10,2,8,7],access:[0,3,7,8],indexerror:5,xec:10,unus:[5,3,2],namedtuplecursor:7,express:9,stringarrai:8,acur:9,common:10,bytea:[10,2],set:[1,2,4,5,3,7,8,10,9],typnamespac:9,sep:5,see:[2,4,5,3,7,8,10,9],arg:[7,9,11],simpleconnectionpool:11,disadvantag:2,analog:7,someth:[10,9],particip:[3,8,9],altern:[10,2,7],signatur:8,isolation_level_serializ:8,numer:[5,10,2,4,7],isol:[5,3],solv:2,popul:[3,8],both:[5,0,3,7,10],last:[5,6,3],foreign:4,context:[5,10],whole:[10,2],standard_conforming_str:[3,8],simpli:9,point:[5,10,3,8,9],instanti:3,schedul:9,threadsafeti:4,transaction_status_inerror:8,header:5,param:4,backend:[2,4,5,3,8,10],java:10,stamp:4,intervalarrai:8,due:[5,6,8,4],empti:[5,10,8,9],sinc:[10,3,8,4],secret:4,xac:10,strategi:9,xa8:10,strictest:8,look:[2,3,6,7,10,9],xa0:10,xa4:10,histor:[10,7],"while":[10,6,8,9,4],executemani:[5,10,9],behavior:7,error:[3,9],fun:8,loop:[5,2,9],readi:[3,8,9,11],itself:[5,9,11,4],poll_error:8,belong:[3,8],decod:[5,10,3,8],zope:[0,11],mod_wsgi:2,x82:10,optim:5,wherea:10,user:[2,4,5,8,10,9],robust:10,implement:[0,4,5,7,8,9,11],task:8,older:[10,3,2,8],entri:[5,10,2,8],string_typ:8,pickl:1,conn_or_cur:7,expens:11,calcutta:10,"_wrap":8,programmingerror:[4,5,3,7,8,10],propos:[10,9],explan:3,abstractconnectionpool:11,ldd:2,password:4,cur:[2,3,4,5,6,7,8,10,9],commect:5,xe8:10,new_fil:[3,8],input:[5,10,4],subsequ:10,dataerror:4,varchar:10,format:[10,2,8,4],bit:[10,8],characterist:3,status_prepar:8,collect:[5,7],api:9,encount:[2,4],often:[10,8],creation:1,some:[3,6,7,8,10,9],back:[10,3,7],server_vers:3,scale:5,pep:[8,9],per:[5,10,3,9],concaten:10,retri:8,larg:[0,4,5,3,8,9],mxintervalarrai:8,run:[2,5,3,8,10,9],python_egg_cach:2,register_typ:[5,10,2,8,9],status_readi:[3,8],constraint:3,my_uuid:7,rowcount:5,idl:[10,3,2,8],default_transaction_isol:3,block:[3,2,8,9],within:[6,8,3],tpc_commit:[10,3,8],ensur:3,chang:[1,3,4,5,6,7,8,10,9],submit:5,custom:[2,9],pg_sleep:9,includ:[0,3,5,6,8,11],"\u00e0\u00e8\u00ec\u00f2\u00f9":10,suit:7,forward:[5,3],translat:10,line:[10,4],info:9,utc:[10,7,1],utf:2,consist:8,caller:9,readlin:[5,10],similar:[5,7,9,4],constant:[6,3],parser:2,gunpoint:10,doesn:[2,4,7,8,10,9],repres:[3,4,5,6,7,8,10],"char":[8,4],xb9:10,invalid:3,xb2:10,codec:[10,8],pg_config:[2,8],cur2:10,cur1:10,isolation_level_read_commit:8,register_hstor:[10,7],algorithm:3,reansact:8,scroll:[5,10],code:[5,9],queri:[0,2,4,5,3,7,8,9],friendli:[0,9],send:[10,2,8,9],sent:[5,10,3,8,9],rollback:[2,4,5,3,8,10,9],rownumb:5,untouch:5,implicitli:[3,7,9],dbname:[10,4],recip:10,magic:2,button:3,fewer:5,"try":[2,3,4,5,6,10,9],dealt:5,databaseerror:4,pleas:[10,9],uniqu:7,download:7,append:[5,10,3],compat:[3,7,8,9],index:[5,0,3,2,7],compar:[1,4],resembl:10,get_parameter_statu:3,mxinterv:8,timefrompi:8,pydatetimearrai:8,decimalarrai:8,cast_point:9,usag:[0,8],len:8,bodi:5,let:10,becom:9,miser:10,convert:[2,4,5,3,7,8,10,9],convers:[7,8,9],mxdate:8,an_int:10,typic:7,nearest:10,appli:[10,3],nonblock:9,"boolean":[5,0,8,10],"9c0b":7,intervalfrommx:8,from:[0,1,2,3,4,5,6,7,8,9,11],commun:[10,0,3,8,9],doubl:[10,8],upgrad:2,next:[5,3],few:[2,4,5,7,8,9,10,11],inet:9,retriev:[5,10,7,9],alia:[10,3,8],fetch:[5,10,2,7],control:[0,3,8,9,4],malform:10,process:[0,2,4,5,3,8,9],lock:[10,3,9],tab:5,serial:[10,3,8],default_transaction_read_onli:3,conn:[4,3,7,8,9,10,11],instead:[2,5,7,8,10,9],textiobas:5,xc3:10,alloc:[10,4],bind:[5,10,9,4],element:[10,7],issu:[2,5,3,8,10,9],allow:[1,5,3,7,8,10,9],elif:9,move:10,comma:[10,2],pg_prepared_xact:3,copy_expert:[5,10],bunch:2,reilli:[10,8],fixedoffsettimezon:[10,1],therefor:9,recept:[8,9],handl:[5,3,7,8,9],get_transaction_statu:[3,8],spell:9,dai:[10,4],multiprocess:[10,2],somewher:7,dict_cur:7,zpsycopgda:0,trap:[8,4],foo_id_seq:3,chunk:[2,8],postgrespollingstatustyp:8,pqtransactionstatu:3,"static":8,integerarrai:8,our:2,datearrai:8,patch:9,special:[10,7,8,4],out:[0,4,5,7,10,9],variabl:[5,10,2,9,4],pgsql:10,typenam:9,suitabl:[10,3,9],rel:5,rec:7,client_min_messag:3,manipul:[10,8],setinputs:5,dictionari:8,releas:[2,3,6,7,10,9],log:[3,9],unwant:7,could:[10,3,8,9,4],keep:[10,3,2,9,7],length:5,outsid:[5,10,3],retain:5,timezon:[10,8,3,1],date:[10,8,4],owner:[3,8],facil:[7,9],lo_import:[10,3],unknown:[10,8],capac:7,wrapper:[10,0,8,9],attach:8,attack:10,termin:[10,3],boil:9,shell:9,status_begin:8,gotcha:2,fetchmani:[5,10,2],exactli:[5,1],bloat:[10,3],bother:9,structur:[5,10,7],charact:[5,10,6,3],stricter:8,terribl:10,barf:4,have:[2,3,4,5,6,7,8,10,9],reserv:5,need:[2,4,6,7,10,9],tbar:5,mix:10,builtin:[10,3,8],which:[2,3,4,5,6,7,8,10,9],base_cast:8,unless:[5,3,7,9],lobject:[10,3,8],who:8,set_wait_callback:[3,7,8,9],"class":9,request:[3,4],latin9:10,face:7,snapshot:8,determin:5,rowidarrai:8,text:7,pqserververs:3,anywai:7,textual:[5,6],intervalfrompi:8,notsupportederror:[5,3,4],cursor_factori:[3,7,8,9],aval:2,mintimeloggingcursor:7,local:[6,1,3],pyformat:4,enabl:[10,7,9],integr:4,contain:[3,4,5,6,8,10],shh:1,view:[3,8,9],conform:[8,9],statu:3,correctli:[10,3,7],mxdatetimearrai:8,written:[10,8],progress:[3,8],neither:3,kei:[10,3,7,11,4],entir:[5,10,9],group:9,addit:[6,3],minconn:11,equal:[7,4],etc:[3,7,8,4],instanc:[1,3,7,8,10,9],isolation_level_repeatable_read:8,arriv:9,respect:4,unclean:3,poll_writ:[8,9],pgbouncer:3,is_superus:3,compos:[5,3],transaction_status_intran:8,compon:[10,7,8],immedi:[5,10,3],presenc:9,untyp:4,togeth:[3,9],present:4,multi:[0,11],plain:[3,8],defin:[3,9],observ:10,helper:7,almost:2,site:10,lightweight:2,revis:[10,3],parti:9,began:8,member:[3,8],fetchon:[5,10,7,9],infer:6,booleanarrai:8,upon:[8,9],effect:[3,8],pgcode:[6,4],expand:9,off:[7,4],sql_debug:9,well:[10,7],exampl:[2,3,4,5,6,7,8,10,9],command:[2,5,3,7,8,10,9],interpol:10,undefin:2,pqprotocolvers:3,usual:[2,5,6,7,8,10,9],less:6,obtain:[5,10,7,9],tcp:2,connection_factori:[7,8,4],heavili:0,"4ef8":7,web:10,tight:2,add:[7,8],tpc_prepar:[10,3],dql:5,logger:[7,9],match:[5,0,7,8,9],rememb:[10,2],xe0:10,know:[6,8,9,4],xe2:10,desk:10,tick:4,recurs:8,insert:[0,2,4,5,7,10,9],like:[5,6,8],success:11,anyth:[2,7],necessari:[10,8],async:[3,8,9,4],page:[10,0],wrapped_object:8,phenomena:3,gevent:[8,9],"export":[5,10,3,8,4],mxdatearrai:8,proper:[10,9,4],guarante:[3,8],interfaceerror:[5,3,9,4],leak:3,avoid:[3,2,9],leav:[5,2],mode:[2,5,3,8,10,9],importerror:2,"enum":8,pydatetim:8,host:[3,4],offset:[5,8,7,1,10],about:[4,5,8,11,10,9],actual:[5,8],socket:[9,4],column:[4,5,3,7,10,9],freedom:9,new_oid:[3,8],constructor:[0,8],adapt_point:9,discard:[5,3,2,11],disabl:7,own:2,easy_instal:2,automat:[2,3,7,8,9,10,11],dataset:10,guard:10,merg:10,pictur:10,transfer:[10,2,9],u20ac:10,procnam:5,"function":[5,3,9],unexpect:4,keyerror:6,gain:10,count:5,succe:3,made:[5,10,8,9,4],whether:3,wish:9,dml:5,record:[5,10,7],below:[3,8,4],limit:[10,7,8,9,4],otherwis:[10,3,2,8,7],problem:[3,8],"int":[10,0,7],dure:[1,2,4,5,3,8,10],pid:[3,8,9],ing:9,probabl:[5,2,8,9,11],nonetheless:9,detail:[2,4,5,3,8,10,9],other:[2,3,4,5,6,7,8,10,9],lookup:6,futur:[5,9],branch:[10,8],repeat:[3,8],singleton:4,pydatearrai:8,pqcancel:3,timestampfrommx:8,reliabl:10,rule:5,getlogg:9},objtypes:{"0":"py:module","1":"py:class","2":"py:method","3":"py:data","4":"py:exception","5":"py:function","6":"py:attribute"},objnames:{"0":["py","module","Python module"],"1":["py","class","Python class"],"2":["py","method","Python method"],"3":["py","data","Python data"],"4":["py","exception","Python exception"],"5":["py","function","Python function"],"6":["py","attribute","Python attribute"]},filenames:["index","tz","faq","connection","module","cursor","errorcodes","extras","extensions","advanced","usage","pool"],titles:["Psycopg &#8211; PostgreSQL database adapter for Python","<tt class=\"docutils literal\"><span class=\"pre\">psycopg2.tz</span></tt> &#8211;  <tt class=\"docutils literal\"><span class=\"pre\">tzinfo</span></tt> implementations for Psycopg 2","Frequently Asked Questions","The <tt class=\"docutils literal\"><span class=\"pre\">connection</span></tt> class","The <tt class=\"docutils literal\"><span class=\"pre\">psycopg2</span></tt> module content","The <tt class=\"docutils literal\"><span class=\"pre\">cursor</span></tt> class","<tt class=\"docutils literal\"><span class=\"pre\">psycopg2.errorcodes</span></tt> &#8211; Error codes defined by PostgreSQL","<tt class=\"docutils literal\"><span class=\"pre\">psycopg2.extras</span></tt> &#8211; Miscellaneous goodies for Psycopg 2","<tt class=\"docutils literal\"><span class=\"pre\">psycopg2.extensions</span></tt> &#8211; Extensions to the DB API","More advanced topics","Basic module usage","<tt class=\"docutils literal\"><span class=\"pre\">psycopg2.pool</span></tt> &#8211; Connections pooling"],objects:{"":{cursor:[5,1,1,""],psycopg2:[4,0,0,"-"],connection:[3,1,1,""]},"psycopg2.extensions":{MXINTERVALARRAY:[8,3,1,""],TimeFromPy:[8,1,1,""],PYDATETIMEARRAY:[8,3,1,""],TRANSACTION_STATUS_UNKNOWN:[8,3,1,""],TRANSACTION_STATUS_INERROR:[8,3,1,""],new_type:[8,5,1,""],POLL_OK:[8,3,1,""],Xid:[8,1,1,""],MXINTERVAL:[8,3,1,""],INTERVALARRAY:[8,3,1,""],QueryCanceledError:[8,4,1,""],UNICODEARRAY:[8,3,1,""],ISOLATION_LEVEL_READ_UNCOMMITTED:[8,3,1,""],PYTIMEARRAY:[8,3,1,""],DECIMALARRAY:[8,3,1,""],new_array_type:[8,5,1,""],STATUS_PREPARED:[8,3,1,""],PYDATETIME:[8,3,1,""],ISOLATION_LEVEL_AUTOCOMMIT:[8,3,1,""],string_types:[8,3,1,""],FLOAT:[8,3,1,""],MXTIMEARRAY:[8,3,1,""],adapters:[8,3,1,""],STRINGARRAY:[8,3,1,""],IntervalFromMx:[8,1,1,""],encodings:[8,3,1,""],TIMEARRAY:[8,3,1,""],cursor:[8,1,1,""],MXDATEARRAY:[8,3,1,""],INTERVAL:[8,3,1,""],POLL_READ:[8,3,1,""],adapt:[8,5,1,""],UNICODE:[8,3,1,""],INTEGER:[8,3,1,""],INTEGERARRAY:[8,3,1,""],TRANSACTION_STATUS_INTRANS:[8,3,1,""],ISOLATION_LEVEL_READ_COMMITTED:[8,3,1,""],LONGINTEGER:[8,3,1,""],STATUS_BEGIN:[8,3,1,""],STATUS_READY:[8,3,1,""],POLL_WRITE:[8,3,1,""],connection:[8,1,1,""],TIME:[8,3,1,""],MXDATETIMEARRAY:[8,3,1,""],register_adapter:[8,5,1,""],Binary:[8,1,1,""],get_wait_callback:[8,5,1,""],POLL_ERROR:[8,3,1,""],MXTIME:[8,3,1,""],BOOLEANARRAY:[8,3,1,""],PYDATE:[8,3,1,""],FLOATARRAY:[8,3,1,""],PYDATEARRAY:[8,3,1,""],DateFromPy:[8,1,1,""],DECIMAL:[8,3,1,""],PYINTERVALARRAY:[8,3,1,""],DATETIMEARRAY:[8,3,1,""],ISQLQuote:[8,1,1,""],TimeFromMx:[8,1,1,""],TRANSACTION_STATUS_ACTIVE:[8,3,1,""],PYINTERVAL:[8,3,1,""],TransactionRollbackError:[8,4,1,""],DATEARRAY:[8,3,1,""],ROWIDARRAY:[8,3,1,""],TimestampFromMx:[8,1,1,""],BOOLEAN:[8,3,1,""],Notify:[8,1,1,""],AsIs:[8,1,1,""],MXDATE:[8,3,1,""],PYTIME:[8,3,1,""],Float:[8,1,1,""],ISOLATION_LEVEL_REPEATABLE_READ:[8,3,1,""],IntervalFromPy:[8,1,1,""],DATE:[8,3,1,""],TimestampFromPy:[8,1,1,""],STATUS_IN_TRANSACTION:[8,3,1,""],BINARYARRAY:[8,3,1,""],TRANSACTION_STATUS_IDLE:[8,3,1,""],MXDATETIME:[8,3,1,""],lobject:[8,1,1,""],SQL_IN:[8,1,1,""],LONGINTEGERARRAY:[8,3,1,""],QuotedString:[8,1,1,""],set_wait_callback:[8,5,1,""],ISOLATION_LEVEL_SERIALIZABLE:[8,3,1,""],DateFromMx:[8,1,1,""],register_type:[8,5,1,""],Boolean:[8,1,1,""]},"psycopg2.extensions.Xid":{prepared:[8,6,1,""],database:[8,6,1,""],gtrid:[8,6,1,""],owner:[8,6,1,""],format_id:[8,6,1,""],from_string:[8,2,1,""],bqual:[8,6,1,""]},"psycopg2.extras.CompositeCaster":{attnames:[7,6,1,""],name:[7,6,1,""],oid:[7,6,1,""],atttypes:[7,6,1,""],array_oid:[7,6,1,""],type:[7,6,1,""]},"psycopg2.extras":{register_inet:[7,5,1,""],register_uuid:[7,5,1,""],RealDictRow:[7,1,1,""],LoggingConnection:[7,1,1,""],CompositeCaster:[7,1,1,""],register_composite:[7,5,1,""],NamedTupleCursor:[7,1,1,""],DictRow:[7,1,1,""],LoggingCursor:[7,1,1,""],wait_select:[7,5,1,""],MinTimeLoggingConnection:[7,1,1,""],register_tstz_w_secs:[7,5,1,""],DictConnection:[7,1,1,""],RealDictCursor:[7,1,1,""],UUID_adapter:[7,1,1,""],RealDictConnection:[7,1,1,""],MinTimeLoggingCursor:[7,1,1,""],register_hstore:[7,5,1,""],NamedTupleConnection:[7,1,1,""],DictCursor:[7,1,1,""],Inet:[7,1,1,""]},"psycopg2.tz":{LocalTimezone:[1,1,1,""],FixedOffsetTimezone:[1,1,1,""]},psycopg2:{Binary:[4,5,1,""],InternalError:[4,4,1,""],Error:[4,4,1,""],NUMBER:[4,3,1,""],errorcodes:[6,0,0,"-"],connect:[4,5,1,""],threadsafety:[4,3,1,""],tz:[1,0,0,"-"],TimeFromTicks:[4,5,1,""],Timestamp:[4,5,1,""],Warning:[4,4,1,""],Date:[4,5,1,""],ProgrammingError:[4,4,1,""],TimestampFromTicks:[4,5,1,""],DataError:[4,4,1,""],STRING:[4,3,1,""],NotSupportedError:[4,4,1,""],IntegrityError:[4,4,1,""],DATETIME:[4,3,1,""],Time:[4,5,1,""],pool:[11,0,0,"-"],DateFromTicks:[4,5,1,""],BINARY:[4,3,1,""],InterfaceError:[4,4,1,""],paramstyle:[4,3,1,""],extras:[7,0,0,"-"],extensions:[8,0,0,"-"],OperationalError:[4,4,1,""],ROWID:[4,3,1,""],apilevel:[4,3,1,""],DatabaseError:[4,4,1,""]},"psycopg2.pool":{SimpleConnectionPool:[11,1,1,""],PersistentConnectionPool:[11,1,1,""],AbstractConnectionPool:[11,1,1,""],ThreadedConnectionPool:[11,1,1,""]},"psycopg2.extensions.ISQLQuote":{"_wrapped":[8,6,1,""],getquoted:[8,2,1,""],prepare:[8,2,1,""]},"psycopg2.pool.AbstractConnectionPool":{getconn:[11,2,1,""],closeall:[11,2,1,""],putconn:[11,2,1,""]},cursor:{fetchall:[5,2,1,""],rownumber:[5,6,1,""],query:[5,6,1,""],close:[5,2,1,""],withhold:[5,6,1,""],fetchone:[5,2,1,""],copy_expert:[5,2,1,""],tzinfo_factory:[5,6,1,""],setoutputsize:[5,2,1,""],closed:[5,6,1,""],copy_to:[5,2,1,""],callproc:[5,2,1,""],description:[5,6,1,""],setinputsizes:[5,2,1,""],arraysize:[5,6,1,""],fetchmany:[5,2,1,""],itersize:[5,6,1,""],statusmessage:[5,6,1,""],mogrify:[5,2,1,""],execute:[5,2,1,""],executemany:[5,2,1,""],name:[5,6,1,""],nextset:[5,2,1,""],copy_from:[5,2,1,""],cast:[5,2,1,""],connection:[5,6,1,""],lastrowid:[5,6,1,""],rowcount:[5,6,1,""],scroll:[5,2,1,""]},connection:{encoding:[3,6,1,""],isolation_level:[3,6,1,""],set_client_encoding:[3,2,1,""],tpc_commit:[3,2,1,""],cancel:[3,2,1,""],close:[3,2,1,""],poll:[3,2,1,""],autocommit:[3,6,1,""],set_isolation_level:[3,2,1,""],xid:[3,2,1,""],isexecuting:[3,2,1,""],dsn:[3,6,1,""],closed:[3,6,1,""],notices:[3,6,1,""],protocol_version:[3,6,1,""],status:[3,6,1,""],rollback:[3,2,1,""],tpc_rollback:[3,2,1,""],lobject:[3,2,1,""],set_session:[3,2,1,""],get_transaction_status:[3,2,1,""],tpc_prepare:[3,2,1,""],commit:[3,2,1,""],get_parameter_status:[3,2,1,""],server_version:[3,6,1,""],reset:[3,2,1,""],fileno:[3,2,1,""],get_backend_pid:[3,2,1,""],tpc_recover:[3,2,1,""],cursor:[3,2,1,""],tpc_begin:[3,2,1,""],async:[3,6,1,""],notifies:[3,6,1,""]},"psycopg2.Error":{cursor:[4,6,1,""],pgcode:[4,6,1,""],pgerror:[4,6,1,""]},"psycopg2.extensions.Binary":{getquoted:[8,2,1,""]},"psycopg2.errorcodes":{lookup:[6,5,1,""]},"psycopg2.extensions.AsIs":{getquoted:[8,2,1,""]},"psycopg2.extensions.lobject":{truncate:[8,2,1,""],read:[8,2,1,""],oid:[8,6,1,""],write:[8,2,1,""],"export":[8,2,1,""],mode:[8,6,1,""],closed:[8,6,1,""],close:[8,2,1,""],unlink:[8,2,1,""],seek:[8,2,1,""],tell:[8,2,1,""]},"psycopg2.extensions.QuotedString":{getquoted:[8,2,1,""]},"psycopg2.extras.LoggingConnection":{filter:[7,2,1,""],initialize:[7,2,1,""]},"psycopg2.extensions.Notify":{pid:[8,6,1,""],payload:[8,6,1,""],channel:[8,6,1,""]}},titleterms:{code:6,protocol:[10,8],queri:10,syntax:9,composit:7,paramet:10,access:10,uuid:7,zone:[10,7],psycopg2:[1,2,4,6,7,8,11],transact:[10,2,8],except:[8,4],tzinfo:1,real:7,python:[10,0,9],like:7,level:8,server:10,unicod:10,side:10,compil:2,connect:[3,7,8,9,11],pass:10,librari:9,asynchron:9,statu:8,safeti:10,cast:[7,8,9],databas:[0,8],subclass:7,content:4,larg:10,adapt:[10,0,8,9],"new":9,factori:9,advanc:9,usag:10,isol:8,extens:[5,3,8,4],dictionari:7,ask:2,valu:10,addit:[7,8],postgresql:[10,0,6],convers:2,thread:10,coroutin:[7,9],constructor:4,goodi:7,implement:1,frequent:2,extra:7,modul:[10,4],sql:[10,8,9],api:[5,3,8,4],poll:8,from:10,log:7,support:[10,7,9],question:2,two:10,namedtupl:7,fraction:7,basic:10,type:[2,4,7,8,10,9],inet:7,more:9,"function":8,notif:9,practic:2,commit:10,cursor:[5,10,7,9],defin:6,error:6,problem:[10,2],control:10,constant:8,process:10,topic:9,handl:[10,2],best:2,copi:10,object:[10,8,9,4],miscellan:7,deploi:2,phase:10,data:7,"class":[5,3],pool:11,hstore:7,psycopg:[0,7,1],time:[10,7],errorcod:6}})