| 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 | **** |
| 14 | exim -d -bh 10.0.0.0 |
| 15 | mail from:<a@b> |
| 16 | rcpt to:<c@d> |
| 17 | rcpt to:<c@d> |
| 18 | quit |
| 19 | **** |
| 20 | exim -odi -d CALLER |
| 21 | Test message |
| 22 | . |
| 23 | **** |
| 24 | exim -DSERVERS=\(/tmp/.s.PGSQL.5432\)/test/ph10/ -d-all+lookup -be |
| 25 | ${lookup pgsql {select name from them where id='CALLER';}} |
| 26 | **** |