summaryrefslogtreecommitdiff
path: root/test/scripts/9200-PostgreSQL
diff options
context:
space:
mode:
authorPhilip Hazel <ph10@hermes.cam.ac.uk>2006-02-07 10:54:33 +0000
committerPhilip Hazel <ph10@hermes.cam.ac.uk>2006-02-07 10:54:33 +0000
commit59371ea735c941334861aa5b8e1e9a06facf044f (patch)
tree79168561a70a94a3994fbe362b904ff9aab86136 /test/scripts/9200-PostgreSQL
parent54c5ebb14ead7439af300e9d7d9d7d2ba29ff32e (diff)
Hopefully the final lot of test files.
Diffstat (limited to 'test/scripts/9200-PostgreSQL')
-rw-r--r--test/scripts/9200-PostgreSQL/920025
1 files changed, 25 insertions, 0 deletions
diff --git a/test/scripts/9200-PostgreSQL/9200 b/test/scripts/9200-PostgreSQL/9200
new file mode 100644
index 000000000..2fd81f5e4
--- /dev/null
+++ b/test/scripts/9200-PostgreSQL/9200
@@ -0,0 +1,25 @@
+# pgsql lookups - expects specific data
+exim -d-all+lookup -be
+${lookup pgsql {select name from them where id='ph10';}}
+${lookup pgsql {select name from them where id='ph10';}}
+${lookup pgsql {select name from them where id='xxxx';}}
+${lookup pgsql {select name from them where id='nothing';}}
+${lookup pgsql {select id,name from them where id='nothing';}}
+${lookup pgsql {delete from them where id='nonexist';}}
+${lookup pgsql {select * from them where id='quote2';}}
+${lookup pgsql {select * from them where id='newline';}}
+${lookup pgsql {select * from them where id='tab';}}
+****
+exim -d -bh 10.0.0.0
+mail from:<a@b>
+rcpt to:<c@d>
+rcpt to:<c@d>
+quit
+****
+exim -odi -d CALLER
+Test message
+.
+****
+exim -DSERVERS=\(/tmp/.s.PGSQL.5432\)/test/ph10/ -d-all+lookup -be
+${lookup pgsql {select name from them where id='CALLER';}}
+****