| 1 | # pgsql lookups - expects specific data |
| 2 | exim -d-all+lookup -be |
| 3 | ${lookup pgsql {select name from them where id='ph10';}} |
| 4 | ${lookup pgsql {select name from them where id='ph10';}} |
| 5 | ${lookup pgsql {select name from them where id='xxxx';}} |
| 6 | ${lookup pgsql {select name from them where id='nothing';}} |
| 7 | ${lookup pgsql {select id,name from them where id='nothing';}} |
| 8 | ${lookup pgsql {delete from them where id='nonexist';}} |
| 9 | ${lookup pgsql {select * from them where id='quote2';}} |
| 10 | ${lookup pgsql {select * from them where id='newline';}} |
| 11 | ${lookup pgsql {select * from them where id='tab';}} |
| 12 | ${lookup pgsql {select * from them where name='${quote_pgsql:'stquot}';}} |
| 13 | ${lookup pgsql {servers=x:localhost; select name from them where id='ph10';}} |
| 14 | ${lookup pgsql {servers=localhost:x; select name from them where id='ph10';}} |
| 15 | ${lookup pgsql {servers=localhost/test/CALLER/:x; select name from them where id='ph10';}} |
| 16 | ${lookup pgsql {servers=(/tmp/.s.PGSQL.5432)/test/ph10/:x; select name from them where id='ph10';}} |
| 17 | **** |
| 18 | exim -d -bh 10.0.0.0 |
| 19 | mail from:<a@b> |
| 20 | rcpt to:<c@d> |
| 21 | rcpt to:<c@d> |
| 22 | quit |
| 23 | **** |
| 24 | exim -odi -d CALLER |
| 25 | Test message |
| 26 | . |
| 27 | **** |
| 28 | exim -DSERVERS=\(/tmp/.s.PGSQL.5432\)/test/ph10/ -d-all+lookup -be |
| 29 | ${lookup pgsql {select name from them where id='CALLER';}} |
| 30 | **** |