Re: [Pgpool-general] pgpool detected difference of the number of inserted, updated or deleted tuples.

Wed, 29 Dec 2010 06:22:00 -0800 

Hello,
The attached files contain a sql test case, with the workaround, we used to spot
the problem with the script for parallel queries, sent at previous msg, changing
the sleep time.
the other sql file contains original app logged activity over pgpool.
We modified the php app to include the row locking method only at the needed
code transactions.
I hope these help.
Regards.
Andre Felipe 

begin;
SELECT * from phpgw_config WHERE config_app='phpgwapi'; 
select oid,typname from pg_type; 
SELECT hook_appname, hook_location, hook_filename FROM phpgw_hooks; 
SELECT count(*) FROM phpgw_access_log WHERE account_id=0 AND ip='10.30.200.101' AND li > 1292854948; 
SELECT count(*) FROM phpgw_access_log WHERE account_id=0 AND (loginid='40223115681' OR loginid LIKE '40223115...@%') AND li > 1292854948; 
SELECT acl_location,acl_rights FROM phpgw_acl WHERE acl_appname='phpgw_group' AND acl_account=402231156; 
SELECT * FROM phpgw_acl WHERE acl_account IN (402231156,0,77771001); 
SELECT * FROM phpgw_preferences WHERE preference_owner IN (-1,-2,402231156); 
select message_id,content from phpgw_lang where lang='pt-br,pt;q=0.8,en-us;q=0.5,en;q=0.3' and app_name='common'; 
select message_id,content from phpgw_lang where lang='en' and app_name='common'; 
select message_id,content from phpgw_lang where lang='en' and app_name='login'; 
select * from phpgw_applications where app_enabled != 0 order by app_order asc; 
SELECT acl_location,acl_rights FROM phpgw_acl WHERE acl_appname='phpgw_group' AND acl_account=402231156; 
SELECT acl_appname,acl_rights FROM phpgw_acl WHERE acl_location='run' AND acl_account IN (402231156,77771001); 
commit;
begin ; 
INSERT INTO phpgw_access_log(sessionid,loginid,ip,li,lo,account_id,browser) VALUES ('356262f4651f607b85583966457fd773','40223115681','10.30.200.101',1292855008,0,402231156,'Mozilla/5.0 (X11; U; Linux i686; pt-BR; rv:1.9.0.9) Gecko/2009042113 Ubuntu/8.04 (hardy) Firefox/3.0.9'); 
commit;
begin; 
select * from phpgw_config where config_app='registration'; 
SELECT DISTINCT l.lang,ln.lang_name FROM phpgw_lang l,phpgw_languages ln WHERE l.lang = ln.lang_id; 

commit;
DISCARD ALL; 
begin;
SELECT * from phpgw_config WHERE config_app='phpgwapi'; 
select oid,typname from pg_type; 
SELECT hook_appname, hook_location, hook_filename FROM phpgw_hooks; 
SELECT acl_location,acl_rights FROM phpgw_acl WHERE acl_appname='phpgw_group' AND acl_account=402231156; 
SELECT * FROM phpgw_acl WHERE acl_account IN (402231156,0,77771001); 
SELECT * FROM phpgw_preferences WHERE preference_owner IN (-1,-2,402231156); 
select message_id,content from phpgw_lang where lang='pt-br' and app_name='common'; 
select message_id,content from phpgw_lang where lang='pt-br' and app_name='home'; 
select * from phpgw_applications where app_enabled != 0 order by app_order asc; 
SELECT acl_location,acl_rights FROM phpgw_acl WHERE acl_appname='phpgw_group' AND acl_account=402231156; 
SELECT acl_appname,acl_rights FROM phpgw_acl WHERE acl_location='run' AND acl_account IN (402231156,77771001); 
SELECT acl_account,acl_rights FROM phpgw_acl WHERE acl_appname='addressbook' AND acl_location IN ('402231156','77771001'); 
select trim(sessionid),browser from phpgw_access_log where account_id <> 0 and lo = 0 and sessionid='356262f4651f607b85583966457fd773' limit 1; 
SELECT profileID,smtpServer,smtpType,imapServer,imapType,description FROM phpgw_emailadmin; 
SELECT profileID,smtpServer,smtpType,imapServer,imapType,description FROM phpgw_emailadmin WHERE profileID=1; 
SELECT smtpServer, smtpPort, smtpAuth, smtpType, smtpLDAPServer, smtpLDAPAdminDN, smtpLDAPAdminPW, smtpLDAPBaseDN, smtpLDAPUseDefault, imapServer, imapPort, imapDelimiter, imapType, imapLoginType, imapTLSEncryption, imapTLSAuthentication, imapoldcclient, imapEnableCyrusAdmin, imapAdminUsername, imapAdminPW, imapEnableSieve, imapSieveServer, imapSievePort, imapDefaultTrashFolder, imapDefaultSentFolder, imapDefaultDraftsFolder, imapDefaultSpamFolder, description, defaultDomain, profileID, organisationName, userDefinedAccounts FROM phpgw_emailadmin WHERE profileID=1; 
select message_id,content from phpgw_lang where lang='pt-br' and app_name='expressoMail1_2'; 
select message_id,content from phpgw_lang where lang='pt-br' and app_name='calendar'; 
SELECT acl_account,acl_rights FROM phpgw_acl WHERE acl_appname='calendar' AND acl_location IN ('402231156','77771001'); 
SELECT acl_account,acl_rights FROM phpgw_acl WHERE acl_appname='calendar' AND acl_location IN ('402231156','77771001'); 
commit;
begin ; 
DELETE FROM phpgw_preferences WHERE preference_owner='-2' and preference_app <> 'jabberit_messenger'; 
INSERT INTO phpgw_preferences (preference_owner,preference_app,preference_value) VALUES (-2,'expressoMail','a:21:{s:18:"max_email_per_page";s:2:"25";s:16:"save_deleted_msg";s:1:"1";s:18:"use_local_messages";s:1:"0";s:22:"keep_archived_messages";s:1:"0";s:32:"delete_and_show_previous_message";s:1:"1";s:13:"alert_new_msg";s:1:"1";s:19:"mainscreen_showmail";s:1:"1";s:27:"remove_attachments_function";s:1:"0";s:21:"enable_important_flag";s:1:"0";s:14:"save_in_folder";s:10:"INBOX/Sent";s:12:"hide_folders";s:1:"0";s:11:"line_height";s:2:"20";s:9:"font_size";s:2:"11";s:20:"use_dynamic_contacts";s:1:"0";s:13:"use_shortcuts";s:1:"0";s:15:"auto_save_draft";s:1:"0";s:10:"image_size";s:5:"65536";s:28:"use_signature_digital_cripto";s:1:"0";s:14:"type_signature";s:4:"text";s:19:"preview_msg_subject";s:1:"0";s:15:"preview_msg_tip";s:1:"0";}'); 
INSERT INTO phpgw_preferences (preference_owner,preference_app,preference_value) VALUES (-2,'calendar','a:24:{s:15:"defaultcalendar";s:4:"week";s:21:"mainscreen_showevents";s:1:"0";s:7:"summary";s:2:"no";s:15:"receive_updates";s:2:"no";s:13:"update_format";s:8:"extended";s:11:"notifyAdded";s:113:"Evento do calend�rio - $$action$$: $$startdate$$ $$title$$ 
 Voc� possui um compromisso agendado para $$startdate$$";s:14:"notifyCanceled";s:116:"Evento do calend�rio - $$action$$: $$startdate$$ $$title$$ 
 Seu compromisso agendado para $$startdate$$ foi cancelado";s:14:"notifyModified";s:133:"Evento do calend�rio - $$action$$: $$startdate$$ $$title$$ 
 Seu compromisso agendado para $$olddate$$ foi remarcado para $$startdate$$";s:14:"notifyResponse";s:140:"Evento do calend�rio - $$action$$: $$startdate$$ $$title$$ 
 Em $$date$$ $$fullname$$ $$action$$ sua requisi��o de encontro para $$startdate$$";s:11:"notifyAlarm";s:85:"Alarme para $$title$$ em $$startdate$$ na $$location$$ 
 Aqui est� o alarme solicitado.";s:13:"show_rejected";s:1:"0";s:14:"display_status";s:1:"1";s:13:"weekdaystarts";s:6:"Monday";s:13:"workdaystarts";s:1:"9";s:11:"workdayends";s:2:"17";s:8:"interval";s:2:"30";s:13:"defaultlength";s:2:"60";s:24:"planner_start_with_group";s:9:"777771001";s:25:"planner_intervals_per_day";s:1:"4";s:13:"defaultfilter";s:3:"all";s:15:"default_private";s:1:"0";s:16:"display_minicals";s:1:"1";s:17:"print_black_white";s:1:"0";s:19:"hide_event_conflict";s:1:"0";}'); 
commit;
begin; 
SELECT count(*) FROM phpgw_cal_holidays WHERE locale='' AND (occurence < 1900 OR occurence = 2010); 
SELECT * FROM phpgw_cal_holidays WHERE locale IN ('BR') AND (occurence < 1900 OR occurence = 2010) ORDER BY month_num,mday; 
SELECT DISTINCT phpgw_cal.cal_id,phpgw_cal.datetime,phpgw_cal.edatetime,phpgw_cal.priority FROM phpgw_cal_user, phpgw_cal WHERE (phpgw_cal_user.cal_id = phpgw_cal.cal_id)   AND (phpgw_cal_user.cal_login in (402231156)) AND ( ( (phpgw_cal.datetime >= 1292810400) AND (phpgw_cal.edatetime <= 1293501599) ) OR ( (phpgw_cal.datetime <= 1292810400) AND (phpgw_cal.edatetime >= 1293501599) ) OR ( (phpgw_cal.datetime >= 1292810400) AND (phpgw_cal.datetime <= 1293501599) AND (phpgw_cal.edatetime >= 1293501599) ) OR ( (phpgw_cal.datetime <= 1292810400) AND (phpgw_cal.edatetime >= 1292810400) AND (phpgw_cal.edatetime <= 1293501599) ) ) ORDER BY phpgw_cal.datetime ASC, phpgw_cal.edatetime ASC, phpgw_cal.priority ASC; 
SELECT DISTINCT phpgw_cal.cal_id,phpgw_cal.datetime,phpgw_cal.edatetime,phpgw_cal.priority FROM phpgw_cal_user, phpgw_cal, phpgw_cal_repeats WHERE (phpgw_cal_user.cal_id = phpgw_cal.cal_id) AND (phpgw_cal_repeats.cal_id = phpgw_cal.cal_id) AND phpgw_cal.cal_type='M' AND phpgw_cal_user.cal_login IN (402231156) AND (phpgw_cal_repeats.recur_enddate >= 1292810400 OR phpgw_cal_repeats.recur_enddate=0) ORDER BY phpgw_cal.datetime ASC, phpgw_cal.edatetime ASC, phpgw_cal.priority ASC; 
commit;
 DISCARD ALL; 
DISCARD ALL; 
begin;
SELECT * from phpgw_config WHERE config_app='phpgwapi'; 
select oid,typname from pg_type; 
SELECT hook_appname, hook_location, hook_filename FROM phpgw_hooks; 
SELECT acl_location,acl_rights FROM phpgw_acl WHERE acl_appname='phpgw_group' AND acl_account=402231156; 
SELECT * FROM phpgw_acl WHERE acl_account IN (402231156,0,77771001); 
SELECT * FROM phpgw_preferences WHERE preference_owner IN (-1,-2,402231156); 
select message_id,content from phpgw_lang where lang='pt-br' and app_name='common'; 
select message_id,content from phpgw_lang where lang='pt-br' and app_name='logout'; 
select * from phpgw_applications where app_enabled != 0 order by app_order asc; 
SELECT acl_location,acl_rights FROM phpgw_acl WHERE acl_appname='phpgw_group' AND acl_account=402231156; 
SELECT acl_appname,acl_rights FROM phpgw_acl WHERE acl_location='run' AND acl_account IN (402231156,77771001); 
UPDATE phpgw_access_log SET lo=1292855009 WHERE sessionid='356262f4651f607b85583966457fd773'; 
commit;
 DISCARD ALL; 
begin;
SELECT * from phpgw_config WHERE config_app='phpgwapi'; 
select oid,typname from pg_type; 
SELECT hook_appname, hook_location, hook_filename FROM phpgw_hooks; 
SELECT * FROM phpgw_preferences WHERE preference_owner IN (-1,-2,402231156); 
select message_id,content from phpgw_lang where lang='pt-br,pt;q=0.8,en-us;q=0.5,en;q=0.3' and app_name='common'; 
select message_id,content from phpgw_lang where lang='en' and app_name='common'; 
select message_id,content from phpgw_lang where lang='en' and app_name='login'; 
select message_id,content from phpgw_lang where lang='pt-br' and app_name='common'; 
select message_id,content from phpgw_lang where lang='pt-br' and app_name='login'; 
select message_id,content from phpgw_lang where lang='pt-br' and app_name='loginscreen'; 
select message_id,content from phpgw_lang where lang='en' and app_name='loginscreen'; 
select * from phpgw_config where config_app='registration'; 
SELECT DISTINCT l.lang,ln.lang_name
 FROM phpgw_lang l,phpgw_languages ln WHERE l.lang = ln.lang_id; 
commit;
DISCARD ALL; 



begin;
lock table phpgw_access_log, phpgw_preferences in share row exclusive mode;


SELECT * from phpgw_config WHERE config_app='phpgwapi'; 
select oid,typname from pg_type; 
SELECT hook_appname, hook_location, hook_filename FROM phpgw_hooks; 
SELECT count(*) FROM phpgw_access_log WHERE account_id=0 AND ip='10.30.200.101' AND li > 1292854948; 
SELECT count(*) FROM phpgw_access_log WHERE account_id=0 AND (loginid='40223115681' OR loginid LIKE '40223115...@%') AND li > 1292854948; 
SELECT acl_location,acl_rights FROM phpgw_acl WHERE acl_appname='phpgw_group' AND acl_account=402231156; 
SELECT * FROM phpgw_acl WHERE acl_account IN (402231156,0,77771001); 
SELECT * FROM phpgw_preferences WHERE preference_owner IN (-1,-2,402231156); 
select message_id,content from phpgw_lang where lang='pt-br,pt;q=0.8,en-us;q=0.5,en;q=0.3' and app_name='common'; 
select message_id,content from phpgw_lang where lang='en' and app_name='common'; 
select message_id,content from phpgw_lang where lang='en' and app_name='login'; 
select * from phpgw_applications where app_enabled != 0 order by app_order asc; 
SELECT acl_location,acl_rights FROM phpgw_acl WHERE acl_appname='phpgw_group' AND acl_account=402231156; 
SELECT acl_appname,acl_rights FROM phpgw_acl WHERE acl_location='run' AND acl_account IN (402231156,77771001); 


INSERT INTO phpgw_access_log(sessionid,loginid,ip,li,lo,account_id,browser) VALUES ('356262f4651f607b85583966457fd773','40223115681','10.30.200.101',1292855008,0,402231156,'Mozilla/5.0 (X11; U; Linux i686; pt-BR; rv:1.9.0.9) Gecko/2009042113 Ubuntu/8.04 (hardy) Firefox/3.0.9'); 


select * from phpgw_config where config_app='registration'; 
SELECT DISTINCT l.lang,ln.lang_name FROM phpgw_lang l,phpgw_languages ln WHERE l.lang = ln.lang_id; 


SELECT * from phpgw_config WHERE config_app='phpgwapi'; 
select oid,typname from pg_type; 
SELECT hook_appname, hook_location, hook_filename FROM phpgw_hooks; 
SELECT acl_location,acl_rights FROM phpgw_acl WHERE acl_appname='phpgw_group' AND acl_account=402231156; 
SELECT * FROM phpgw_acl WHERE acl_account IN (402231156,0,77771001); 
SELECT * FROM phpgw_preferences WHERE preference_owner IN (-1,-2,402231156); 
select message_id,content from phpgw_lang where lang='pt-br' and app_name='common'; 
select message_id,content from phpgw_lang where lang='pt-br' and app_name='home'; 
select * from phpgw_applications where app_enabled != 0 order by app_order asc; 
SELECT acl_location,acl_rights FROM phpgw_acl WHERE acl_appname='phpgw_group' AND acl_account=402231156; 
SELECT acl_appname,acl_rights FROM phpgw_acl WHERE acl_location='run' AND acl_account IN (402231156,77771001); 
SELECT acl_account,acl_rights FROM phpgw_acl WHERE acl_appname='addressbook' AND acl_location IN ('402231156','77771001'); 
select trim(sessionid),browser from phpgw_access_log where account_id <> 0 and lo = 0 and sessionid='356262f4651f607b85583966457fd773' limit 1; 
SELECT profileID,smtpServer,smtpType,imapServer,imapType,description FROM phpgw_emailadmin; 
SELECT profileID,smtpServer,smtpType,imapServer,imapType,description FROM phpgw_emailadmin WHERE profileID=1; 
SELECT smtpServer, smtpPort, smtpAuth, smtpType, smtpLDAPServer, smtpLDAPAdminDN, smtpLDAPAdminPW, smtpLDAPBaseDN, smtpLDAPUseDefault, imapServer, imapPort, imapDelimiter, imapType, imapLoginType, imapTLSEncryption, imapTLSAuthentication, imapoldcclient, imapEnableCyrusAdmin, imapAdminUsername, imapAdminPW, imapEnableSieve, imapSieveServer, imapSievePort, imapDefaultTrashFolder, imapDefaultSentFolder, imapDefaultDraftsFolder, imapDefaultSpamFolder, description, defaultDomain, profileID, organisationName, userDefinedAccounts FROM phpgw_emailadmin WHERE profileID=1; 
select message_id,content from phpgw_lang where lang='pt-br' and app_name='expressoMail1_2'; 
select message_id,content from phpgw_lang where lang='pt-br' and app_name='calendar'; 
SELECT acl_account,acl_rights FROM phpgw_acl WHERE acl_appname='calendar' AND acl_location IN ('402231156','77771001'); 
SELECT acl_account,acl_rights FROM phpgw_acl WHERE acl_appname='calendar' AND acl_location IN ('402231156','77771001'); 


DELETE FROM phpgw_preferences WHERE preference_owner='-2' and preference_app <> 'jabberit_messenger'; 
INSERT INTO phpgw_preferences (preference_owner,preference_app,preference_value) VALUES (-2,'expressoMail','a:21:{s:18:"max_email_per_page";s:2:"25";s:16:"save_deleted_msg";s:1:"1";s:18:"use_local_messages";s:1:"0";s:22:"keep_archived_messages";s:1:"0";s:32:"delete_and_show_previous_message";s:1:"1";s:13:"alert_new_msg";s:1:"1";s:19:"mainscreen_showmail";s:1:"1";s:27:"remove_attachments_function";s:1:"0";s:21:"enable_important_flag";s:1:"0";s:14:"save_in_folder";s:10:"INBOX/Sent";s:12:"hide_folders";s:1:"0";s:11:"line_height";s:2:"20";s:9:"font_size";s:2:"11";s:20:"use_dynamic_contacts";s:1:"0";s:13:"use_shortcuts";s:1:"0";s:15:"auto_save_draft";s:1:"0";s:10:"image_size";s:5:"65536";s:28:"use_signature_digital_cripto";s:1:"0";s:14:"type_signature";s:4:"text";s:19:"preview_msg_subject";s:1:"0";s:15:"preview_msg_tip";s:1:"0";}'); 
INSERT INTO phpgw_preferences (preference_owner,preference_app,preference_value) VALUES (-2,'calendar','a:24:{s:15:"defaultcalendar";s:4:"week";s:21:"mainscreen_showevents";s:1:"0";s:7:"summary";s:2:"no";s:15:"receive_updates";s:2:"no";s:13:"update_format";s:8:"extended";s:11:"notifyAdded";s:113:"Evento do calend�rio - $$action$$: $$startdate$$ $$title$$ 
 Voc� possui um compromisso agendado para $$startdate$$";s:14:"notifyCanceled";s:116:"Evento do calend�rio - $$action$$: $$startdate$$ $$title$$ 
 Seu compromisso agendado para $$startdate$$ foi cancelado";s:14:"notifyModified";s:133:"Evento do calend�rio - $$action$$: $$startdate$$ $$title$$ 
 Seu compromisso agendado para $$olddate$$ foi remarcado para $$startdate$$";s:14:"notifyResponse";s:140:"Evento do calend�rio - $$action$$: $$startdate$$ $$title$$ 
 Em $$date$$ $$fullname$$ $$action$$ sua requisi��o de encontro para $$startdate$$";s:11:"notifyAlarm";s:85:"Alarme para $$title$$ em $$startdate$$ na $$location$$ 
 Aqui est� o alarme solicitado.";s:13:"show_rejected";s:1:"0";s:14:"display_status";s:1:"1";s:13:"weekdaystarts";s:6:"Monday";s:13:"workdaystarts";s:1:"9";s:11:"workdayends";s:2:"17";s:8:"interval";s:2:"30";s:13:"defaultlength";s:2:"60";s:24:"planner_start_with_group";s:9:"777771001";s:25:"planner_intervals_per_day";s:1:"4";s:13:"defaultfilter";s:3:"all";s:15:"default_private";s:1:"0";s:16:"display_minicals";s:1:"1";s:17:"print_black_white";s:1:"0";s:19:"hide_event_conflict";s:1:"0";}'); 


SELECT count(*) FROM phpgw_cal_holidays WHERE locale='' AND (occurence < 1900 OR occurence = 2010); 
SELECT * FROM phpgw_cal_holidays WHERE locale IN ('BR') AND (occurence < 1900 OR occurence = 2010) ORDER BY month_num,mday; 
SELECT DISTINCT phpgw_cal.cal_id,phpgw_cal.datetime,phpgw_cal.edatetime,phpgw_cal.priority FROM phpgw_cal_user, phpgw_cal WHERE (phpgw_cal_user.cal_id = phpgw_cal.cal_id)   AND (phpgw_cal_user.cal_login in (402231156)) AND ( ( (phpgw_cal.datetime >= 1292810400) AND (phpgw_cal.edatetime <= 1293501599) ) OR ( (phpgw_cal.datetime <= 1292810400) AND (phpgw_cal.edatetime >= 1293501599) ) OR ( (phpgw_cal.datetime >= 1292810400) AND (phpgw_cal.datetime <= 1293501599) AND (phpgw_cal.edatetime >= 1293501599) ) OR ( (phpgw_cal.datetime <= 1292810400) AND (phpgw_cal.edatetime >= 1292810400) AND (phpgw_cal.edatetime <= 1293501599) ) ) ORDER BY phpgw_cal.datetime ASC, phpgw_cal.edatetime ASC, phpgw_cal.priority ASC; 
SELECT DISTINCT phpgw_cal.cal_id,phpgw_cal.datetime,phpgw_cal.edatetime,phpgw_cal.priority FROM phpgw_cal_user, phpgw_cal, phpgw_cal_repeats WHERE (phpgw_cal_user.cal_id = phpgw_cal.cal_id) AND (phpgw_cal_repeats.cal_id = phpgw_cal.cal_id) AND phpgw_cal.cal_type='M' AND phpgw_cal_user.cal_login IN (402231156) AND (phpgw_cal_repeats.recur_enddate >= 1292810400 OR phpgw_cal_repeats.recur_enddate=0) ORDER BY phpgw_cal.datetime ASC, phpgw_cal.edatetime ASC, phpgw_cal.priority ASC; 


SELECT * from phpgw_config WHERE config_app='phpgwapi'; 
select oid,typname from pg_type; 
SELECT hook_appname, hook_location, hook_filename FROM phpgw_hooks; 
SELECT acl_location,acl_rights FROM phpgw_acl WHERE acl_appname='phpgw_group' AND acl_account=402231156; 
SELECT * FROM phpgw_acl WHERE acl_account IN (402231156,0,77771001); 
SELECT * FROM phpgw_preferences WHERE preference_owner IN (-1,-2,402231156); 
select message_id,content from phpgw_lang where lang='pt-br' and app_name='common'; 
select message_id,content from phpgw_lang where lang='pt-br' and app_name='logout'; 
select * from phpgw_applications where app_enabled != 0 order by app_order asc; 
SELECT acl_location,acl_rights FROM phpgw_acl WHERE acl_appname='phpgw_group' AND acl_account=402231156; 
SELECT acl_appname,acl_rights FROM phpgw_acl WHERE acl_location='run' AND acl_account IN (402231156,77771001); 
UPDATE phpgw_access_log SET lo=1292855009 WHERE sessionid='356262f4651f607b85583966457fd773'; 


SELECT * from phpgw_config WHERE config_app='phpgwapi'; 
select oid,typname from pg_type; 
SELECT hook_appname, hook_location, hook_filename FROM phpgw_hooks; 
SELECT * FROM phpgw_preferences WHERE preference_owner IN (-1,-2,402231156); 
select message_id,content from phpgw_lang where lang='pt-br,pt;q=0.8,en-us;q=0.5,en;q=0.3' and app_name='common'; 
select message_id,content from phpgw_lang where lang='en' and app_name='common'; 
select message_id,content from phpgw_lang where lang='en' and app_name='login'; 
select message_id,content from phpgw_lang where lang='pt-br' and app_name='common'; 
select message_id,content from phpgw_lang where lang='pt-br' and app_name='login'; 
select message_id,content from phpgw_lang where lang='pt-br' and app_name='loginscreen'; 
select message_id,content from phpgw_lang where lang='en' and app_name='loginscreen'; 
select * from phpgw_config where config_app='registration'; 
SELECT DISTINCT l.lang,ln.lang_name
 FROM phpgw_lang l,phpgw_languages ln WHERE l.lang = ln.lang_id; 
commit;
DISCARD ALL;

Attachment: script_test_parallel_queries.sh
Description: Bourne shell script

_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general

Reply via email to