Hi,
I am confronting this error (I pasted below). It gives a hint to increase "You might need to increase max_locks_per_transaction" which I did but get the same error .... please please suggest me something to get rid of this error.. I would really be grateful..My script create 13000 empty tables. Each table contains 130 attributes...
My server has 8 GB RAM 64 bit processor, running windows 7 OS
Best regards,
Rafiq
WARNING: out of shared memory
CONTEXT: SQL statement "CREATE TABLE table3691 (cust_id integer,archiveexpiration date,archivedatetime timestamp,archivepurge date,cancelrequestdatetime timestamp,
sndaddress TEXT,sndtype TEXT,rcpcompany TEXT,rcpname TEXT,sndaccount TEXT,sndcompany TEXT,sndname TEXT,
sub_date_time timestamp,acc_date_time timestamp,senddatetime timestamp,conv_date_time timestamp,
comp_date_time timestamp,call_cost integer,totalcallcost integer,valid_date_time timestamp,
lstry_date_time timestamp,ntry_date_time timestamp,deferred_c integer,state integer,dist_lastwrite timestamp,
dist_num integer,dist_version integer,dist_owner_date_time timestamp,dist_aborted integer,dist_abortedcount integer,
contflag integer,statuscode integer,previewmessage integer,previewvisible integer,status_str text,max_rtry integer,
n_tries integer,msn integer,deleted integer,subjet text,archiveduration integer,priority integer,def_date_time timestamp,
ident text,estimprice integer,estimpriceunit integer,realprice integer,realpriceunit integer,contractid text,mainaccountid text,
processinglabel text,viewed integer,notif integer,notifindex integer,purged integer,arcmsn integer,arstate integer,arcsavfile text,
prgf_date_time timestamp,prgr_date_time timestamp,remotemsn integer,delegatedsend integer,delegatedcancelled integer,
delegationsyncid text,delegatesyncid text,remotenetworkport integer,remotenetworkprotocol text,
vld_date_time timestamp,valid_ownerid text,validationstate text,ownerpb text,srcruid text,originaljobid text,resultflowid text,workflowid text,
usercomment text,n_pages integer,page_produced integer,pages_sent integer,groupkey text,isbillable text,retrievedbyclient text,billing_summary text,parentprocessid text,processid text,rcv_date_time timestamp,forceupdatecount integer,forwardsuccess integer,forwarfailed integer,forwardcancelled integer,forwarderror integer,forwardvalidationopending integer,needvalid integer,preferredvalid text,sendtype text,srcfilename text,al_templateinstance integer,al_templateinstancepostcover integer,al_numpage integer,al_numpagepostcover integer,
al_distance integer,vldor_date_time timestamp,validor_ownerid text,validor_cookie text,appname text,nbheaderfields integer,nbtablefields integer,ootoenable integer,warning_date_time timestamp,denyquickvalidation integer,docid text,department text,flowid text,satid text,lbserver text,dist_file integer,writablewhencomplete integer,donotpurge integer,lastsaved_date_time timestamp,lastsaved_ownerid text,
lastsaved_ownerpd text,autolearning timestamp,coverpagecount integer,split integer,splitdone integer,splitdocumentcount integer,splitdocumentnumber integer,touchless integer,
touchlessdone integer,flattenannotations integer,flattencomment integer,toto text,supplementaryrule text,iscclose integer,statusonexpiration integer,waitingforupdate integer,
from_ownerid text,originalfrom_ownerid text)"
PL/pgSQL function table_data(integer,integer,integer) line 34 at EXECUTE statement
ERROR: out of shared memory
HINT: You might need to increase max_locks_per_transaction.
CONTEXT: SQL statement "CREATE TABLE table3691 (cust_id integer,archiveexpiration date,archivedatetime timestamp,archivepurge date,cancelrequestdatetime timestamp,
sndaddress TEXT,sndtype TEXT,rcpcompany TEXT,rcpname TEXT,sndaccount TEXT,sndcompany TEXT,sndname TEXT,
sub_date_time timestamp,acc_date_time timestamp,senddatetime timestamp,conv_date_time timestamp,
comp_date_time timestamp,call_cost integer,totalcallcost integer,valid_date_time timestamp,
lstry_date_time timestamp,ntry_date_time timestamp,deferred_c integer,state integer,dist_lastwrite timestamp,
dist_num integer,dist_version integer,dist_owner_date_time timestamp,dist_aborted integer,dist_abortedcount integer,
contflag integer,statuscode integer,previewmessage integer,previewvisible integer,status_str text,max_rtry integer,
n_tries integer,msn integer,deleted integer,subjet text,archiveduration integer,priority integer,def_date_time timestamp,
ident text,estimprice integer,estimpriceunit integer,realprice integer,realpriceunit integer,contractid text,mainaccountid text,
processinglabel text,viewed integer,notif integer,notifindex integer,purged integer,arcmsn integer,arstate integer,arcsavfile text,
prgf_date_time timestamp,prgr_date_time timestamp,remotemsn integer,delegatedsend integer,delegatedcancelled integer,
delegationsyncid text,delegatesyncid text,remotenetworkport integer,remotenetworkprotocol text,
vld_date_time timestamp,valid_ownerid text,validationstate text,ownerpb text,srcruid text,originaljobid text,resultflowid text,workflowid text,
usercomment text,n_pages integer,page_produced integer,pages_sent integer,groupkey text,isbillable text,retrievedbyclient text,billing_summary text,parentprocessid text,processid text,rcv_date_time timestamp,forceupdatecount integer,forwardsuccess integer,forwarfailed integer,forwardcancelled integer,forwarderror integer,forwardvalidationopending integer,needvalid integer,preferredvalid text,sendtype text,srcfilename text,al_templateinstance integer,al_templateinstancepostcover integer,al_numpage integer,al_numpagepostcover integer,
al_distance integer,vldor_date_time timestamp,validor_ownerid text,validor_cookie text,appname text,nbheaderfields integer,nbtablefields integer,ootoenable integer,warning_date_time timestamp,denyquickvalidation integer,docid text,department text,flowid text,satid text,lbserver text,dist_file integer,writablewhencomplete integer,donotpurge integer,lastsaved_date_time timestamp,lastsaved_ownerid text,
lastsaved_ownerpd text,autolearning timestamp,coverpagecount integer,split integer,splitdone integer,splitdocumentcount integer,splitdocumentnumber integer,touchless integer,
touchlessdone integer,flattenannotations integer,flattencomment integer,toto text,supplementaryrule text,iscclose integer,statusonexpiration integer,waitingforupdate integer,
from_ownerid text,originalfrom_ownerid text)"
PL/pgSQL function table_data(integer,integer,integer) line 34 at EXECUTE statement
********** Error **********
ERROR: out of shared memory
SQL state: 53200
Hint: You might need to increase max_locks_per_transaction.
Context: SQL statement "CREATE TABLE table3691 (cust_id integer,archiveexpiration date,archivedatetime timestamp,archivepurge date,cancelrequestdatetime timestamp,
sndaddress TEXT,sndtype TEXT,rcpcompany TEXT,rcpname TEXT,sndaccount TEXT,sndcompany TEXT,sndname TEXT,
sub_date_time timestamp,acc_date_time timestamp,senddatetime timestamp,conv_date_time timestamp,
comp_date_time timestamp,call_cost integer,totalcallcost integer,valid_date_time timestamp,
lstry_date_time timestamp,ntry_date_time timestamp,deferred_c integer,state integer,dist_lastwrite timestamp,
dist_num integer,dist_version integer,dist_owner_date_time timestamp,dist_aborted integer,dist_abortedcount integer,
contflag integer,statuscode integer,previewmessage integer,previewvisible integer,status_str text,max_rtry integer,
n_tries integer,msn integer,deleted integer,subjet text,archiveduration integer,priority integer,def_date_time timestamp,
ident text,estimprice integer,estimpriceunit integer,realprice integer,realpriceunit integer,contractid text,mainaccountid text,
processinglabel text,viewed integer,notif integer,notifindex integer,purged integer,arcmsn integer,arstate integer,arcsavfile text,
prgf_date_time timestamp,prgr_date_time timestamp,remotemsn integer,delegatedsend integer,delegatedcancelled integer,
delegationsyncid text,delegatesyncid text,remotenetworkport integer,remotenetworkprotocol text,
vld_date_time timestamp,valid_ownerid text,validationstate text,ownerpb text,srcruid text,originaljobid text,resultflowid text,workflowid text,
usercomment text,n_pages integer,page_produced integer,pages_sent integer,groupkey text,isbillable text,retrievedbyclient text,billing_summary text,parentprocessid text,processid text,rcv_date_time timestamp,forceupdatecount integer,forwardsuccess integer,forwarfailed integer,forwardcancelled integer,forwarderror integer,forwardvalidationopending integer,needvalid integer,preferredvalid text,sendtype text,srcfilename text,al_templateinstance integer,al_templateinstancepostcover integer,al_numpage integer,al_numpagepostcover integer,
al_distance integer,vldor_date_time timestamp,validor_ownerid text,validor_cookie text,appname text,nbheaderfields integer,nbtablefields integer,ootoenable integer,warning_date_time timestamp,denyquickvalidation integer,docid text,department text,flowid text,satid text,lbserver text,dist_file integer,writablewhencomplete integer,donotpurge integer,lastsaved_date_time timestamp,lastsaved_ownerid text,
lastsaved_ownerpd text,autolearning timestamp,coverpagecount integer,split integer,splitdone integer,splitdocumentcount integer,splitdocumentnumber integer,touchless integer,
touchlessdone integer,flattenannotations integer,flattencomment integer,toto text,supplementaryrule text,iscclose integer,statusonexpiration integer,waitingforupdate integer,
from_ownerid text,originalfrom_ownerid text)"
PL/pgSQL function table_data(integer,integer,integer) line 34 at EXECUTE statement
