2005-06-30 06:26:00 [27961] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:26:00 [27961] TRACE:  Connexion autorisée : utilisateur=sodipro base de données=sodipro
2005-06-30 06:26:00 [27961] TRACE:  instruction : select count(*) from article where  ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
2005-06-30 06:26:00 [27961] TRACE:  instruction : select oid from pg_ts_cfg where ts_name = $1
2005-06-30 06:26:00 [27961] TRACE:  instruction : select prs_name from pg_ts_cfg where oid = $1
2005-06-30 06:26:00 [27961] TRACE:  instruction : select lt.tokid, pg_ts_cfgmap.dict_name from pg_ts_cfgmap, pg_ts_cfg, token_type( $1 ) as lt where lt.alias = pg_ts_cfgmap.tok_alias and pg_ts_cfgmap.ts_name = pg_ts_cfg.ts_name and pg_ts_cfg.oid= $2 order by lt.tokid desc;
2005-06-30 06:26:00 [27961] TRACE:  instruction : select oid from pg_ts_parser where prs_name = $1
2005-06-30 06:26:00 [27961] TRACE:  instruction : select prs_start, prs_nexttoken, prs_end, prs_lextype, prs_headline from pg_ts_parser where oid = $1
2005-06-30 06:26:00 [27961] TRACE:  instruction : select oid from pg_ts_dict where dict_name = $1
2005-06-30 06:26:00 [27961] TRACE:  instruction : select dict_init, dict_initoption, dict_lexize from pg_ts_dict where oid = $1
2005-06-30 06:26:01 [27961] TRACE:  instruction : select ar_code,ar_code_aff,
	    				coalesce(ar_lib_sodipro_fr,ar_lib_fr,ar_lib_en) as libelle,
	    	        	COALESCE(ar_texte_fr,ar_texte_en) as description,
	            		ar_type,
	    				prix_article_client(ar_code,'',1) as ar_prix
	    			from article
	            	where ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
	            	limit 10 OFFSET 0
2005-06-30 06:26:01 [27961] TRACE:  instruction : SELECT   $1  is null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 21 at if
2005-06-30 06:26:01 [27961] TRACE:  instruction : SELECT  cl_code,cl_groupe_prix,cl_groupe_rem from client where cl_code= $1  and  $2  is not null and  $3  <>''
CONTEXTE :  PL/pgSQL function "prix_article_client" line 25 at select into variables
2005-06-30 06:26:01 [27961] TRACE:  instruction : SELECT  ga_code from article where ar_code= $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 30 at select into variables
2005-06-30 06:26:01 [27961] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 31 at if
2005-06-30 06:26:01 [27961] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 37 at if
2005-06-30 06:26:01 [27961] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 45 at if
2005-06-30 06:26:01 [27961] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 53 at if
2005-06-30 06:26:01 [27961] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 62 at if
2005-06-30 06:26:01 [27961] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 71 at if
2005-06-30 06:26:01 [27961] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 80 at if
2005-06-30 06:26:01 [27961] TRACE:  instruction : SELECT prix_article_public( $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:26:01 [27961] TRACE:  instruction : SELECT  _recherche_prix('Tous les clients',null, $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:26:01 [27961] TRACE:  instruction : SELECT  coalesce( $1 ,0)=0
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 11 at if
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:26:01 [27961] TRACE:  instruction : SELECT  np_pu FROM nav_prix WHERE np_type_vente= $1  AND coalesce(np_code_vente,'') = coalesce( $2 ,'') AND np_ar_code= $3  AND ( (np_date_deb <= current_date and current_date <= np_date_fin) OR (np_date_deb is null and current_date <= np_date_fin) OR (np_date_deb <= current_date and np_date_fin is null) OR (np_date_deb is null and np_date_fin is null) ) AND  $4  >= np_qte_mini order by np_qte_mini desc,np_date_deb desc
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 15 at select into variables
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:26:01 [27961] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 27 at return
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:26:01 [27961] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 90 at if
2005-06-30 06:26:01 [27961] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 91 at return
2005-06-30 06:27:01 [27964] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:27:01 [27964] TRACE:  Connexion autorisée : utilisateur=sodipro base de données=sodipro
2005-06-30 06:27:01 [27964] TRACE:  instruction : select count(*) from article where  ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
2005-06-30 06:27:01 [27964] TRACE:  instruction : select oid from pg_ts_cfg where ts_name = $1
2005-06-30 06:27:01 [27964] TRACE:  instruction : select prs_name from pg_ts_cfg where oid = $1
2005-06-30 06:27:01 [27964] TRACE:  instruction : select lt.tokid, pg_ts_cfgmap.dict_name from pg_ts_cfgmap, pg_ts_cfg, token_type( $1 ) as lt where lt.alias = pg_ts_cfgmap.tok_alias and pg_ts_cfgmap.ts_name = pg_ts_cfg.ts_name and pg_ts_cfg.oid= $2 order by lt.tokid desc;
2005-06-30 06:27:01 [27964] TRACE:  instruction : select oid from pg_ts_parser where prs_name = $1
2005-06-30 06:27:01 [27964] TRACE:  instruction : select prs_start, prs_nexttoken, prs_end, prs_lextype, prs_headline from pg_ts_parser where oid = $1
2005-06-30 06:27:01 [27964] TRACE:  instruction : select oid from pg_ts_dict where dict_name = $1
2005-06-30 06:27:01 [27964] TRACE:  instruction : select dict_init, dict_initoption, dict_lexize from pg_ts_dict where oid = $1
2005-06-30 06:27:02 [27964] TRACE:  instruction : select ar_code,ar_code_aff,
	    				coalesce(ar_lib_sodipro_fr,ar_lib_fr,ar_lib_en) as libelle,
	    	        	COALESCE(ar_texte_fr,ar_texte_en) as description,
	            		ar_type,
	    				prix_article_client(ar_code,'',1) as ar_prix
	    			from article
	            	where ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
	            	limit 10 OFFSET 0
2005-06-30 06:27:02 [27964] TRACE:  instruction : SELECT   $1  is null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 21 at if
2005-06-30 06:27:02 [27964] TRACE:  instruction : SELECT  cl_code,cl_groupe_prix,cl_groupe_rem from client where cl_code= $1  and  $2  is not null and  $3  <>''
CONTEXTE :  PL/pgSQL function "prix_article_client" line 25 at select into variables
2005-06-30 06:27:02 [27964] TRACE:  instruction : SELECT  ga_code from article where ar_code= $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 30 at select into variables
2005-06-30 06:27:02 [27964] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 31 at if
2005-06-30 06:27:02 [27964] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 37 at if
2005-06-30 06:27:02 [27964] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 45 at if
2005-06-30 06:27:02 [27964] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 53 at if
2005-06-30 06:27:02 [27964] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 62 at if
2005-06-30 06:27:02 [27964] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 71 at if
2005-06-30 06:27:02 [27964] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 80 at if
2005-06-30 06:27:02 [27964] TRACE:  instruction : SELECT prix_article_public( $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:27:02 [27964] TRACE:  instruction : SELECT  _recherche_prix('Tous les clients',null, $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:27:02 [27964] TRACE:  instruction : SELECT  coalesce( $1 ,0)=0
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 11 at if
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:27:02 [27964] TRACE:  instruction : SELECT  np_pu FROM nav_prix WHERE np_type_vente= $1  AND coalesce(np_code_vente,'') = coalesce( $2 ,'') AND np_ar_code= $3  AND ( (np_date_deb <= current_date and current_date <= np_date_fin) OR (np_date_deb is null and current_date <= np_date_fin) OR (np_date_deb <= current_date and np_date_fin is null) OR (np_date_deb is null and np_date_fin is null) ) AND  $4  >= np_qte_mini order by np_qte_mini desc,np_date_deb desc
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 15 at select into variables
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:27:02 [27964] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 27 at return
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:27:02 [27964] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 90 at if
2005-06-30 06:27:02 [27964] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 91 at return
2005-06-30 06:28:02 [27967] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:28:02 [27967] TRACE:  Connexion autorisée : utilisateur=sodipro base de données=sodipro
2005-06-30 06:28:02 [27967] TRACE:  instruction : select count(*) from article where  ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
2005-06-30 06:28:02 [27967] TRACE:  instruction : select oid from pg_ts_cfg where ts_name = $1
2005-06-30 06:28:02 [27967] TRACE:  instruction : select prs_name from pg_ts_cfg where oid = $1
2005-06-30 06:28:02 [27967] TRACE:  instruction : select lt.tokid, pg_ts_cfgmap.dict_name from pg_ts_cfgmap, pg_ts_cfg, token_type( $1 ) as lt where lt.alias = pg_ts_cfgmap.tok_alias and pg_ts_cfgmap.ts_name = pg_ts_cfg.ts_name and pg_ts_cfg.oid= $2 order by lt.tokid desc;
2005-06-30 06:28:02 [27967] TRACE:  instruction : select oid from pg_ts_parser where prs_name = $1
2005-06-30 06:28:02 [27967] TRACE:  instruction : select prs_start, prs_nexttoken, prs_end, prs_lextype, prs_headline from pg_ts_parser where oid = $1
2005-06-30 06:28:02 [27967] TRACE:  instruction : select oid from pg_ts_dict where dict_name = $1
2005-06-30 06:28:02 [27967] TRACE:  instruction : select dict_init, dict_initoption, dict_lexize from pg_ts_dict where oid = $1
2005-06-30 06:28:02 [27967] TRACE:  instruction : select ar_code,ar_code_aff,
	    				coalesce(ar_lib_sodipro_fr,ar_lib_fr,ar_lib_en) as libelle,
	    	        	COALESCE(ar_texte_fr,ar_texte_en) as description,
	            		ar_type,
	    				prix_article_client(ar_code,'',1) as ar_prix
	    			from article
	            	where ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
	            	limit 10 OFFSET 0
2005-06-30 06:28:02 [27967] TRACE:  instruction : SELECT   $1  is null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 21 at if
2005-06-30 06:28:02 [27967] TRACE:  instruction : SELECT  cl_code,cl_groupe_prix,cl_groupe_rem from client where cl_code= $1  and  $2  is not null and  $3  <>''
CONTEXTE :  PL/pgSQL function "prix_article_client" line 25 at select into variables
2005-06-30 06:28:02 [27967] TRACE:  instruction : SELECT  ga_code from article where ar_code= $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 30 at select into variables
2005-06-30 06:28:02 [27967] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 31 at if
2005-06-30 06:28:02 [27967] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 37 at if
2005-06-30 06:28:02 [27967] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 45 at if
2005-06-30 06:28:02 [27967] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 53 at if
2005-06-30 06:28:02 [27967] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 62 at if
2005-06-30 06:28:02 [27967] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 71 at if
2005-06-30 06:28:02 [27967] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 80 at if
2005-06-30 06:28:02 [27967] TRACE:  instruction : SELECT prix_article_public( $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:28:02 [27967] TRACE:  instruction : SELECT  _recherche_prix('Tous les clients',null, $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:28:02 [27967] TRACE:  instruction : SELECT  coalesce( $1 ,0)=0
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 11 at if
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:28:02 [27967] TRACE:  instruction : SELECT  np_pu FROM nav_prix WHERE np_type_vente= $1  AND coalesce(np_code_vente,'') = coalesce( $2 ,'') AND np_ar_code= $3  AND ( (np_date_deb <= current_date and current_date <= np_date_fin) OR (np_date_deb is null and current_date <= np_date_fin) OR (np_date_deb <= current_date and np_date_fin is null) OR (np_date_deb is null and np_date_fin is null) ) AND  $4  >= np_qte_mini order by np_qte_mini desc,np_date_deb desc
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 15 at select into variables
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:28:02 [27967] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 27 at return
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:28:02 [27967] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 90 at if
2005-06-30 06:28:02 [27967] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 91 at return
2005-06-30 06:29:03 [27971] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:29:03 [27971] TRACE:  Connexion autorisée : utilisateur=sodipro base de données=sodipro
2005-06-30 06:29:03 [27971] TRACE:  instruction : select count(*) from article where  ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
2005-06-30 06:29:03 [27971] TRACE:  instruction : select oid from pg_ts_cfg where ts_name = $1
2005-06-30 06:29:03 [27971] TRACE:  instruction : select prs_name from pg_ts_cfg where oid = $1
2005-06-30 06:29:03 [27971] TRACE:  instruction : select lt.tokid, pg_ts_cfgmap.dict_name from pg_ts_cfgmap, pg_ts_cfg, token_type( $1 ) as lt where lt.alias = pg_ts_cfgmap.tok_alias and pg_ts_cfgmap.ts_name = pg_ts_cfg.ts_name and pg_ts_cfg.oid= $2 order by lt.tokid desc;
2005-06-30 06:29:03 [27971] TRACE:  instruction : select oid from pg_ts_parser where prs_name = $1
2005-06-30 06:29:03 [27971] TRACE:  instruction : select prs_start, prs_nexttoken, prs_end, prs_lextype, prs_headline from pg_ts_parser where oid = $1
2005-06-30 06:29:03 [27971] TRACE:  instruction : select oid from pg_ts_dict where dict_name = $1
2005-06-30 06:29:03 [27971] TRACE:  instruction : select dict_init, dict_initoption, dict_lexize from pg_ts_dict where oid = $1
2005-06-30 06:29:03 [27971] TRACE:  instruction : select ar_code,ar_code_aff,
	    				coalesce(ar_lib_sodipro_fr,ar_lib_fr,ar_lib_en) as libelle,
	    	        	COALESCE(ar_texte_fr,ar_texte_en) as description,
	            		ar_type,
	    				prix_article_client(ar_code,'',1) as ar_prix
	    			from article
	            	where ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
	            	limit 10 OFFSET 0
2005-06-30 06:29:03 [27971] TRACE:  instruction : SELECT   $1  is null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 21 at if
2005-06-30 06:29:03 [27971] TRACE:  instruction : SELECT  cl_code,cl_groupe_prix,cl_groupe_rem from client where cl_code= $1  and  $2  is not null and  $3  <>''
CONTEXTE :  PL/pgSQL function "prix_article_client" line 25 at select into variables
2005-06-30 06:29:03 [27971] TRACE:  instruction : SELECT  ga_code from article where ar_code= $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 30 at select into variables
2005-06-30 06:29:03 [27971] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 31 at if
2005-06-30 06:29:03 [27971] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 37 at if
2005-06-30 06:29:03 [27971] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 45 at if
2005-06-30 06:29:03 [27971] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 53 at if
2005-06-30 06:29:03 [27971] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 62 at if
2005-06-30 06:29:03 [27971] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 71 at if
2005-06-30 06:29:03 [27971] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 80 at if
2005-06-30 06:29:03 [27971] TRACE:  instruction : SELECT prix_article_public( $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:29:03 [27971] TRACE:  instruction : SELECT  _recherche_prix('Tous les clients',null, $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:29:03 [27971] TRACE:  instruction : SELECT  coalesce( $1 ,0)=0
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 11 at if
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:29:03 [27971] TRACE:  instruction : SELECT  np_pu FROM nav_prix WHERE np_type_vente= $1  AND coalesce(np_code_vente,'') = coalesce( $2 ,'') AND np_ar_code= $3  AND ( (np_date_deb <= current_date and current_date <= np_date_fin) OR (np_date_deb is null and current_date <= np_date_fin) OR (np_date_deb <= current_date and np_date_fin is null) OR (np_date_deb is null and np_date_fin is null) ) AND  $4  >= np_qte_mini order by np_qte_mini desc,np_date_deb desc
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 15 at select into variables
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:29:03 [27971] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 27 at return
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:29:03 [27971] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 90 at if
2005-06-30 06:29:03 [27971] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 91 at return
2005-06-30 06:29:44 [27974] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:29:44 [27974] TRACE:  Connexion autorisée : utilisateur=postgres base de données=template1
2005-06-30 06:29:44 [27975] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:29:44 [27975] TRACE:  Connexion autorisée : utilisateur=postgres base de données=phppgadmin
2005-06-30 06:29:44 [27976] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:29:44 [27976] TRACE:  Connexion autorisée : utilisateur=postgres base de données=sodipro
2005-06-30 06:29:44 [27977] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:29:44 [27977] TRACE:  Connexion autorisée : utilisateur=postgres base de données=bug_tracker
2005-06-30 06:30:03 [27978] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:30:03 [27978] TRACE:  Connexion autorisée : utilisateur=sodipro base de données=sodipro
2005-06-30 06:30:03 [27978] TRACE:  instruction : select count(*) from article where  ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
2005-06-30 06:30:03 [27978] TRACE:  instruction : select oid from pg_ts_cfg where ts_name = $1
2005-06-30 06:30:03 [27978] TRACE:  instruction : select prs_name from pg_ts_cfg where oid = $1
2005-06-30 06:30:03 [27978] TRACE:  instruction : select lt.tokid, pg_ts_cfgmap.dict_name from pg_ts_cfgmap, pg_ts_cfg, token_type( $1 ) as lt where lt.alias = pg_ts_cfgmap.tok_alias and pg_ts_cfgmap.ts_name = pg_ts_cfg.ts_name and pg_ts_cfg.oid= $2 order by lt.tokid desc;
2005-06-30 06:30:03 [27978] TRACE:  instruction : select oid from pg_ts_parser where prs_name = $1
2005-06-30 06:30:03 [27978] TRACE:  instruction : select prs_start, prs_nexttoken, prs_end, prs_lextype, prs_headline from pg_ts_parser where oid = $1
2005-06-30 06:30:03 [27978] TRACE:  instruction : select oid from pg_ts_dict where dict_name = $1
2005-06-30 06:30:03 [27978] TRACE:  instruction : select dict_init, dict_initoption, dict_lexize from pg_ts_dict where oid = $1
2005-06-30 06:30:04 [27978] TRACE:  instruction : select ar_code,ar_code_aff,
	    				coalesce(ar_lib_sodipro_fr,ar_lib_fr,ar_lib_en) as libelle,
	    	        	COALESCE(ar_texte_fr,ar_texte_en) as description,
	            		ar_type,
	    				prix_article_client(ar_code,'',1) as ar_prix
	    			from article
	            	where ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
	            	limit 10 OFFSET 0
2005-06-30 06:30:04 [27978] TRACE:  instruction : SELECT   $1  is null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 21 at if
2005-06-30 06:30:04 [27978] TRACE:  instruction : SELECT  cl_code,cl_groupe_prix,cl_groupe_rem from client where cl_code= $1  and  $2  is not null and  $3  <>''
CONTEXTE :  PL/pgSQL function "prix_article_client" line 25 at select into variables
2005-06-30 06:30:04 [27978] TRACE:  instruction : SELECT  ga_code from article where ar_code= $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 30 at select into variables
2005-06-30 06:30:04 [27978] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 31 at if
2005-06-30 06:30:04 [27978] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 37 at if
2005-06-30 06:30:04 [27978] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 45 at if
2005-06-30 06:30:04 [27978] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 53 at if
2005-06-30 06:30:04 [27978] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 62 at if
2005-06-30 06:30:04 [27978] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 71 at if
2005-06-30 06:30:04 [27978] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 80 at if
2005-06-30 06:30:04 [27978] TRACE:  instruction : SELECT prix_article_public( $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:30:04 [27978] TRACE:  instruction : SELECT  _recherche_prix('Tous les clients',null, $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:30:04 [27978] TRACE:  instruction : SELECT  coalesce( $1 ,0)=0
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 11 at if
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:30:04 [27978] TRACE:  instruction : SELECT  np_pu FROM nav_prix WHERE np_type_vente= $1  AND coalesce(np_code_vente,'') = coalesce( $2 ,'') AND np_ar_code= $3  AND ( (np_date_deb <= current_date and current_date <= np_date_fin) OR (np_date_deb is null and current_date <= np_date_fin) OR (np_date_deb <= current_date and np_date_fin is null) OR (np_date_deb is null and np_date_fin is null) ) AND  $4  >= np_qte_mini order by np_qte_mini desc,np_date_deb desc
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 15 at select into variables
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:30:04 [27978] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 27 at return
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:30:04 [27978] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 90 at if
2005-06-30 06:30:04 [27978] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 91 at return
2005-06-30 06:31:04 [27981] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:31:04 [27981] TRACE:  Connexion autorisée : utilisateur=sodipro base de données=sodipro
2005-06-30 06:31:04 [27981] TRACE:  instruction : select count(*) from article where  ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
2005-06-30 06:31:04 [27981] TRACE:  instruction : select oid from pg_ts_cfg where ts_name = $1
2005-06-30 06:31:04 [27981] TRACE:  instruction : select prs_name from pg_ts_cfg where oid = $1
2005-06-30 06:31:04 [27981] TRACE:  instruction : select lt.tokid, pg_ts_cfgmap.dict_name from pg_ts_cfgmap, pg_ts_cfg, token_type( $1 ) as lt where lt.alias = pg_ts_cfgmap.tok_alias and pg_ts_cfgmap.ts_name = pg_ts_cfg.ts_name and pg_ts_cfg.oid= $2 order by lt.tokid desc;
2005-06-30 06:31:04 [27981] TRACE:  instruction : select oid from pg_ts_parser where prs_name = $1
2005-06-30 06:31:04 [27981] TRACE:  instruction : select prs_start, prs_nexttoken, prs_end, prs_lextype, prs_headline from pg_ts_parser where oid = $1
2005-06-30 06:31:04 [27981] TRACE:  instruction : select oid from pg_ts_dict where dict_name = $1
2005-06-30 06:31:04 [27981] TRACE:  instruction : select dict_init, dict_initoption, dict_lexize from pg_ts_dict where oid = $1
2005-06-30 06:31:05 [27981] TRACE:  instruction : select ar_code,ar_code_aff,
	    				coalesce(ar_lib_sodipro_fr,ar_lib_fr,ar_lib_en) as libelle,
	    	        	COALESCE(ar_texte_fr,ar_texte_en) as description,
	            		ar_type,
	    				prix_article_client(ar_code,'',1) as ar_prix
	    			from article
	            	where ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
	            	limit 10 OFFSET 0
2005-06-30 06:31:05 [27981] TRACE:  instruction : SELECT   $1  is null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 21 at if
2005-06-30 06:31:05 [27981] TRACE:  instruction : SELECT  cl_code,cl_groupe_prix,cl_groupe_rem from client where cl_code= $1  and  $2  is not null and  $3  <>''
CONTEXTE :  PL/pgSQL function "prix_article_client" line 25 at select into variables
2005-06-30 06:31:05 [27981] TRACE:  instruction : SELECT  ga_code from article where ar_code= $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 30 at select into variables
2005-06-30 06:31:05 [27981] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 31 at if
2005-06-30 06:31:05 [27981] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 37 at if
2005-06-30 06:31:05 [27981] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 45 at if
2005-06-30 06:31:05 [27981] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 53 at if
2005-06-30 06:31:05 [27981] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 62 at if
2005-06-30 06:31:05 [27981] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 71 at if
2005-06-30 06:31:05 [27981] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 80 at if
2005-06-30 06:31:05 [27981] TRACE:  instruction : SELECT prix_article_public( $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:31:05 [27981] TRACE:  instruction : SELECT  _recherche_prix('Tous les clients',null, $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:31:05 [27981] TRACE:  instruction : SELECT  coalesce( $1 ,0)=0
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 11 at if
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:31:05 [27981] TRACE:  instruction : SELECT  np_pu FROM nav_prix WHERE np_type_vente= $1  AND coalesce(np_code_vente,'') = coalesce( $2 ,'') AND np_ar_code= $3  AND ( (np_date_deb <= current_date and current_date <= np_date_fin) OR (np_date_deb is null and current_date <= np_date_fin) OR (np_date_deb <= current_date and np_date_fin is null) OR (np_date_deb is null and np_date_fin is null) ) AND  $4  >= np_qte_mini order by np_qte_mini desc,np_date_deb desc
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 15 at select into variables
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:31:05 [27981] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 27 at return
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:31:05 [27981] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 90 at if
2005-06-30 06:31:05 [27981] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 91 at return
2005-06-30 06:32:05 [27984] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:32:05 [27984] TRACE:  Connexion autorisée : utilisateur=sodipro base de données=sodipro
2005-06-30 06:32:05 [27984] TRACE:  instruction : select count(*) from article where  ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
2005-06-30 06:32:05 [27984] TRACE:  instruction : select oid from pg_ts_cfg where ts_name = $1
2005-06-30 06:32:05 [27984] TRACE:  instruction : select prs_name from pg_ts_cfg where oid = $1
2005-06-30 06:32:05 [27984] TRACE:  instruction : select lt.tokid, pg_ts_cfgmap.dict_name from pg_ts_cfgmap, pg_ts_cfg, token_type( $1 ) as lt where lt.alias = pg_ts_cfgmap.tok_alias and pg_ts_cfgmap.ts_name = pg_ts_cfg.ts_name and pg_ts_cfg.oid= $2 order by lt.tokid desc;
2005-06-30 06:32:05 [27984] TRACE:  instruction : select oid from pg_ts_parser where prs_name = $1
2005-06-30 06:32:05 [27984] TRACE:  instruction : select prs_start, prs_nexttoken, prs_end, prs_lextype, prs_headline from pg_ts_parser where oid = $1
2005-06-30 06:32:05 [27984] TRACE:  instruction : select oid from pg_ts_dict where dict_name = $1
2005-06-30 06:32:05 [27984] TRACE:  instruction : select dict_init, dict_initoption, dict_lexize from pg_ts_dict where oid = $1
2005-06-30 06:32:05 [27984] TRACE:  instruction : select ar_code,ar_code_aff,
	    				coalesce(ar_lib_sodipro_fr,ar_lib_fr,ar_lib_en) as libelle,
	    	        	COALESCE(ar_texte_fr,ar_texte_en) as description,
	            		ar_type,
	    				prix_article_client(ar_code,'',1) as ar_prix
	    			from article
	            	where ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
	            	limit 10 OFFSET 0
2005-06-30 06:32:05 [27984] TRACE:  instruction : SELECT   $1  is null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 21 at if
2005-06-30 06:32:05 [27984] TRACE:  instruction : SELECT  cl_code,cl_groupe_prix,cl_groupe_rem from client where cl_code= $1  and  $2  is not null and  $3  <>''
CONTEXTE :  PL/pgSQL function "prix_article_client" line 25 at select into variables
2005-06-30 06:32:05 [27984] TRACE:  instruction : SELECT  ga_code from article where ar_code= $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 30 at select into variables
2005-06-30 06:32:05 [27984] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 31 at if
2005-06-30 06:32:05 [27984] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 37 at if
2005-06-30 06:32:05 [27984] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 45 at if
2005-06-30 06:32:05 [27984] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 53 at if
2005-06-30 06:32:05 [27984] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 62 at if
2005-06-30 06:32:05 [27984] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 71 at if
2005-06-30 06:32:05 [27984] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 80 at if
2005-06-30 06:32:05 [27984] TRACE:  instruction : SELECT prix_article_public( $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:32:05 [27984] TRACE:  instruction : SELECT  _recherche_prix('Tous les clients',null, $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:32:05 [27984] TRACE:  instruction : SELECT  coalesce( $1 ,0)=0
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 11 at if
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:32:05 [27984] TRACE:  instruction : SELECT  np_pu FROM nav_prix WHERE np_type_vente= $1  AND coalesce(np_code_vente,'') = coalesce( $2 ,'') AND np_ar_code= $3  AND ( (np_date_deb <= current_date and current_date <= np_date_fin) OR (np_date_deb is null and current_date <= np_date_fin) OR (np_date_deb <= current_date and np_date_fin is null) OR (np_date_deb is null and np_date_fin is null) ) AND  $4  >= np_qte_mini order by np_qte_mini desc,np_date_deb desc
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 15 at select into variables
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:32:05 [27984] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 27 at return
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:32:05 [27984] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 90 at if
2005-06-30 06:32:05 [27984] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 91 at return
2005-06-30 06:33:06 [27987] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:33:06 [27987] TRACE:  Connexion autorisée : utilisateur=sodipro base de données=sodipro
2005-06-30 06:33:06 [27987] TRACE:  instruction : select count(*) from article where  ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
2005-06-30 06:33:06 [27987] TRACE:  instruction : select oid from pg_ts_cfg where ts_name = $1
2005-06-30 06:33:06 [27987] TRACE:  instruction : select prs_name from pg_ts_cfg where oid = $1
2005-06-30 06:33:06 [27987] TRACE:  instruction : select lt.tokid, pg_ts_cfgmap.dict_name from pg_ts_cfgmap, pg_ts_cfg, token_type( $1 ) as lt where lt.alias = pg_ts_cfgmap.tok_alias and pg_ts_cfgmap.ts_name = pg_ts_cfg.ts_name and pg_ts_cfg.oid= $2 order by lt.tokid desc;
2005-06-30 06:33:06 [27987] TRACE:  instruction : select oid from pg_ts_parser where prs_name = $1
2005-06-30 06:33:06 [27987] TRACE:  instruction : select prs_start, prs_nexttoken, prs_end, prs_lextype, prs_headline from pg_ts_parser where oid = $1
2005-06-30 06:33:06 [27987] TRACE:  instruction : select oid from pg_ts_dict where dict_name = $1
2005-06-30 06:33:06 [27987] TRACE:  instruction : select dict_init, dict_initoption, dict_lexize from pg_ts_dict where oid = $1
2005-06-30 06:33:06 [27987] TRACE:  instruction : select ar_code,ar_code_aff,
	    				coalesce(ar_lib_sodipro_fr,ar_lib_fr,ar_lib_en) as libelle,
	    	        	COALESCE(ar_texte_fr,ar_texte_en) as description,
	            		ar_type,
	    				prix_article_client(ar_code,'',1) as ar_prix
	    			from article
	            	where ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
	            	limit 10 OFFSET 0
2005-06-30 06:33:06 [27987] TRACE:  instruction : SELECT   $1  is null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 21 at if
2005-06-30 06:33:06 [27987] TRACE:  instruction : SELECT  cl_code,cl_groupe_prix,cl_groupe_rem from client where cl_code= $1  and  $2  is not null and  $3  <>''
CONTEXTE :  PL/pgSQL function "prix_article_client" line 25 at select into variables
2005-06-30 06:33:06 [27987] TRACE:  instruction : SELECT  ga_code from article where ar_code= $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 30 at select into variables
2005-06-30 06:33:06 [27987] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 31 at if
2005-06-30 06:33:06 [27987] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 37 at if
2005-06-30 06:33:06 [27987] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 45 at if
2005-06-30 06:33:06 [27987] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 53 at if
2005-06-30 06:33:06 [27987] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 62 at if
2005-06-30 06:33:06 [27987] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 71 at if
2005-06-30 06:33:06 [27987] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 80 at if
2005-06-30 06:33:06 [27987] TRACE:  instruction : SELECT prix_article_public( $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:33:06 [27987] TRACE:  instruction : SELECT  _recherche_prix('Tous les clients',null, $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:33:06 [27987] TRACE:  instruction : SELECT  coalesce( $1 ,0)=0
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 11 at if
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:33:06 [27987] TRACE:  instruction : SELECT  np_pu FROM nav_prix WHERE np_type_vente= $1  AND coalesce(np_code_vente,'') = coalesce( $2 ,'') AND np_ar_code= $3  AND ( (np_date_deb <= current_date and current_date <= np_date_fin) OR (np_date_deb is null and current_date <= np_date_fin) OR (np_date_deb <= current_date and np_date_fin is null) OR (np_date_deb is null and np_date_fin is null) ) AND  $4  >= np_qte_mini order by np_qte_mini desc,np_date_deb desc
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 15 at select into variables
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:33:06 [27987] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 27 at return
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:33:06 [27987] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 90 at if
2005-06-30 06:33:06 [27987] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 91 at return
2005-06-30 06:34:06 [27991] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:34:06 [27991] TRACE:  Connexion autorisée : utilisateur=sodipro base de données=sodipro
2005-06-30 06:34:06 [27991] TRACE:  instruction : select count(*) from article where  ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
2005-06-30 06:34:06 [27991] TRACE:  instruction : select oid from pg_ts_cfg where ts_name = $1
2005-06-30 06:34:06 [27991] TRACE:  instruction : select prs_name from pg_ts_cfg where oid = $1
2005-06-30 06:34:06 [27991] TRACE:  instruction : select lt.tokid, pg_ts_cfgmap.dict_name from pg_ts_cfgmap, pg_ts_cfg, token_type( $1 ) as lt where lt.alias = pg_ts_cfgmap.tok_alias and pg_ts_cfgmap.ts_name = pg_ts_cfg.ts_name and pg_ts_cfg.oid= $2 order by lt.tokid desc;
2005-06-30 06:34:06 [27991] TRACE:  instruction : select oid from pg_ts_parser where prs_name = $1
2005-06-30 06:34:06 [27991] TRACE:  instruction : select prs_start, prs_nexttoken, prs_end, prs_lextype, prs_headline from pg_ts_parser where oid = $1
2005-06-30 06:34:06 [27991] TRACE:  instruction : select oid from pg_ts_dict where dict_name = $1
2005-06-30 06:34:06 [27991] TRACE:  instruction : select dict_init, dict_initoption, dict_lexize from pg_ts_dict where oid = $1
2005-06-30 06:34:07 [27991] TRACE:  instruction : select ar_code,ar_code_aff,
	    				coalesce(ar_lib_sodipro_fr,ar_lib_fr,ar_lib_en) as libelle,
	    	        	COALESCE(ar_texte_fr,ar_texte_en) as description,
	            		ar_type,
	    				prix_article_client(ar_code,'',1) as ar_prix
	    			from article
	            	where ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
	            	limit 10 OFFSET 0
2005-06-30 06:34:07 [27991] TRACE:  instruction : SELECT   $1  is null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 21 at if
2005-06-30 06:34:07 [27991] TRACE:  instruction : SELECT  cl_code,cl_groupe_prix,cl_groupe_rem from client where cl_code= $1  and  $2  is not null and  $3  <>''
CONTEXTE :  PL/pgSQL function "prix_article_client" line 25 at select into variables
2005-06-30 06:34:07 [27991] TRACE:  instruction : SELECT  ga_code from article where ar_code= $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 30 at select into variables
2005-06-30 06:34:07 [27991] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 31 at if
2005-06-30 06:34:07 [27991] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 37 at if
2005-06-30 06:34:07 [27991] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 45 at if
2005-06-30 06:34:07 [27991] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 53 at if
2005-06-30 06:34:07 [27991] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 62 at if
2005-06-30 06:34:07 [27991] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 71 at if
2005-06-30 06:34:07 [27991] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 80 at if
2005-06-30 06:34:07 [27991] TRACE:  instruction : SELECT prix_article_public( $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:34:07 [27991] TRACE:  instruction : SELECT  _recherche_prix('Tous les clients',null, $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:34:07 [27991] TRACE:  instruction : SELECT  coalesce( $1 ,0)=0
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 11 at if
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:34:07 [27991] TRACE:  instruction : SELECT  np_pu FROM nav_prix WHERE np_type_vente= $1  AND coalesce(np_code_vente,'') = coalesce( $2 ,'') AND np_ar_code= $3  AND ( (np_date_deb <= current_date and current_date <= np_date_fin) OR (np_date_deb is null and current_date <= np_date_fin) OR (np_date_deb <= current_date and np_date_fin is null) OR (np_date_deb is null and np_date_fin is null) ) AND  $4  >= np_qte_mini order by np_qte_mini desc,np_date_deb desc
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 15 at select into variables
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:34:07 [27991] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 27 at return
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:34:07 [27991] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 90 at if
2005-06-30 06:34:07 [27991] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 91 at return
2005-06-30 06:34:44 [27992] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:34:44 [27992] TRACE:  Connexion autorisée : utilisateur=postgres base de données=template1
2005-06-30 06:34:44 [27993] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:34:44 [27993] TRACE:  Connexion autorisée : utilisateur=postgres base de données=phppgadmin
2005-06-30 06:34:44 [27994] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:34:44 [27994] TRACE:  Connexion autorisée : utilisateur=postgres base de données=sodipro
2005-06-30 06:34:44 [27995] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:34:44 [27995] TRACE:  Connexion autorisée : utilisateur=postgres base de données=bug_tracker
2005-06-30 06:35:07 [27998] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:35:07 [27998] TRACE:  Connexion autorisée : utilisateur=sodipro base de données=sodipro
2005-06-30 06:35:07 [27998] TRACE:  instruction : select count(*) from article where  ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
2005-06-30 06:35:07 [27998] TRACE:  instruction : select oid from pg_ts_cfg where ts_name = $1
2005-06-30 06:35:07 [27998] TRACE:  instruction : select prs_name from pg_ts_cfg where oid = $1
2005-06-30 06:35:07 [27998] TRACE:  instruction : select lt.tokid, pg_ts_cfgmap.dict_name from pg_ts_cfgmap, pg_ts_cfg, token_type( $1 ) as lt where lt.alias = pg_ts_cfgmap.tok_alias and pg_ts_cfgmap.ts_name = pg_ts_cfg.ts_name and pg_ts_cfg.oid= $2 order by lt.tokid desc;
2005-06-30 06:35:07 [27998] TRACE:  instruction : select oid from pg_ts_parser where prs_name = $1
2005-06-30 06:35:07 [27998] TRACE:  instruction : select prs_start, prs_nexttoken, prs_end, prs_lextype, prs_headline from pg_ts_parser where oid = $1
2005-06-30 06:35:07 [27998] TRACE:  instruction : select oid from pg_ts_dict where dict_name = $1
2005-06-30 06:35:07 [27998] TRACE:  instruction : select dict_init, dict_initoption, dict_lexize from pg_ts_dict where oid = $1
2005-06-30 06:35:08 [27998] TRACE:  instruction : select ar_code,ar_code_aff,
	    				coalesce(ar_lib_sodipro_fr,ar_lib_fr,ar_lib_en) as libelle,
	    	        	COALESCE(ar_texte_fr,ar_texte_en) as description,
	            		ar_type,
	    				prix_article_client(ar_code,'',1) as ar_prix
	    			from article
	            	where ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
	            	limit 10 OFFSET 0
2005-06-30 06:35:08 [27998] TRACE:  instruction : SELECT   $1  is null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 21 at if
2005-06-30 06:35:08 [27998] TRACE:  instruction : SELECT  cl_code,cl_groupe_prix,cl_groupe_rem from client where cl_code= $1  and  $2  is not null and  $3  <>''
CONTEXTE :  PL/pgSQL function "prix_article_client" line 25 at select into variables
2005-06-30 06:35:08 [27998] TRACE:  instruction : SELECT  ga_code from article where ar_code= $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 30 at select into variables
2005-06-30 06:35:08 [27998] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 31 at if
2005-06-30 06:35:08 [27998] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 37 at if
2005-06-30 06:35:08 [27998] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 45 at if
2005-06-30 06:35:08 [27998] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 53 at if
2005-06-30 06:35:08 [27998] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 62 at if
2005-06-30 06:35:08 [27998] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 71 at if
2005-06-30 06:35:08 [27998] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 80 at if
2005-06-30 06:35:08 [27998] TRACE:  instruction : SELECT prix_article_public( $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:35:08 [27998] TRACE:  instruction : SELECT  _recherche_prix('Tous les clients',null, $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:35:08 [27998] TRACE:  instruction : SELECT  coalesce( $1 ,0)=0
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 11 at if
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:35:08 [27998] TRACE:  instruction : SELECT  np_pu FROM nav_prix WHERE np_type_vente= $1  AND coalesce(np_code_vente,'') = coalesce( $2 ,'') AND np_ar_code= $3  AND ( (np_date_deb <= current_date and current_date <= np_date_fin) OR (np_date_deb is null and current_date <= np_date_fin) OR (np_date_deb <= current_date and np_date_fin is null) OR (np_date_deb is null and np_date_fin is null) ) AND  $4  >= np_qte_mini order by np_qte_mini desc,np_date_deb desc
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 15 at select into variables
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:35:08 [27998] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 27 at return
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:35:08 [27998] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 90 at if
2005-06-30 06:35:08 [27998] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 91 at return
2005-06-30 06:36:08 [28001] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:36:08 [28001] TRACE:  Connexion autorisée : utilisateur=sodipro base de données=sodipro
2005-06-30 06:36:08 [28001] TRACE:  instruction : select count(*) from article where  ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
2005-06-30 06:36:08 [28001] TRACE:  instruction : select oid from pg_ts_cfg where ts_name = $1
2005-06-30 06:36:08 [28001] TRACE:  instruction : select prs_name from pg_ts_cfg where oid = $1
2005-06-30 06:36:08 [28001] TRACE:  instruction : select lt.tokid, pg_ts_cfgmap.dict_name from pg_ts_cfgmap, pg_ts_cfg, token_type( $1 ) as lt where lt.alias = pg_ts_cfgmap.tok_alias and pg_ts_cfgmap.ts_name = pg_ts_cfg.ts_name and pg_ts_cfg.oid= $2 order by lt.tokid desc;
2005-06-30 06:36:08 [28001] TRACE:  instruction : select oid from pg_ts_parser where prs_name = $1
2005-06-30 06:36:08 [28001] TRACE:  instruction : select prs_start, prs_nexttoken, prs_end, prs_lextype, prs_headline from pg_ts_parser where oid = $1
2005-06-30 06:36:08 [28001] TRACE:  instruction : select oid from pg_ts_dict where dict_name = $1
2005-06-30 06:36:08 [28001] TRACE:  instruction : select dict_init, dict_initoption, dict_lexize from pg_ts_dict where oid = $1
2005-06-30 06:36:08 [28001] TRACE:  instruction : select ar_code,ar_code_aff,
	    				coalesce(ar_lib_sodipro_fr,ar_lib_fr,ar_lib_en) as libelle,
	    	        	COALESCE(ar_texte_fr,ar_texte_en) as description,
	            		ar_type,
	    				prix_article_client(ar_code,'',1) as ar_prix
	    			from article
	            	where ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
	            	limit 10 OFFSET 0
2005-06-30 06:36:08 [28001] TRACE:  instruction : SELECT   $1  is null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 21 at if
2005-06-30 06:36:08 [28001] TRACE:  instruction : SELECT  cl_code,cl_groupe_prix,cl_groupe_rem from client where cl_code= $1  and  $2  is not null and  $3  <>''
CONTEXTE :  PL/pgSQL function "prix_article_client" line 25 at select into variables
2005-06-30 06:36:08 [28001] TRACE:  instruction : SELECT  ga_code from article where ar_code= $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 30 at select into variables
2005-06-30 06:36:08 [28001] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 31 at if
2005-06-30 06:36:08 [28001] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 37 at if
2005-06-30 06:36:08 [28001] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 45 at if
2005-06-30 06:36:08 [28001] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 53 at if
2005-06-30 06:36:08 [28001] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 62 at if
2005-06-30 06:36:08 [28001] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 71 at if
2005-06-30 06:36:08 [28001] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 80 at if
2005-06-30 06:36:08 [28001] TRACE:  instruction : SELECT prix_article_public( $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:36:08 [28001] TRACE:  instruction : SELECT  _recherche_prix('Tous les clients',null, $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:36:08 [28001] TRACE:  instruction : SELECT  coalesce( $1 ,0)=0
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 11 at if
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:36:08 [28001] TRACE:  instruction : SELECT  np_pu FROM nav_prix WHERE np_type_vente= $1  AND coalesce(np_code_vente,'') = coalesce( $2 ,'') AND np_ar_code= $3  AND ( (np_date_deb <= current_date and current_date <= np_date_fin) OR (np_date_deb is null and current_date <= np_date_fin) OR (np_date_deb <= current_date and np_date_fin is null) OR (np_date_deb is null and np_date_fin is null) ) AND  $4  >= np_qte_mini order by np_qte_mini desc,np_date_deb desc
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 15 at select into variables
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:36:08 [28001] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 27 at return
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:36:08 [28001] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 90 at if
2005-06-30 06:36:08 [28001] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 91 at return
2005-06-30 06:37:09 [28004] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:37:09 [28004] TRACE:  Connexion autorisée : utilisateur=sodipro base de données=sodipro
2005-06-30 06:37:09 [28004] TRACE:  instruction : select count(*) from article where  ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
2005-06-30 06:37:09 [28004] TRACE:  instruction : select oid from pg_ts_cfg where ts_name = $1
2005-06-30 06:37:09 [28004] TRACE:  instruction : select prs_name from pg_ts_cfg where oid = $1
2005-06-30 06:37:09 [28004] TRACE:  instruction : select lt.tokid, pg_ts_cfgmap.dict_name from pg_ts_cfgmap, pg_ts_cfg, token_type( $1 ) as lt where lt.alias = pg_ts_cfgmap.tok_alias and pg_ts_cfgmap.ts_name = pg_ts_cfg.ts_name and pg_ts_cfg.oid= $2 order by lt.tokid desc;
2005-06-30 06:37:09 [28004] TRACE:  instruction : select oid from pg_ts_parser where prs_name = $1
2005-06-30 06:37:09 [28004] TRACE:  instruction : select prs_start, prs_nexttoken, prs_end, prs_lextype, prs_headline from pg_ts_parser where oid = $1
2005-06-30 06:37:09 [28004] TRACE:  instruction : select oid from pg_ts_dict where dict_name = $1
2005-06-30 06:37:09 [28004] TRACE:  instruction : select dict_init, dict_initoption, dict_lexize from pg_ts_dict where oid = $1
2005-06-30 06:37:09 [28004] TRACE:  instruction : select ar_code,ar_code_aff,
	    				coalesce(ar_lib_sodipro_fr,ar_lib_fr,ar_lib_en) as libelle,
	    	        	COALESCE(ar_texte_fr,ar_texte_en) as description,
	            		ar_type,
	    				prix_article_client(ar_code,'',1) as ar_prix
	    			from article
	            	where ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
	            	limit 10 OFFSET 0
2005-06-30 06:37:09 [28004] TRACE:  instruction : SELECT   $1  is null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 21 at if
2005-06-30 06:37:09 [28004] TRACE:  instruction : SELECT  cl_code,cl_groupe_prix,cl_groupe_rem from client where cl_code= $1  and  $2  is not null and  $3  <>''
CONTEXTE :  PL/pgSQL function "prix_article_client" line 25 at select into variables
2005-06-30 06:37:09 [28004] TRACE:  instruction : SELECT  ga_code from article where ar_code= $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 30 at select into variables
2005-06-30 06:37:09 [28004] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 31 at if
2005-06-30 06:37:09 [28004] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 37 at if
2005-06-30 06:37:09 [28004] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 45 at if
2005-06-30 06:37:09 [28004] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 53 at if
2005-06-30 06:37:09 [28004] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 62 at if
2005-06-30 06:37:09 [28004] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 71 at if
2005-06-30 06:37:09 [28004] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 80 at if
2005-06-30 06:37:09 [28004] TRACE:  instruction : SELECT prix_article_public( $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:37:09 [28004] TRACE:  instruction : SELECT  _recherche_prix('Tous les clients',null, $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:37:09 [28004] TRACE:  instruction : SELECT  coalesce( $1 ,0)=0
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 11 at if
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:37:09 [28004] TRACE:  instruction : SELECT  np_pu FROM nav_prix WHERE np_type_vente= $1  AND coalesce(np_code_vente,'') = coalesce( $2 ,'') AND np_ar_code= $3  AND ( (np_date_deb <= current_date and current_date <= np_date_fin) OR (np_date_deb is null and current_date <= np_date_fin) OR (np_date_deb <= current_date and np_date_fin is null) OR (np_date_deb is null and np_date_fin is null) ) AND  $4  >= np_qte_mini order by np_qte_mini desc,np_date_deb desc
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 15 at select into variables
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:37:09 [28004] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 27 at return
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:37:09 [28004] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 90 at if
2005-06-30 06:37:09 [28004] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 91 at return
2005-06-30 06:38:09 [28007] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:38:09 [28007] TRACE:  Connexion autorisée : utilisateur=sodipro base de données=sodipro
2005-06-30 06:38:09 [28007] TRACE:  instruction : select count(*) from article where  ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
2005-06-30 06:38:09 [28007] TRACE:  instruction : select oid from pg_ts_cfg where ts_name = $1
2005-06-30 06:38:09 [28007] TRACE:  instruction : select prs_name from pg_ts_cfg where oid = $1
2005-06-30 06:38:09 [28007] TRACE:  instruction : select lt.tokid, pg_ts_cfgmap.dict_name from pg_ts_cfgmap, pg_ts_cfg, token_type( $1 ) as lt where lt.alias = pg_ts_cfgmap.tok_alias and pg_ts_cfgmap.ts_name = pg_ts_cfg.ts_name and pg_ts_cfg.oid= $2 order by lt.tokid desc;
2005-06-30 06:38:09 [28007] TRACE:  instruction : select oid from pg_ts_parser where prs_name = $1
2005-06-30 06:38:09 [28007] TRACE:  instruction : select prs_start, prs_nexttoken, prs_end, prs_lextype, prs_headline from pg_ts_parser where oid = $1
2005-06-30 06:38:09 [28007] TRACE:  instruction : select oid from pg_ts_dict where dict_name = $1
2005-06-30 06:38:09 [28007] TRACE:  instruction : select dict_init, dict_initoption, dict_lexize from pg_ts_dict where oid = $1
2005-06-30 06:38:10 [28007] TRACE:  instruction : select ar_code,ar_code_aff,
	    				coalesce(ar_lib_sodipro_fr,ar_lib_fr,ar_lib_en) as libelle,
	    	        	COALESCE(ar_texte_fr,ar_texte_en) as description,
	            		ar_type,
	    				prix_article_client(ar_code,'',1) as ar_prix
	    			from article
	            	where ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
	            	limit 10 OFFSET 0
2005-06-30 06:38:10 [28007] TRACE:  instruction : SELECT   $1  is null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 21 at if
2005-06-30 06:38:10 [28007] TRACE:  instruction : SELECT  cl_code,cl_groupe_prix,cl_groupe_rem from client where cl_code= $1  and  $2  is not null and  $3  <>''
CONTEXTE :  PL/pgSQL function "prix_article_client" line 25 at select into variables
2005-06-30 06:38:10 [28007] TRACE:  instruction : SELECT  ga_code from article where ar_code= $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 30 at select into variables
2005-06-30 06:38:10 [28007] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 31 at if
2005-06-30 06:38:10 [28007] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 37 at if
2005-06-30 06:38:10 [28007] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 45 at if
2005-06-30 06:38:10 [28007] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 53 at if
2005-06-30 06:38:10 [28007] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 62 at if
2005-06-30 06:38:10 [28007] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 71 at if
2005-06-30 06:38:10 [28007] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 80 at if
2005-06-30 06:38:10 [28007] TRACE:  instruction : SELECT prix_article_public( $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:38:10 [28007] TRACE:  instruction : SELECT  _recherche_prix('Tous les clients',null, $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:38:10 [28007] TRACE:  instruction : SELECT  coalesce( $1 ,0)=0
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 11 at if
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:38:10 [28007] TRACE:  instruction : SELECT  np_pu FROM nav_prix WHERE np_type_vente= $1  AND coalesce(np_code_vente,'') = coalesce( $2 ,'') AND np_ar_code= $3  AND ( (np_date_deb <= current_date and current_date <= np_date_fin) OR (np_date_deb is null and current_date <= np_date_fin) OR (np_date_deb <= current_date and np_date_fin is null) OR (np_date_deb is null and np_date_fin is null) ) AND  $4  >= np_qte_mini order by np_qte_mini desc,np_date_deb desc
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 15 at select into variables
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:38:10 [28007] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 27 at return
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:38:10 [28007] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 90 at if
2005-06-30 06:38:10 [28007] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 91 at return
2005-06-30 06:39:10 [28024] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:39:10 [28024] TRACE:  Connexion autorisée : utilisateur=sodipro base de données=sodipro
2005-06-30 06:39:10 [28024] TRACE:  instruction : select count(*) from article where  ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
2005-06-30 06:39:10 [28024] TRACE:  instruction : select oid from pg_ts_cfg where ts_name = $1
2005-06-30 06:39:10 [28024] TRACE:  instruction : select prs_name from pg_ts_cfg where oid = $1
2005-06-30 06:39:10 [28024] TRACE:  instruction : select lt.tokid, pg_ts_cfgmap.dict_name from pg_ts_cfgmap, pg_ts_cfg, token_type( $1 ) as lt where lt.alias = pg_ts_cfgmap.tok_alias and pg_ts_cfgmap.ts_name = pg_ts_cfg.ts_name and pg_ts_cfg.oid= $2 order by lt.tokid desc;
2005-06-30 06:39:10 [28024] TRACE:  instruction : select oid from pg_ts_parser where prs_name = $1
2005-06-30 06:39:10 [28024] TRACE:  instruction : select prs_start, prs_nexttoken, prs_end, prs_lextype, prs_headline from pg_ts_parser where oid = $1
2005-06-30 06:39:10 [28024] TRACE:  instruction : select oid from pg_ts_dict where dict_name = $1
2005-06-30 06:39:10 [28024] TRACE:  instruction : select dict_init, dict_initoption, dict_lexize from pg_ts_dict where oid = $1
2005-06-30 06:39:11 [28024] TRACE:  instruction : select ar_code,ar_code_aff,
	    				coalesce(ar_lib_sodipro_fr,ar_lib_fr,ar_lib_en) as libelle,
	    	        	COALESCE(ar_texte_fr,ar_texte_en) as description,
	            		ar_type,
	    				prix_article_client(ar_code,'',1) as ar_prix
	    			from article
	            	where ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
	            	limit 10 OFFSET 0
2005-06-30 06:39:11 [28024] TRACE:  instruction : SELECT   $1  is null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 21 at if
2005-06-30 06:39:11 [28024] TRACE:  instruction : SELECT  cl_code,cl_groupe_prix,cl_groupe_rem from client where cl_code= $1  and  $2  is not null and  $3  <>''
CONTEXTE :  PL/pgSQL function "prix_article_client" line 25 at select into variables
2005-06-30 06:39:11 [28024] TRACE:  instruction : SELECT  ga_code from article where ar_code= $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 30 at select into variables
2005-06-30 06:39:11 [28024] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 31 at if
2005-06-30 06:39:11 [28024] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 37 at if
2005-06-30 06:39:11 [28024] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 45 at if
2005-06-30 06:39:11 [28024] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 53 at if
2005-06-30 06:39:11 [28024] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 62 at if
2005-06-30 06:39:11 [28024] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 71 at if
2005-06-30 06:39:11 [28024] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 80 at if
2005-06-30 06:39:11 [28024] TRACE:  instruction : SELECT prix_article_public( $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:39:11 [28024] TRACE:  instruction : SELECT  _recherche_prix('Tous les clients',null, $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:39:11 [28024] TRACE:  instruction : SELECT  coalesce( $1 ,0)=0
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 11 at if
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:39:11 [28024] TRACE:  instruction : SELECT  np_pu FROM nav_prix WHERE np_type_vente= $1  AND coalesce(np_code_vente,'') = coalesce( $2 ,'') AND np_ar_code= $3  AND ( (np_date_deb <= current_date and current_date <= np_date_fin) OR (np_date_deb is null and current_date <= np_date_fin) OR (np_date_deb <= current_date and np_date_fin is null) OR (np_date_deb is null and np_date_fin is null) ) AND  $4  >= np_qte_mini order by np_qte_mini desc,np_date_deb desc
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 15 at select into variables
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:39:11 [28024] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 27 at return
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:39:11 [28024] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 90 at if
2005-06-30 06:39:11 [28024] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 91 at return
2005-06-30 06:39:44 [28025] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:39:44 [28025] TRACE:  Connexion autorisée : utilisateur=postgres base de données=template1
2005-06-30 06:39:44 [28026] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:39:44 [28026] TRACE:  Connexion autorisée : utilisateur=postgres base de données=phppgadmin
2005-06-30 06:39:44 [28027] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:39:44 [28027] TRACE:  Connexion autorisée : utilisateur=postgres base de données=sodipro
2005-06-30 06:39:44 [28028] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:39:44 [28028] TRACE:  Connexion autorisée : utilisateur=postgres base de données=bug_tracker
2005-06-30 06:40:11 [28029] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:40:11 [28029] TRACE:  Connexion autorisée : utilisateur=sodipro base de données=sodipro
2005-06-30 06:40:11 [28029] TRACE:  instruction : select count(*) from article where  ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
2005-06-30 06:40:11 [28029] TRACE:  instruction : select oid from pg_ts_cfg where ts_name = $1
2005-06-30 06:40:11 [28029] TRACE:  instruction : select prs_name from pg_ts_cfg where oid = $1
2005-06-30 06:40:11 [28029] TRACE:  instruction : select lt.tokid, pg_ts_cfgmap.dict_name from pg_ts_cfgmap, pg_ts_cfg, token_type( $1 ) as lt where lt.alias = pg_ts_cfgmap.tok_alias and pg_ts_cfgmap.ts_name = pg_ts_cfg.ts_name and pg_ts_cfg.oid= $2 order by lt.tokid desc;
2005-06-30 06:40:11 [28029] TRACE:  instruction : select oid from pg_ts_parser where prs_name = $1
2005-06-30 06:40:11 [28029] TRACE:  instruction : select prs_start, prs_nexttoken, prs_end, prs_lextype, prs_headline from pg_ts_parser where oid = $1
2005-06-30 06:40:11 [28029] TRACE:  instruction : select oid from pg_ts_dict where dict_name = $1
2005-06-30 06:40:11 [28029] TRACE:  instruction : select dict_init, dict_initoption, dict_lexize from pg_ts_dict where oid = $1
2005-06-30 06:40:11 [28029] TRACE:  instruction : select ar_code,ar_code_aff,
	    				coalesce(ar_lib_sodipro_fr,ar_lib_fr,ar_lib_en) as libelle,
	    	        	COALESCE(ar_texte_fr,ar_texte_en) as description,
	            		ar_type,
	    				prix_article_client(ar_code,'',1) as ar_prix
	    			from article
	            	where ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
	            	limit 10 OFFSET 0
2005-06-30 06:40:11 [28029] TRACE:  instruction : SELECT   $1  is null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 21 at if
2005-06-30 06:40:11 [28029] TRACE:  instruction : SELECT  cl_code,cl_groupe_prix,cl_groupe_rem from client where cl_code= $1  and  $2  is not null and  $3  <>''
CONTEXTE :  PL/pgSQL function "prix_article_client" line 25 at select into variables
2005-06-30 06:40:11 [28029] TRACE:  instruction : SELECT  ga_code from article where ar_code= $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 30 at select into variables
2005-06-30 06:40:11 [28029] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 31 at if
2005-06-30 06:40:11 [28029] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 37 at if
2005-06-30 06:40:11 [28029] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 45 at if
2005-06-30 06:40:11 [28029] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 53 at if
2005-06-30 06:40:11 [28029] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 62 at if
2005-06-30 06:40:11 [28029] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 71 at if
2005-06-30 06:40:11 [28029] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 80 at if
2005-06-30 06:40:11 [28029] TRACE:  instruction : SELECT prix_article_public( $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:40:11 [28029] TRACE:  instruction : SELECT  _recherche_prix('Tous les clients',null, $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:40:11 [28029] TRACE:  instruction : SELECT  coalesce( $1 ,0)=0
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 11 at if
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:40:11 [28029] TRACE:  instruction : SELECT  np_pu FROM nav_prix WHERE np_type_vente= $1  AND coalesce(np_code_vente,'') = coalesce( $2 ,'') AND np_ar_code= $3  AND ( (np_date_deb <= current_date and current_date <= np_date_fin) OR (np_date_deb is null and current_date <= np_date_fin) OR (np_date_deb <= current_date and np_date_fin is null) OR (np_date_deb is null and np_date_fin is null) ) AND  $4  >= np_qte_mini order by np_qte_mini desc,np_date_deb desc
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 15 at select into variables
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:40:11 [28029] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 27 at return
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:40:11 [28029] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 90 at if
2005-06-30 06:40:11 [28029] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 91 at return
2005-06-30 06:41:12 [28030] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:41:12 [28030] TRACE:  Connexion autorisée : utilisateur=sodipro base de données=sodipro
2005-06-30 06:41:12 [28030] TRACE:  instruction : select count(*) from article where  ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
2005-06-30 06:41:12 [28030] TRACE:  instruction : select oid from pg_ts_cfg where ts_name = $1
2005-06-30 06:41:12 [28030] TRACE:  instruction : select prs_name from pg_ts_cfg where oid = $1
2005-06-30 06:41:12 [28030] TRACE:  instruction : select lt.tokid, pg_ts_cfgmap.dict_name from pg_ts_cfgmap, pg_ts_cfg, token_type( $1 ) as lt where lt.alias = pg_ts_cfgmap.tok_alias and pg_ts_cfgmap.ts_name = pg_ts_cfg.ts_name and pg_ts_cfg.oid= $2 order by lt.tokid desc;
2005-06-30 06:41:12 [28030] TRACE:  instruction : select oid from pg_ts_parser where prs_name = $1
2005-06-30 06:41:12 [28030] TRACE:  instruction : select prs_start, prs_nexttoken, prs_end, prs_lextype, prs_headline from pg_ts_parser where oid = $1
2005-06-30 06:41:12 [28030] TRACE:  instruction : select oid from pg_ts_dict where dict_name = $1
2005-06-30 06:41:12 [28030] TRACE:  instruction : select dict_init, dict_initoption, dict_lexize from pg_ts_dict where oid = $1
2005-06-30 06:41:12 [28030] TRACE:  instruction : select ar_code,ar_code_aff,
	    				coalesce(ar_lib_sodipro_fr,ar_lib_fr,ar_lib_en) as libelle,
	    	        	COALESCE(ar_texte_fr,ar_texte_en) as description,
	            		ar_type,
	    				prix_article_client(ar_code,'',1) as ar_prix
	    			from article
	            	where ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
	            	limit 10 OFFSET 0
2005-06-30 06:41:12 [28030] TRACE:  instruction : SELECT   $1  is null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 21 at if
2005-06-30 06:41:12 [28030] TRACE:  instruction : SELECT  cl_code,cl_groupe_prix,cl_groupe_rem from client where cl_code= $1  and  $2  is not null and  $3  <>''
CONTEXTE :  PL/pgSQL function "prix_article_client" line 25 at select into variables
2005-06-30 06:41:12 [28030] TRACE:  instruction : SELECT  ga_code from article where ar_code= $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 30 at select into variables
2005-06-30 06:41:12 [28030] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 31 at if
2005-06-30 06:41:12 [28030] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 37 at if
2005-06-30 06:41:12 [28030] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 45 at if
2005-06-30 06:41:12 [28030] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 53 at if
2005-06-30 06:41:12 [28030] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 62 at if
2005-06-30 06:41:12 [28030] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 71 at if
2005-06-30 06:41:12 [28030] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 80 at if
2005-06-30 06:41:12 [28030] TRACE:  instruction : SELECT prix_article_public( $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:41:12 [28030] TRACE:  instruction : SELECT  _recherche_prix('Tous les clients',null, $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:41:12 [28030] TRACE:  instruction : SELECT  coalesce( $1 ,0)=0
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 11 at if
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:41:12 [28030] TRACE:  instruction : SELECT  np_pu FROM nav_prix WHERE np_type_vente= $1  AND coalesce(np_code_vente,'') = coalesce( $2 ,'') AND np_ar_code= $3  AND ( (np_date_deb <= current_date and current_date <= np_date_fin) OR (np_date_deb is null and current_date <= np_date_fin) OR (np_date_deb <= current_date and np_date_fin is null) OR (np_date_deb is null and np_date_fin is null) ) AND  $4  >= np_qte_mini order by np_qte_mini desc,np_date_deb desc
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 15 at select into variables
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:41:12 [28030] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 27 at return
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:41:12 [28030] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 90 at if
2005-06-30 06:41:12 [28030] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 91 at return
2005-06-30 06:42:12 [28033] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:42:12 [28033] TRACE:  Connexion autorisée : utilisateur=sodipro base de données=sodipro
2005-06-30 06:42:12 [28033] TRACE:  instruction : select count(*) from article where  ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
2005-06-30 06:42:13 [28033] TRACE:  instruction : select oid from pg_ts_cfg where ts_name = $1
2005-06-30 06:42:13 [28033] TRACE:  instruction : select prs_name from pg_ts_cfg where oid = $1
2005-06-30 06:42:13 [28033] TRACE:  instruction : select lt.tokid, pg_ts_cfgmap.dict_name from pg_ts_cfgmap, pg_ts_cfg, token_type( $1 ) as lt where lt.alias = pg_ts_cfgmap.tok_alias and pg_ts_cfgmap.ts_name = pg_ts_cfg.ts_name and pg_ts_cfg.oid= $2 order by lt.tokid desc;
2005-06-30 06:42:13 [28033] TRACE:  instruction : select oid from pg_ts_parser where prs_name = $1
2005-06-30 06:42:13 [28033] TRACE:  instruction : select prs_start, prs_nexttoken, prs_end, prs_lextype, prs_headline from pg_ts_parser where oid = $1
2005-06-30 06:42:13 [28033] TRACE:  instruction : select oid from pg_ts_dict where dict_name = $1
2005-06-30 06:42:13 [28033] TRACE:  instruction : select dict_init, dict_initoption, dict_lexize from pg_ts_dict where oid = $1
2005-06-30 06:42:13 [28033] TRACE:  instruction : select ar_code,ar_code_aff,
	    				coalesce(ar_lib_sodipro_fr,ar_lib_fr,ar_lib_en) as libelle,
	    	        	COALESCE(ar_texte_fr,ar_texte_en) as description,
	            		ar_type,
	    				prix_article_client(ar_code,'',1) as ar_prix
	    			from article
	            	where ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
	            	limit 10 OFFSET 0
2005-06-30 06:42:13 [28033] TRACE:  instruction : SELECT   $1  is null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 21 at if
2005-06-30 06:42:13 [28033] TRACE:  instruction : SELECT  cl_code,cl_groupe_prix,cl_groupe_rem from client where cl_code= $1  and  $2  is not null and  $3  <>''
CONTEXTE :  PL/pgSQL function "prix_article_client" line 25 at select into variables
2005-06-30 06:42:13 [28033] TRACE:  instruction : SELECT  ga_code from article where ar_code= $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 30 at select into variables
2005-06-30 06:42:13 [28033] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 31 at if
2005-06-30 06:42:13 [28033] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 37 at if
2005-06-30 06:42:13 [28033] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 45 at if
2005-06-30 06:42:13 [28033] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 53 at if
2005-06-30 06:42:13 [28033] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 62 at if
2005-06-30 06:42:13 [28033] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 71 at if
2005-06-30 06:42:13 [28033] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 80 at if
2005-06-30 06:42:13 [28033] TRACE:  instruction : SELECT prix_article_public( $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:42:13 [28033] TRACE:  instruction : SELECT  _recherche_prix('Tous les clients',null, $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:42:13 [28033] TRACE:  instruction : SELECT  coalesce( $1 ,0)=0
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 11 at if
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:42:13 [28033] TRACE:  instruction : SELECT  np_pu FROM nav_prix WHERE np_type_vente= $1  AND coalesce(np_code_vente,'') = coalesce( $2 ,'') AND np_ar_code= $3  AND ( (np_date_deb <= current_date and current_date <= np_date_fin) OR (np_date_deb is null and current_date <= np_date_fin) OR (np_date_deb <= current_date and np_date_fin is null) OR (np_date_deb is null and np_date_fin is null) ) AND  $4  >= np_qte_mini order by np_qte_mini desc,np_date_deb desc
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 15 at select into variables
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:42:13 [28033] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 27 at return
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:42:13 [28033] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 90 at if
2005-06-30 06:42:13 [28033] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 91 at return
2005-06-30 06:43:13 [28036] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:43:13 [28036] TRACE:  Connexion autorisée : utilisateur=sodipro base de données=sodipro
2005-06-30 06:43:13 [28036] TRACE:  instruction : select count(*) from article where  ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
2005-06-30 06:43:13 [28036] TRACE:  instruction : select oid from pg_ts_cfg where ts_name = $1
2005-06-30 06:43:13 [28036] TRACE:  instruction : select prs_name from pg_ts_cfg where oid = $1
2005-06-30 06:43:13 [28036] TRACE:  instruction : select lt.tokid, pg_ts_cfgmap.dict_name from pg_ts_cfgmap, pg_ts_cfg, token_type( $1 ) as lt where lt.alias = pg_ts_cfgmap.tok_alias and pg_ts_cfgmap.ts_name = pg_ts_cfg.ts_name and pg_ts_cfg.oid= $2 order by lt.tokid desc;
2005-06-30 06:43:13 [28036] TRACE:  instruction : select oid from pg_ts_parser where prs_name = $1
2005-06-30 06:43:13 [28036] TRACE:  instruction : select prs_start, prs_nexttoken, prs_end, prs_lextype, prs_headline from pg_ts_parser where oid = $1
2005-06-30 06:43:13 [28036] TRACE:  instruction : select oid from pg_ts_dict where dict_name = $1
2005-06-30 06:43:13 [28036] TRACE:  instruction : select dict_init, dict_initoption, dict_lexize from pg_ts_dict where oid = $1
2005-06-30 06:43:14 [28036] TRACE:  instruction : select ar_code,ar_code_aff,
	    				coalesce(ar_lib_sodipro_fr,ar_lib_fr,ar_lib_en) as libelle,
	    	        	COALESCE(ar_texte_fr,ar_texte_en) as description,
	            		ar_type,
	    				prix_article_client(ar_code,'',1) as ar_prix
	    			from article
	            	where ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
	            	limit 10 OFFSET 0
2005-06-30 06:43:14 [28036] TRACE:  instruction : SELECT   $1  is null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 21 at if
2005-06-30 06:43:14 [28036] TRACE:  instruction : SELECT  cl_code,cl_groupe_prix,cl_groupe_rem from client where cl_code= $1  and  $2  is not null and  $3  <>''
CONTEXTE :  PL/pgSQL function "prix_article_client" line 25 at select into variables
2005-06-30 06:43:14 [28036] TRACE:  instruction : SELECT  ga_code from article where ar_code= $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 30 at select into variables
2005-06-30 06:43:14 [28036] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 31 at if
2005-06-30 06:43:14 [28036] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 37 at if
2005-06-30 06:43:14 [28036] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 45 at if
2005-06-30 06:43:14 [28036] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 53 at if
2005-06-30 06:43:14 [28036] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 62 at if
2005-06-30 06:43:14 [28036] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 71 at if
2005-06-30 06:43:14 [28036] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 80 at if
2005-06-30 06:43:14 [28036] TRACE:  instruction : SELECT prix_article_public( $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:43:14 [28036] TRACE:  instruction : SELECT  _recherche_prix('Tous les clients',null, $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:43:14 [28036] TRACE:  instruction : SELECT  coalesce( $1 ,0)=0
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 11 at if
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:43:14 [28036] TRACE:  instruction : SELECT  np_pu FROM nav_prix WHERE np_type_vente= $1  AND coalesce(np_code_vente,'') = coalesce( $2 ,'') AND np_ar_code= $3  AND ( (np_date_deb <= current_date and current_date <= np_date_fin) OR (np_date_deb is null and current_date <= np_date_fin) OR (np_date_deb <= current_date and np_date_fin is null) OR (np_date_deb is null and np_date_fin is null) ) AND  $4  >= np_qte_mini order by np_qte_mini desc,np_date_deb desc
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 15 at select into variables
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:43:14 [28036] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 27 at return
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:43:14 [28036] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 90 at if
2005-06-30 06:43:14 [28036] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 91 at return
2005-06-30 06:44:14 [28040] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:44:14 [28040] TRACE:  Connexion autorisée : utilisateur=sodipro base de données=sodipro
2005-06-30 06:44:14 [28040] TRACE:  instruction : select count(*) from article where  ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
2005-06-30 06:44:14 [28040] TRACE:  instruction : select oid from pg_ts_cfg where ts_name = $1
2005-06-30 06:44:14 [28040] TRACE:  instruction : select prs_name from pg_ts_cfg where oid = $1
2005-06-30 06:44:14 [28040] TRACE:  instruction : select lt.tokid, pg_ts_cfgmap.dict_name from pg_ts_cfgmap, pg_ts_cfg, token_type( $1 ) as lt where lt.alias = pg_ts_cfgmap.tok_alias and pg_ts_cfgmap.ts_name = pg_ts_cfg.ts_name and pg_ts_cfg.oid= $2 order by lt.tokid desc;
2005-06-30 06:44:14 [28040] TRACE:  instruction : select oid from pg_ts_parser where prs_name = $1
2005-06-30 06:44:14 [28040] TRACE:  instruction : select prs_start, prs_nexttoken, prs_end, prs_lextype, prs_headline from pg_ts_parser where oid = $1
2005-06-30 06:44:14 [28040] TRACE:  instruction : select oid from pg_ts_dict where dict_name = $1
2005-06-30 06:44:14 [28040] TRACE:  instruction : select dict_init, dict_initoption, dict_lexize from pg_ts_dict where oid = $1
2005-06-30 06:44:14 [28040] TRACE:  instruction : select ar_code,ar_code_aff,
	    				coalesce(ar_lib_sodipro_fr,ar_lib_fr,ar_lib_en) as libelle,
	    	        	COALESCE(ar_texte_fr,ar_texte_en) as description,
	            		ar_type,
	    				prix_article_client(ar_code,'',1) as ar_prix
	    			from article
	            	where ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
	            	limit 10 OFFSET 0
2005-06-30 06:44:15 [28040] TRACE:  instruction : SELECT   $1  is null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 21 at if
2005-06-30 06:44:15 [28040] TRACE:  instruction : SELECT  cl_code,cl_groupe_prix,cl_groupe_rem from client where cl_code= $1  and  $2  is not null and  $3  <>''
CONTEXTE :  PL/pgSQL function "prix_article_client" line 25 at select into variables
2005-06-30 06:44:15 [28040] TRACE:  instruction : SELECT  ga_code from article where ar_code= $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 30 at select into variables
2005-06-30 06:44:15 [28040] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 31 at if
2005-06-30 06:44:15 [28040] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 37 at if
2005-06-30 06:44:15 [28040] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 45 at if
2005-06-30 06:44:15 [28040] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 53 at if
2005-06-30 06:44:15 [28040] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 62 at if
2005-06-30 06:44:15 [28040] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 71 at if
2005-06-30 06:44:15 [28040] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 80 at if
2005-06-30 06:44:15 [28040] TRACE:  instruction : SELECT prix_article_public( $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:44:15 [28040] TRACE:  instruction : SELECT  _recherche_prix('Tous les clients',null, $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:44:15 [28040] TRACE:  instruction : SELECT  coalesce( $1 ,0)=0
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 11 at if
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:44:15 [28040] TRACE:  instruction : SELECT  np_pu FROM nav_prix WHERE np_type_vente= $1  AND coalesce(np_code_vente,'') = coalesce( $2 ,'') AND np_ar_code= $3  AND ( (np_date_deb <= current_date and current_date <= np_date_fin) OR (np_date_deb is null and current_date <= np_date_fin) OR (np_date_deb <= current_date and np_date_fin is null) OR (np_date_deb is null and np_date_fin is null) ) AND  $4  >= np_qte_mini order by np_qte_mini desc,np_date_deb desc
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 15 at select into variables
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:44:15 [28040] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 27 at return
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:44:15 [28040] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 90 at if
2005-06-30 06:44:15 [28040] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 91 at return
2005-06-30 06:44:45 [28041] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:44:45 [28041] TRACE:  Connexion autorisée : utilisateur=postgres base de données=template1
2005-06-30 06:44:45 [28042] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:44:45 [28042] TRACE:  Connexion autorisée : utilisateur=postgres base de données=phppgadmin
2005-06-30 06:44:45 [28043] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:44:45 [28043] TRACE:  Connexion autorisée : utilisateur=postgres base de données=sodipro
2005-06-30 06:44:45 [28044] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:44:45 [28044] TRACE:  Connexion autorisée : utilisateur=postgres base de données=bug_tracker
2005-06-30 06:45:02 [28055] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:45:02 [28055] TRACE:  Connexion autorisée : utilisateur=sodipro base de données=sodipro
2005-06-30 06:45:15 [28056] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:45:15 [28056] TRACE:  Connexion autorisée : utilisateur=sodipro base de données=sodipro
2005-06-30 06:45:15 [28056] TRACE:  instruction : select count(*) from article where  ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
2005-06-30 06:45:16 [28056] TRACE:  instruction : select oid from pg_ts_cfg where ts_name = $1
2005-06-30 06:45:16 [28056] TRACE:  instruction : select prs_name from pg_ts_cfg where oid = $1
2005-06-30 06:45:16 [28056] TRACE:  instruction : select lt.tokid, pg_ts_cfgmap.dict_name from pg_ts_cfgmap, pg_ts_cfg, token_type( $1 ) as lt where lt.alias = pg_ts_cfgmap.tok_alias and pg_ts_cfgmap.ts_name = pg_ts_cfg.ts_name and pg_ts_cfg.oid= $2 order by lt.tokid desc;
2005-06-30 06:45:16 [28056] TRACE:  instruction : select oid from pg_ts_parser where prs_name = $1
2005-06-30 06:45:16 [28056] TRACE:  instruction : select prs_start, prs_nexttoken, prs_end, prs_lextype, prs_headline from pg_ts_parser where oid = $1
2005-06-30 06:45:16 [28056] TRACE:  instruction : select oid from pg_ts_dict where dict_name = $1
2005-06-30 06:45:16 [28056] TRACE:  instruction : select dict_init, dict_initoption, dict_lexize from pg_ts_dict where oid = $1
2005-06-30 06:49:28 [28056] TRACE:  instruction : select ar_code,ar_code_aff,
	    				coalesce(ar_lib_sodipro_fr,ar_lib_fr,ar_lib_en) as libelle,
	    	        	COALESCE(ar_texte_fr,ar_texte_en) as description,
	            		ar_type,
	    				prix_article_client(ar_code,'',1) as ar_prix
	    			from article
	            	where ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
	            	limit 10 OFFSET 0
2005-06-30 06:49:28 [28056] TRACE:  instruction : SELECT   $1  is null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 21 at if
2005-06-30 06:49:28 [28056] TRACE:  instruction : SELECT  cl_code,cl_groupe_prix,cl_groupe_rem from client where cl_code= $1  and  $2  is not null and  $3  <>''
CONTEXTE :  PL/pgSQL function "prix_article_client" line 25 at select into variables
2005-06-30 06:49:28 [28056] TRACE:  instruction : SELECT  ga_code from article where ar_code= $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 30 at select into variables
2005-06-30 06:49:28 [28056] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 31 at if
2005-06-30 06:49:28 [28056] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 37 at if
2005-06-30 06:49:28 [28056] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 45 at if
2005-06-30 06:49:28 [28056] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 53 at if
2005-06-30 06:49:28 [28056] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 62 at if
2005-06-30 06:49:28 [28056] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 71 at if
2005-06-30 06:49:28 [28056] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 80 at if
2005-06-30 06:49:28 [28056] TRACE:  instruction : SELECT prix_article_public( $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:49:28 [28056] TRACE:  instruction : SELECT  _recherche_prix('Tous les clients',null, $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:49:28 [28056] TRACE:  instruction : SELECT  coalesce( $1 ,0)=0
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 11 at if
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:49:28 [28056] TRACE:  instruction : SELECT  np_pu FROM nav_prix WHERE np_type_vente= $1  AND coalesce(np_code_vente,'') = coalesce( $2 ,'') AND np_ar_code= $3  AND ( (np_date_deb <= current_date and current_date <= np_date_fin) OR (np_date_deb is null and current_date <= np_date_fin) OR (np_date_deb <= current_date and np_date_fin is null) OR (np_date_deb is null and np_date_fin is null) ) AND  $4  >= np_qte_mini order by np_qte_mini desc,np_date_deb desc
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 15 at select into variables
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:49:29 [28056] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 27 at return
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 06:49:29 [28056] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 90 at if
2005-06-30 06:49:29 [28056] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 91 at return
2005-06-30 06:49:45 [28074] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:49:45 [28074] TRACE:  Connexion autorisée : utilisateur=postgres base de données=template1
2005-06-30 06:49:45 [28075] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:49:45 [28075] TRACE:  Connexion autorisée : utilisateur=postgres base de données=phppgadmin
2005-06-30 06:49:45 [28076] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:49:45 [28076] TRACE:  Connexion autorisée : utilisateur=postgres base de données=sodipro
2005-06-30 06:49:47 [28077] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:49:47 [28077] TRACE:  Connexion autorisée : utilisateur=postgres base de données=bug_tracker
2005-06-30 06:50:29 [28082] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:50:29 [28082] TRACE:  Connexion autorisée : utilisateur=sodipro base de données=sodipro
2005-06-30 06:50:30 [28082] TRACE:  instruction : select count(*) from article where  ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
2005-06-30 06:50:30 [28082] TRACE:  instruction : select oid from pg_ts_cfg where ts_name = $1
2005-06-30 06:50:30 [28082] TRACE:  instruction : select prs_name from pg_ts_cfg where oid = $1
2005-06-30 06:50:30 [28082] TRACE:  instruction : select lt.tokid, pg_ts_cfgmap.dict_name from pg_ts_cfgmap, pg_ts_cfg, token_type( $1 ) as lt where lt.alias = pg_ts_cfgmap.tok_alias and pg_ts_cfgmap.ts_name = pg_ts_cfg.ts_name and pg_ts_cfg.oid= $2 order by lt.tokid desc;
2005-06-30 06:50:30 [28082] TRACE:  instruction : select oid from pg_ts_parser where prs_name = $1
2005-06-30 06:50:30 [28082] TRACE:  instruction : select prs_start, prs_nexttoken, prs_end, prs_lextype, prs_headline from pg_ts_parser where oid = $1
2005-06-30 06:50:30 [28082] TRACE:  instruction : select oid from pg_ts_dict where dict_name = $1
2005-06-30 06:50:30 [28082] TRACE:  instruction : select dict_init, dict_initoption, dict_lexize from pg_ts_dict where oid = $1
2005-06-30 06:51:55 [28087] TRACE:  Recyclage du journal de transaction «00000036000000D0»
2005-06-30 06:51:55 [28087] TRACE:  Recyclage du journal de transaction «00000036000000D1»
2005-06-30 06:51:55 [28087] TRACE:  Recyclage du journal de transaction «00000036000000D2»
2005-06-30 06:51:55 [28087] TRACE:  Recyclage du journal de transaction «00000036000000D3»
2005-06-30 06:54:51 [28100] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:54:51 [28100] TRACE:  Connexion autorisée : utilisateur=postgres base de données=template1
2005-06-30 06:54:51 [28101] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:54:51 [28101] TRACE:  Connexion autorisée : utilisateur=postgres base de données=phppgadmin
2005-06-30 06:54:51 [28102] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:54:51 [28102] TRACE:  Connexion autorisée : utilisateur=postgres base de données=sodipro
2005-06-30 06:54:51 [28103] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:54:51 [28103] TRACE:  Connexion autorisée : utilisateur=postgres base de données=bug_tracker
2005-06-30 06:57:05 [28112] TRACE:  Recyclage du journal de transaction «00000036000000DA»
2005-06-30 06:57:05 [28112] TRACE:  Recyclage du journal de transaction «00000036000000D5»
2005-06-30 06:57:05 [28112] TRACE:  Recyclage du journal de transaction «00000036000000D6»
2005-06-30 06:57:05 [28112] TRACE:  Recyclage du journal de transaction «00000036000000D7»
2005-06-30 06:57:05 [28112] TRACE:  Recyclage du journal de transaction «00000036000000D8»
2005-06-30 06:57:05 [28112] TRACE:  Recyclage du journal de transaction «00000036000000D9»
2005-06-30 06:57:05 [28112] TRACE:  Recyclage du journal de transaction «00000036000000D4»
2005-06-30 06:59:51 [28125] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:59:51 [28125] TRACE:  Connexion autorisée : utilisateur=postgres base de données=template1
2005-06-30 06:59:52 [28126] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:59:52 [28126] TRACE:  Connexion autorisée : utilisateur=postgres base de données=phppgadmin
2005-06-30 06:59:52 [28127] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:59:52 [28127] TRACE:  Connexion autorisée : utilisateur=postgres base de données=sodipro
2005-06-30 06:59:52 [28128] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 06:59:52 [28128] TRACE:  Connexion autorisée : utilisateur=postgres base de données=bug_tracker
2005-06-30 07:02:16 [28137] TRACE:  Recyclage du journal de transaction «00000036000000DF»
2005-06-30 07:02:16 [28137] TRACE:  Recyclage du journal de transaction «00000036000000DB»
2005-06-30 07:02:16 [28137] TRACE:  Recyclage du journal de transaction «00000036000000DC»
2005-06-30 07:02:16 [28137] TRACE:  Recyclage du journal de transaction «00000036000000DD»
2005-06-30 07:02:16 [28137] TRACE:  Recyclage du journal de transaction «00000036000000DE»
2005-06-30 07:04:54 [28150] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 07:04:54 [28150] TRACE:  Connexion autorisée : utilisateur=postgres base de données=template1
2005-06-30 07:04:54 [28151] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 07:04:54 [28151] TRACE:  Connexion autorisée : utilisateur=postgres base de données=phppgadmin
2005-06-30 07:04:54 [28152] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 07:04:54 [28152] TRACE:  Connexion autorisée : utilisateur=postgres base de données=sodipro
2005-06-30 07:04:54 [28153] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 07:04:54 [28153] TRACE:  Connexion autorisée : utilisateur=postgres base de données=bug_tracker
2005-06-30 07:05:44 [28158] TRACE:  Recyclage du journal de transaction «00000036000000E5»
2005-06-30 07:05:44 [28158] TRACE:  Recyclage du journal de transaction «00000036000000E0»
2005-06-30 07:05:44 [28158] TRACE:  Recyclage du journal de transaction «00000036000000E1»
2005-06-30 07:05:44 [28158] TRACE:  Recyclage du journal de transaction «00000036000000E2»
2005-06-30 07:05:44 [28158] TRACE:  Recyclage du journal de transaction «00000036000000E3»
2005-06-30 07:05:44 [28158] TRACE:  Recyclage du journal de transaction «00000036000000E4»
2005-06-30 07:07:43 [28082] TRACE:  instruction : select ar_code,ar_code_aff,
	    				coalesce(ar_lib_sodipro_fr,ar_lib_fr,ar_lib_en) as libelle,
	    	        	COALESCE(ar_texte_fr,ar_texte_en) as description,
	            		ar_type,
	    				prix_article_client(ar_code,'',1) as ar_prix
	    			from article
	            	where ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
	            	limit 10 OFFSET 0
2005-06-30 07:07:43 [28082] TRACE:  instruction : SELECT   $1  is null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 21 at if
2005-06-30 07:07:43 [28082] TRACE:  instruction : SELECT  cl_code,cl_groupe_prix,cl_groupe_rem from client where cl_code= $1  and  $2  is not null and  $3  <>''
CONTEXTE :  PL/pgSQL function "prix_article_client" line 25 at select into variables
2005-06-30 07:07:43 [28082] TRACE:  instruction : SELECT  ga_code from article where ar_code= $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 30 at select into variables
2005-06-30 07:07:43 [28082] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 31 at if
2005-06-30 07:07:43 [28082] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 37 at if
2005-06-30 07:07:43 [28082] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 45 at if
2005-06-30 07:07:43 [28082] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 53 at if
2005-06-30 07:07:43 [28082] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 62 at if
2005-06-30 07:07:43 [28082] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 71 at if
2005-06-30 07:07:43 [28082] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 80 at if
2005-06-30 07:07:43 [28082] TRACE:  instruction : SELECT prix_article_public( $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 07:07:43 [28082] TRACE:  instruction : SELECT  _recherche_prix('Tous les clients',null, $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 07:07:43 [28082] TRACE:  instruction : SELECT  coalesce( $1 ,0)=0
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 11 at if
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 07:07:43 [28082] TRACE:  instruction : SELECT  np_pu FROM nav_prix WHERE np_type_vente= $1  AND coalesce(np_code_vente,'') = coalesce( $2 ,'') AND np_ar_code= $3  AND ( (np_date_deb <= current_date and current_date <= np_date_fin) OR (np_date_deb is null and current_date <= np_date_fin) OR (np_date_deb <= current_date and np_date_fin is null) OR (np_date_deb is null and np_date_fin is null) ) AND  $4  >= np_qte_mini order by np_qte_mini desc,np_date_deb desc
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 15 at select into variables
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 07:07:43 [28082] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 27 at return
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 07:07:43 [28082] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 90 at if
2005-06-30 07:07:43 [28082] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 91 at return
2005-06-30 07:08:43 [28171] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 07:08:43 [28171] TRACE:  Connexion autorisée : utilisateur=sodipro base de données=sodipro
2005-06-30 07:08:43 [28171] TRACE:  instruction : select count(*) from article where  ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
2005-06-30 07:08:43 [28171] TRACE:  instruction : select oid from pg_ts_cfg where ts_name = $1
2005-06-30 07:08:43 [28171] TRACE:  instruction : select prs_name from pg_ts_cfg where oid = $1
2005-06-30 07:08:43 [28171] TRACE:  instruction : select lt.tokid, pg_ts_cfgmap.dict_name from pg_ts_cfgmap, pg_ts_cfg, token_type( $1 ) as lt where lt.alias = pg_ts_cfgmap.tok_alias and pg_ts_cfgmap.ts_name = pg_ts_cfg.ts_name and pg_ts_cfg.oid= $2 order by lt.tokid desc;
2005-06-30 07:08:43 [28171] TRACE:  instruction : select oid from pg_ts_parser where prs_name = $1
2005-06-30 07:08:43 [28171] TRACE:  instruction : select prs_start, prs_nexttoken, prs_end, prs_lextype, prs_headline from pg_ts_parser where oid = $1
2005-06-30 07:08:43 [28171] TRACE:  instruction : select oid from pg_ts_dict where dict_name = $1
2005-06-30 07:08:43 [28171] TRACE:  instruction : select dict_init, dict_initoption, dict_lexize from pg_ts_dict where oid = $1
2005-06-30 07:08:47 [28171] TRACE:  instruction : select ar_code,ar_code_aff,
	    				coalesce(ar_lib_sodipro_fr,ar_lib_fr,ar_lib_en) as libelle,
	    	        	COALESCE(ar_texte_fr,ar_texte_en) as description,
	            		ar_type,
	    				prix_article_client(ar_code,'',1) as ar_prix
	    			from article
	            	where ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
	            	limit 10 OFFSET 0
2005-06-30 07:08:48 [28055] ERREUR:  Bloquage détecté
DETAIL :  Le processus 28055 attend AccessExclusiveLock sur la relation 26921306 de la base de données 142063; bloqué par le processus 28171.
	Le processus 28171 attend AccessShareLock sur la relation 26921305 de la base de données 142063; bloqué par le processus 28055.
CONTEXTE :  PL/pgSQL function "maj_stock_article" line 13 at SQL statement
2005-06-30 07:08:48 [28180] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 07:08:48 [28180] TRACE:  Connexion autorisée : utilisateur=sodipro base de données=sodipro
2005-06-30 07:08:49 [28171] TRACE:  instruction : SELECT   $1  is null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 21 at if
2005-06-30 07:08:49 [28171] TRACE:  instruction : SELECT  cl_code,cl_groupe_prix,cl_groupe_rem from client where cl_code= $1  and  $2  is not null and  $3  <>''
CONTEXTE :  PL/pgSQL function "prix_article_client" line 25 at select into variables
2005-06-30 07:08:49 [28171] TRACE:  instruction : SELECT  ga_code from article where ar_code= $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 30 at select into variables
2005-06-30 07:08:49 [28171] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 31 at if
2005-06-30 07:08:49 [28171] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 37 at if
2005-06-30 07:08:49 [28171] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 45 at if
2005-06-30 07:08:49 [28171] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 53 at if
2005-06-30 07:08:49 [28171] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 62 at if
2005-06-30 07:08:49 [28171] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 71 at if
2005-06-30 07:08:49 [28171] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 80 at if
2005-06-30 07:08:49 [28171] TRACE:  instruction : SELECT prix_article_public( $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 07:08:49 [28171] TRACE:  instruction : SELECT  _recherche_prix('Tous les clients',null, $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 07:08:49 [28171] TRACE:  instruction : SELECT  coalesce( $1 ,0)=0
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 11 at if
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 07:08:49 [28171] TRACE:  instruction : SELECT  np_pu FROM nav_prix WHERE np_type_vente= $1  AND coalesce(np_code_vente,'') = coalesce( $2 ,'') AND np_ar_code= $3  AND ( (np_date_deb <= current_date and current_date <= np_date_fin) OR (np_date_deb is null and current_date <= np_date_fin) OR (np_date_deb <= current_date and np_date_fin is null) OR (np_date_deb is null and np_date_fin is null) ) AND  $4  >= np_qte_mini order by np_qte_mini desc,np_date_deb desc
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 15 at select into variables
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 07:08:49 [28171] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 27 at return
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 07:08:49 [28171] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 90 at if
2005-06-30 07:08:49 [28171] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 91 at return
2005-06-30 07:09:49 [28198] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 07:09:49 [28198] TRACE:  Connexion autorisée : utilisateur=sodipro base de données=sodipro
2005-06-30 07:09:50 [28198] TRACE:  instruction : select count(*) from article where  ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
2005-06-30 07:09:50 [28198] TRACE:  instruction : select oid from pg_ts_cfg where ts_name = $1
2005-06-30 07:09:50 [28198] TRACE:  instruction : select prs_name from pg_ts_cfg where oid = $1
2005-06-30 07:09:50 [28198] TRACE:  instruction : select lt.tokid, pg_ts_cfgmap.dict_name from pg_ts_cfgmap, pg_ts_cfg, token_type( $1 ) as lt where lt.alias = pg_ts_cfgmap.tok_alias and pg_ts_cfgmap.ts_name = pg_ts_cfg.ts_name and pg_ts_cfg.oid= $2 order by lt.tokid desc;
2005-06-30 07:09:50 [28198] TRACE:  instruction : select oid from pg_ts_parser where prs_name = $1
2005-06-30 07:09:50 [28198] TRACE:  instruction : select prs_start, prs_nexttoken, prs_end, prs_lextype, prs_headline from pg_ts_parser where oid = $1
2005-06-30 07:09:50 [28198] TRACE:  instruction : select oid from pg_ts_dict where dict_name = $1
2005-06-30 07:09:50 [28198] TRACE:  instruction : select dict_init, dict_initoption, dict_lexize from pg_ts_dict where oid = $1
2005-06-30 07:09:51 [28198] TRACE:  instruction : select ar_code,ar_code_aff,
	    				coalesce(ar_lib_sodipro_fr,ar_lib_fr,ar_lib_en) as libelle,
	    	        	COALESCE(ar_texte_fr,ar_texte_en) as description,
	            		ar_type,
	    				prix_article_client(ar_code,'',1) as ar_prix
	    			from article
	            	where ar_actif=1 and ar_affiche=1 and ( idxFTIfr @@ to_tsquery('default_french','pli') or idxFTIen @@ to_tsquery('default','pli') )
	            	limit 10 OFFSET 0
2005-06-30 07:09:51 [28198] TRACE:  instruction : SELECT   $1  is null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 21 at if
2005-06-30 07:09:51 [28198] TRACE:  instruction : SELECT  cl_code,cl_groupe_prix,cl_groupe_rem from client where cl_code= $1  and  $2  is not null and  $3  <>''
CONTEXTE :  PL/pgSQL function "prix_article_client" line 25 at select into variables
2005-06-30 07:09:51 [28198] TRACE:  instruction : SELECT  ga_code from article where ar_code= $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 30 at select into variables
2005-06-30 07:09:51 [28198] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 31 at if
2005-06-30 07:09:51 [28198] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 37 at if
2005-06-30 07:09:51 [28198] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 45 at if
2005-06-30 07:09:51 [28198] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 53 at if
2005-06-30 07:09:51 [28198] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 62 at if
2005-06-30 07:09:51 [28198] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 71 at if
2005-06-30 07:09:51 [28198] TRACE:  instruction : SELECT   $1  is not null and  $2  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 80 at if
2005-06-30 07:09:51 [28198] TRACE:  instruction : SELECT prix_article_public( $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 07:09:51 [28198] TRACE:  instruction : SELECT  _recherche_prix('Tous les clients',null, $1 , $2 )
CONTEXTE :  PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 07:09:51 [28198] TRACE:  instruction : SELECT  coalesce( $1 ,0)=0
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 11 at if
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 07:09:51 [28198] TRACE:  instruction : SELECT  np_pu FROM nav_prix WHERE np_type_vente= $1  AND coalesce(np_code_vente,'') = coalesce( $2 ,'') AND np_ar_code= $3  AND ( (np_date_deb <= current_date and current_date <= np_date_fin) OR (np_date_deb is null and current_date <= np_date_fin) OR (np_date_deb <= current_date and np_date_fin is null) OR (np_date_deb is null and np_date_fin is null) ) AND  $4  >= np_qte_mini order by np_qte_mini desc,np_date_deb desc
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 15 at select into variables
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 07:09:51 [28198] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "_recherche_prix" line 27 at return
	PL/pgSQL function "prix_article_public" line 5 at return
	PL/pgSQL function "prix_article_client" line 89 at assignment
2005-06-30 07:09:51 [28198] TRACE:  instruction : SELECT   $1  is not null
CONTEXTE :  PL/pgSQL function "prix_article_client" line 90 at if
2005-06-30 07:09:51 [28198] TRACE:  instruction : SELECT   $1 
CONTEXTE :  PL/pgSQL function "prix_article_client" line 91 at return
2005-06-30 07:10:01 [28209] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 07:10:01 [28209] TRACE:  Connexion autorisée : utilisateur=postgres base de données=template1
2005-06-30 07:10:01 [28210] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 07:10:01 [28210] TRACE:  Connexion autorisée : utilisateur=postgres base de données=phppgadmin
2005-06-30 07:10:01 [28211] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 07:10:01 [28211] TRACE:  Connexion autorisée : utilisateur=postgres base de données=sodipro
2005-06-30 07:10:10 [28212] TRACE:  Connexion reçue : hôte=[local] port=
2005-06-30 07:10:10 [28212] TRACE:  Connexion autorisée : utilisateur=postgres base de données=bug_tracker
2005-06-30 07:10:47 [28217] TRACE:  Recyclage du journal de transaction «00000036000000EC»
2005-06-30 07:10:47 [28217] TRACE:  Recyclage du journal de transaction «00000036000000E6»
2005-06-30 07:10:47 [28217] TRACE:  Recyclage du journal de transaction «00000036000000E7»
2005-06-30 07:10:47 [28217] TRACE:  Recyclage du j