Lookups: fix pgsql multiple-row, single-column return
[exim.git] / test / stderr / 2620
1
2 WARNING: enabling "trust" authentication for local connections
3 You can change this by editing pg_hba.conf or using the option -A, or
4 --auth-local and --auth-host, the next time you run initdb.
5 Exim version x.yz ....
6 configuration file is TESTSUITE/test-config
7 admin user
8 search_open: pgsql "NULL"
9 search_find: file="NULL"
10   key="select name from them where id='ph10';" partial=-1 affix=NULL starflags=0
11 LRU list:
12 internal_search_find: file="NULL"
13   type=pgsql key="select name from them where id='ph10';"
14 database lookup required for select name from them where id='ph10';
15 PostgreSQL query: select name from them where id='ph10';
16 PGSQL new connection: host=localhost port=1223 database=test user=CALLER
17 lookup yielded: Philip Hazel
18 search_open: pgsql "NULL"
19   cached open
20 search_find: file="NULL"
21   key="select name from them where id='ph10';" partial=-1 affix=NULL starflags=0
22 LRU list:
23 internal_search_find: file="NULL"
24   type=pgsql key="select name from them where id='ph10';"
25 cached data used for lookup of select name from them where id='ph10';
26 lookup yielded: Philip Hazel
27 search_open: pgsql "NULL"
28   cached open
29 search_find: file="NULL"
30   key="select name from them where id='xxxx';" partial=-1 affix=NULL starflags=0
31 LRU list:
32 internal_search_find: file="NULL"
33   type=pgsql key="select name from them where id='xxxx';"
34 database lookup required for select name from them where id='xxxx';
35 PostgreSQL query: select name from them where id='xxxx';
36 PGSQL using cached connection for localhost:1223/test/CALLER
37 PGSQL: no data found
38 lookup failed
39 search_open: pgsql "NULL"
40   cached open
41 search_find: file="NULL"
42   key="select name from them where id='nothing';" partial=-1 affix=NULL starflags=0
43 LRU list:
44 internal_search_find: file="NULL"
45   type=pgsql key="select name from them where id='nothing';"
46 database lookup required for select name from them where id='nothing';
47 PostgreSQL query: select name from them where id='nothing';
48 PGSQL using cached connection for localhost:1223/test/CALLER
49 lookup yielded: 
50 search_open: pgsql "NULL"
51   cached open
52 search_find: file="NULL"
53   key="select id,name from them where id='nothing';" partial=-1 affix=NULL starflags=0
54 LRU list:
55 internal_search_find: file="NULL"
56   type=pgsql key="select id,name from them where id='nothing';"
57 database lookup required for select id,name from them where id='nothing';
58 PostgreSQL query: select id,name from them where id='nothing';
59 PGSQL using cached connection for localhost:1223/test/CALLER
60 lookup yielded: id=nothing name="" 
61 search_open: pgsql "NULL"
62   cached open
63 search_find: file="NULL"
64   key="delete from them where id='nonexist';" partial=-1 affix=NULL starflags=0
65 LRU list:
66 internal_search_find: file="NULL"
67   type=pgsql key="delete from them where id='nonexist';"
68 database lookup required for delete from them where id='nonexist';
69 PostgreSQL query: delete from them where id='nonexist';
70 PGSQL using cached connection for localhost:1223/test/CALLER
71 PGSQL: command does not return any data but was successful. Rows affected: 0
72 lookup forced cache cleanup
73 lookup yielded: 0
74 search_open: pgsql "NULL"
75   cached open
76 search_find: file="NULL"
77   key="select * from them where id='quote2';" partial=-1 affix=NULL starflags=0
78 LRU list:
79 internal_search_find: file="NULL"
80   type=pgsql key="select * from them where id='quote2';"
81 database lookup required for select * from them where id='quote2';
82 PostgreSQL query: select * from them where id='quote2';
83 PGSQL using cached connection for localhost:1223/test/CALLER
84 lookup yielded: name="\"stquot" id=quote2 
85 search_open: pgsql "NULL"
86   cached open
87 search_find: file="NULL"
88   key="select * from them where id='newline';" partial=-1 affix=NULL starflags=0
89 LRU list:
90 internal_search_find: file="NULL"
91   type=pgsql key="select * from them where id='newline';"
92 database lookup required for select * from them where id='newline';
93 PostgreSQL query: select * from them where id='newline';
94 PGSQL using cached connection for localhost:1223/test/CALLER
95 lookup yielded: name="before\r
96 after" id=newline 
97 search_open: pgsql "NULL"
98   cached open
99 search_find: file="NULL"
100   key="select * from them where id='tab';" partial=-1 affix=NULL starflags=0
101 LRU list:
102 internal_search_find: file="NULL"
103   type=pgsql key="select * from them where id='tab';"
104 database lookup required for select * from them where id='tab';
105 PostgreSQL query: select * from them where id='tab';
106 PGSQL using cached connection for localhost:1223/test/CALLER
107 lookup yielded: name="x x" id=tab 
108 search_open: pgsql "NULL"
109   cached open
110 search_find: file="NULL"
111   key="select * from them where name='''stquot';" partial=-1 affix=NULL starflags=0
112 LRU list:
113 internal_search_find: file="NULL"
114   type=pgsql key="select * from them where name='''stquot';"
115 database lookup required for select * from them where name='''stquot';
116 PostgreSQL query: select * from them where name='''stquot';
117 PGSQL using cached connection for localhost:1223/test/CALLER
118 lookup yielded: name='stquot id=quote1 
119 search_open: pgsql "NULL"
120   cached open
121 search_find: file="NULL"
122   key="servers=x:localhost; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0
123 LRU list:
124 internal_search_find: file="NULL"
125   type=pgsql key="servers=x:localhost; select name from them where id='ph10';"
126 database lookup required for servers=x:localhost; select name from them where id='ph10';
127 PostgreSQL query: servers=x:localhost; select name from them where id='ph10';
128 lookup deferred: PostgreSQL server "x" not found in pgsql_servers
129 search_open: pgsql "NULL"
130   cached open
131 search_find: file="NULL"
132   key="servers=localhost::1223:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0
133 LRU list:
134 internal_search_find: file="NULL"
135   type=pgsql key="servers=localhost::1223:x; select name from them where id='ph10';"
136 database lookup required for servers=localhost::1223:x; select name from them where id='ph10';
137 PostgreSQL query: servers=localhost::1223:x; select name from them where id='ph10';
138 PGSQL using cached connection for localhost:1223/test/CALLER
139 lookup yielded: Philip Hazel
140 search_open: pgsql "NULL"
141   cached open
142 search_find: file="NULL"
143   key="servers=localhost::1223/test/CALLER/:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0
144 LRU list:
145 internal_search_find: file="NULL"
146   type=pgsql key="servers=localhost::1223/test/CALLER/:x; select name from them where id='ph10';"
147 database lookup required for servers=localhost::1223/test/CALLER/:x; select name from them where id='ph10';
148 PostgreSQL query: servers=localhost::1223/test/CALLER/:x; select name from them where id='ph10';
149 PGSQL using cached connection for localhost:1223/test/CALLER
150 lookup yielded: Philip Hazel
151 search_open: pgsql "NULL"
152   cached open
153 search_find: file="NULL"
154   key="servers=(TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER/:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0
155 LRU list:
156 internal_search_find: file="NULL"
157   type=pgsql key="servers=(TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER/:x; select name from them where id='ph10';"
158 database lookup required for servers=(TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER/:x; select name from them where id='ph10';
159 PostgreSQL query: servers=(TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER/:x; select name from them where id='ph10';
160 PGSQL new connection: socket=TESTSUITE/pgsql/.s.PGSQL.1223 database=test user=CALLER
161 lookup yielded: Philip Hazel
162 search_open: pgsql "NULL"
163   cached open
164 search_find: file="NULL"
165   key="SELECT name FROM them WHERE id IN ('ph10', 'aaaa');" partial=-1 affix=NULL starflags=0
166 LRU list:
167 internal_search_find: file="NULL"
168   type=pgsql key="SELECT name FROM them WHERE id IN ('ph10', 'aaaa');"
169 database lookup required for SELECT name FROM them WHERE id IN ('ph10', 'aaaa');
170 PostgreSQL query: SELECT name FROM them WHERE id IN ('ph10', 'aaaa');
171 PGSQL using cached connection for localhost:1223/test/CALLER
172 lookup yielded: Philip Hazel
173 Aristotle
174 search_open: pgsql "NULL"
175   cached open
176 search_find: file="NULL"
177   key="SELECT *    FROM them WHERE id IN ('ph10', 'aaaa');" partial=-1 affix=NULL starflags=0
178 LRU list:
179 internal_search_find: file="NULL"
180   type=pgsql key="SELECT *    FROM them WHERE id IN ('ph10', 'aaaa');"
181 database lookup required for SELECT *    FROM them WHERE id IN ('ph10', 'aaaa');
182 PostgreSQL query: SELECT *    FROM them WHERE id IN ('ph10', 'aaaa');
183 PGSQL using cached connection for localhost:1223/test/CALLER
184 lookup yielded: name="Philip Hazel" id=ph10 
185 name=Aristotle id=aaaa 
186 search_tidyup called
187 close PGSQL connection: (TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER
188 close PGSQL connection: localhost:1223/test/CALLER
189 >>>>>>>>>>>>>>>> Exim pid=pppp (main: expansion test) terminating with rc=0 >>>>>>>>>>>>>>>>
190 Exim version x.yz ....
191 changed uid/gid: forcing real = effective
192   uid=uuuu gid=CALLER_GID pid=pppp
193 configuration file is TESTSUITE/test-config
194 admin user
195 changed uid/gid: privilege not needed
196   uid=EXIM_UID gid=EXIM_GID pid=pppp
197 seeking password data for user "CALLER": cache not available
198 getpwnam() succeeded uid=CALLER_UID gid=CALLER_GID
199 originator: uid=CALLER_UID gid=CALLER_GID login=CALLER name=CALLER_NAME
200 sender address = CALLER@myhost.test.ex
201 sender_fullhost = [10.0.0.0]
202 sender_rcvhost = [10.0.0.0]
203 host in hosts_connection_nolog? no (option unset)
204 LOG: smtp_connection MAIN
205   SMTP connection from [10.0.0.0]
206 host in host_lookup? no (option unset)
207 set_process_info: pppp handling incoming connection from [10.0.0.0]
208 host in host_reject_connection? no (option unset)
209 host in sender_unqualified_hosts? no (option unset)
210 host in recipient_unqualified_hosts? no (option unset)
211 host in helo_verify_hosts? no (option unset)
212 host in helo_try_verify_hosts? no (option unset)
213 host in helo_accept_junk_hosts? no (option unset)
214 SMTP>> 220 myhost.test.ex ESMTP Exim x.yz Tue, 2 Mar 1999 09:44:33 +0000
215 smtp_setup_msg entered
216 SMTP<< mail from:<a@b>
217 spool directory space = nnnnnK inodes = nnnnn check_space = 10240K inodes = 100 msg_size = 0
218 log directory space = nnnnnK inodes = nnnnn check_space = 10240K inodes = 100
219 SMTP>> 250 OK
220 SMTP<< rcpt to:<c@d>
221 using ACL "check_recipient"
222 processing "accept"
223 check domains = +local_domains
224 d in "@"? no (end of list)
225 d in "+local_domains"? no (end of list)
226 accept: condition test failed in ACL "check_recipient"
227 processing "accept"
228 check hosts = +relay_hosts
229 search_open: pgsql "NULL"
230 search_find: file="NULL"
231   key="select * from them where id='10.0.0.0'" partial=-1 affix=NULL starflags=0
232 LRU list:
233 internal_search_find: file="NULL"
234   type=pgsql key="select * from them where id='10.0.0.0'"
235 database lookup required for select * from them where id='10.0.0.0'
236 PostgreSQL query: select * from them where id='10.0.0.0'
237 PGSQL new connection: host=localhost port=1223 database=test user=CALLER
238 PGSQL: no data found
239 lookup failed
240 host in "net-pgsql;select * from them where id='10.0.0.0'"? no (end of list)
241 host in "+relay_hosts"? no (end of list)
242 accept: condition test failed in ACL "check_recipient"
243 processing "deny"
244   message: relay not permitted
245 deny: condition test succeeded in ACL "check_recipient"
246 end of ACL "check_recipient": DENY
247 SMTP>> 550 relay not permitted
248 LOG: MAIN REJECT
249   H=[10.0.0.0] F=<a@b> rejected RCPT <c@d>: relay not permitted
250 SMTP<< rcpt to:<c@d>
251 using ACL "check_recipient"
252 processing "accept"
253 check domains = +local_domains
254 d in "@"? no (end of list)
255 d in "+local_domains"? no (end of list)
256 accept: condition test failed in ACL "check_recipient"
257 processing "accept"
258 check hosts = +relay_hosts
259 search_open: pgsql "NULL"
260   cached open
261 search_find: file="NULL"
262   key="select * from them where id='10.0.0.0'" partial=-1 affix=NULL starflags=0
263 LRU list:
264 internal_search_find: file="NULL"
265   type=pgsql key="select * from them where id='10.0.0.0'"
266 cached data used for lookup of select * from them where id='10.0.0.0'
267 lookup failed
268 host in "net-pgsql;select * from them where id='10.0.0.0'"? no (end of list)
269 host in "+relay_hosts"? no (end of list)
270 accept: condition test failed in ACL "check_recipient"
271 processing "deny"
272   message: relay not permitted
273 deny: condition test succeeded in ACL "check_recipient"
274 end of ACL "check_recipient": DENY
275 SMTP>> 550 relay not permitted
276 LOG: MAIN REJECT
277   H=[10.0.0.0] F=<a@b> rejected RCPT <c@d>: relay not permitted
278 SMTP<< quit
279 SMTP>> 221 myhost.test.ex closing connection
280 LOG: smtp_connection MAIN
281   SMTP connection from [10.0.0.0] closed by QUIT
282 search_tidyup called
283 close PGSQL connection: localhost:1223/test/CALLER
284 >>>>>>>>>>>>>>>> Exim pid=pppp (main) terminating with rc=0 >>>>>>>>>>>>>>>>
285 Exim version x.yz ....
286 changed uid/gid: forcing real = effective
287   uid=uuuu gid=CALLER_GID pid=pppp
288 configuration file is TESTSUITE/test-config
289 admin user
290 changed uid/gid: privilege not needed
291   uid=EXIM_UID gid=EXIM_GID pid=pppp
292 seeking password data for user "CALLER": cache not available
293 getpwnam() succeeded uid=CALLER_UID gid=CALLER_GID
294 originator: uid=CALLER_UID gid=CALLER_GID login=CALLER name=CALLER_NAME
295 sender address = CALLER@myhost.test.ex
296 set_process_info: pppp accepting a local non-SMTP message from <CALLER@myhost.test.ex>
297 spool directory space = nnnnnK inodes = nnnnn check_space = 10240K inodes = 100 msg_size = 0
298 log directory space = nnnnnK inodes = nnnnn check_space = 10240K inodes = 100
299 Sender: CALLER@myhost.test.ex
300 Recipients:
301   CALLER
302 search_tidyup called
303 >>Headers received:
304
305 rewrite_one_header: type=F:
306   From: CALLER_NAME <CALLER@myhost.test.ex>
307 search_tidyup called
308 >>Headers after rewriting and local additions:
309 I Message-Id: <E10HmaX-0005vi-00@myhost.test.ex>
310 F From: CALLER_NAME <CALLER@myhost.test.ex>
311   Date: Tue, 2 Mar 1999 09:44:33 +0000
312
313 Data file name: TESTSUITE/spool//input//10HmaX-0005vi-00-D
314 Data file written for message 10HmaX-0005vi-00
315 >>Generated Received: header line
316 P Received: from CALLER by myhost.test.ex with local (Exim x.yz)
317         (envelope-from <CALLER@myhost.test.ex>)
318         id 10HmaX-0005vi-00
319         for CALLER@myhost.test.ex; Tue, 2 Mar 1999 09:44:33 +0000
320 calling local_scan(); timeout=300
321 local_scan() returned 0 NULL
322 Writing spool header file: TESTSUITE/spool//input//hdr.pppp
323 DSN: Write SPOOL :-dsn_envid NULL
324 DSN: Write SPOOL :-dsn_ret 0
325 DSN: Flags :0
326 DSN: **** SPOOL_OUT - address: |CALLER@myhost.test.ex| errorsto: |NULL| orcpt: |NULL| dsn_flags: 0
327 Renaming spool header file: TESTSUITE/spool//input//10HmaX-0005vi-00-H
328 Size of headers = sss
329 LOG: MAIN
330   <= CALLER@myhost.test.ex U=CALLER P=local S=sss
331 created log directory TESTSUITE/spool/log
332 search_tidyup called
333 exec TESTSUITE/eximdir/exim -DEXIM_PATH=TESTSUITE/eximdir/exim -C TESTSUITE/test-config -d=0xfbb95cfd -odi -Mc 10HmaX-0005vi-00
334 Exim version x.yz ....
335 changed uid/gid: forcing real = effective
336   uid=uuuu gid=EXIM_GID pid=pppp
337 configuration file is TESTSUITE/test-config
338 trusted user
339 admin user
340 seeking password data for user "CALLER": cache not available
341 getpwnam() succeeded uid=CALLER_UID gid=CALLER_GID
342 set_process_info: pppp delivering specified messages
343 set_process_info: pppp delivering 10HmaX-0005vi-00
344 Trying spool file TESTSUITE/spool//input//10HmaX-0005vi-00-D
345 reading spool file 10HmaX-0005vi-00-H
346 user=CALLER uid=CALLER_UID gid=CALLER_GID sender=CALLER@myhost.test.ex
347 sender_local=1 ident=CALLER
348 Non-recipients:
349 Empty Tree
350 ---- End of tree ----
351 recipients_count=1
352 **** SPOOL_IN - No additional fields
353 body_linecount=1 message_linecount=7
354 DSN: set orcpt: NULL  flags: 0
355 Delivery address list:
356   CALLER@myhost.test.ex 
357 locking TESTSUITE/spool/db/retry.lockfile
358 locked  TESTSUITE/spool/db/retry.lockfile
359 EXIM_DBOPEN: file <TESTSUITE/spool/db/retry> dir <TESTSUITE/spool/db> flags=O_RDONLY
360 returned from EXIM_DBOPEN: (nil)
361 ensuring TESTSUITE/spool/db/retry.lockfile is owned by exim
362 failed to open DB file TESTSUITE/spool/db/retry.lockfile: No such file or directory
363 no retry data available
364 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
365 Considering: CALLER@myhost.test.ex
366 unique = CALLER@myhost.test.ex
367 no domain retry record
368 no address retry record
369 CALLER@myhost.test.ex: queued for routing
370 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
371 routing CALLER@myhost.test.ex
372 --------> r1 router <--------
373 local_part=CALLER domain=myhost.test.ex
374 processing address_data
375 search_open: pgsql "NULL"
376 search_find: file="NULL"
377   key="select name from them where id='ph10'" partial=-1 affix=NULL starflags=0
378 LRU list:
379 internal_search_find: file="NULL"
380   type=pgsql key="select name from them where id='ph10'"
381 database lookup required for select name from them where id='ph10'
382 PostgreSQL query: select name from them where id='ph10'
383 PGSQL new connection: host=localhost port=1223 database=test user=CALLER
384 lookup yielded: Philip Hazel
385 calling r1 router
386 r1 router called for CALLER@myhost.test.ex
387   domain = myhost.test.ex
388 set transport t1
389 queued for t1 transport: local_part = CALLER
390 domain = myhost.test.ex
391   errors_to=NULL
392   domain_data=NULL localpart_data=NULL
393 routed by r1 router
394   envelope to: CALLER@myhost.test.ex
395   transport: t1
396 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
397 After routing:
398   Local deliveries:
399     CALLER@myhost.test.ex
400   Remote deliveries:
401   Failed addresses:
402   Deferred addresses:
403 search_tidyup called
404 close PGSQL connection: localhost:1223/test/CALLER
405 >>>>>>>>>>>>>>>> Local deliveries >>>>>>>>>>>>>>>>
406 --------> CALLER@myhost.test.ex <--------
407 locking TESTSUITE/spool/db/retry.lockfile
408 locked  TESTSUITE/spool/db/retry.lockfile
409 EXIM_DBOPEN: file <TESTSUITE/spool/db/retry> dir <TESTSUITE/spool/db> flags=O_RDONLY
410 returned from EXIM_DBOPEN: (nil)
411 failed to open DB file TESTSUITE/spool/db/retry: No such file or directory
412 no retry data available
413 search_tidyup called
414 changed uid/gid: local delivery to CALLER <CALLER@myhost.test.ex> transport=t1
415   uid=CALLER_UID gid=CALLER_GID pid=pppp
416   home=NULL current=/
417 set_process_info: pppp delivering 10HmaX-0005vi-00 to CALLER using t1
418 appendfile transport entered
419 search_open: pgsql "NULL"
420 search_find: file="NULL"
421   key="select id from them where id='ph10'" partial=-1 affix=NULL starflags=0
422 LRU list:
423 internal_search_find: file="NULL"
424   type=pgsql key="select id from them where id='ph10'"
425 database lookup required for select id from them where id='ph10'
426 PostgreSQL query: select id from them where id='ph10'
427 PGSQL new connection: host=localhost port=1223 database=test user=CALLER
428 lookup yielded: ph10
429 appendfile: mode=600 notify_comsat=0 quota=0 warning=0
430   file=TESTSUITE/test-mail/ph10 format=unix
431   message_prefix=From ${if def:return_path{$return_path}{MAILER-DAEMON}} ${tod_bsdinbox}\n
432   message_suffix=\n
433   maildir_use_size_file=no
434   locking by lockfile fcntl 
435 lock name: TESTSUITE/test-mail/ph10.lock
436 hitch name: TESTSUITE/test-mail/ph10.lock.test.ex.dddddddd.pppppppp
437 lock file created
438 mailbox TESTSUITE/test-mail/ph10 is locked
439 writing to file TESTSUITE/test-mail/ph10
440 writing data block fd=dddd size=sss timeout=0
441 cannot use sendfile for body: spoolfile not wireformat
442 writing data block fd=dddd size=sss timeout=0
443 writing data block fd=dddd size=sss timeout=0
444 appendfile yields 0 with errno=dd more_errno=dd
445 search_tidyup called
446 close PGSQL connection: localhost:1223/test/CALLER
447 journalling CALLER@myhost.test.ex
448 t1 transport returned OK for CALLER@myhost.test.ex
449 post-process CALLER@myhost.test.ex (0)
450 CALLER@myhost.test.ex delivered
451 LOG: MAIN
452   => CALLER <CALLER@myhost.test.ex> R=r1 T=t1
453 >>>>>>>>>>>>>>>> deliveries are done >>>>>>>>>>>>>>>>
454 changed uid/gid: post-delivery tidying
455   uid=EXIM_UID gid=EXIM_GID pid=pppp
456 set_process_info: pppp tidying up after delivering 10HmaX-0005vi-00
457 Processing retry items
458 Succeeded addresses:
459  CALLER@myhost.test.ex: no retry items
460 Failed addresses:
461 Deferred addresses:
462 end of retry processing
463 DSN: processing router : r1
464 DSN: processing successful delivery address: CALLER@myhost.test.ex
465 DSN: Sender_address: CALLER@myhost.test.ex
466 DSN: orcpt: NULL  flags: 0
467 DSN: envid: NULL  ret: 0
468 DSN: Final recipient: CALLER@myhost.test.ex
469 DSN: Remote SMTP server supports DSN: 0
470 DSN: not sending DSN success message
471 LOG: MAIN
472   Completed
473 end delivery of 10HmaX-0005vi-00
474 search_tidyup called
475 search_tidyup called
476 >>>>>>>>>>>>>>>> Exim pid=pppp (main) terminating with rc=0 >>>>>>>>>>>>>>>>
477 search_tidyup called
478 >>>>>>>>>>>>>>>> Exim pid=pppp (main) terminating with rc=0 >>>>>>>>>>>>>>>>
479 Exim version x.yz ....
480 configuration file is TESTSUITE/test-config
481 admin user
482 search_open: pgsql "NULL"
483 search_find: file="NULL"
484   key="select name from them where id='ph10';" partial=-1 affix=NULL starflags=0
485 LRU list:
486 internal_search_find: file="NULL"
487   type=pgsql key="select name from them where id='ph10';"
488 database lookup required for select name from them where id='ph10';
489 PostgreSQL query: select name from them where id='ph10';
490 PGSQL new connection: socket=TESTSUITE/pgsql/.s.PGSQL.1223 database=test user=CALLER
491 lookup yielded: Philip Hazel
492 search_tidyup called
493 close PGSQL connection: (TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER
494 >>>>>>>>>>>>>>>> Exim pid=pppp (main: expansion test) terminating with rc=0 >>>>>>>>>>>>>>>>
495
496 ******** SERVER ********
497 LOG:  redirecting log output to logging collector process
498 HINT:  Future log output will appear in directory "pg_log".