AFAICT you can't do this. The code doesn't seem to support it, unless I'm mistaken - the postauth handler uses the acct_redundant() function in rlm_sql.c but that function seems to return if a query succeeded and touched >0 rows, unless RLM_SQL_ALT_QUERY (constraint violation) is returned.
Thanks for the clarification, Phil. :-)
FWIW we use SQL triggers for stuff like this, but I'm moving away from using the SQL stuff entirely for acct/postauth - we've bumped up against the limits of unlang and compiled-in module logic (and I'm abandoning C as a lost cause ;o)
Interesting. This thing is just a small... how do I put it... 'backup' for those who don't want to rely on automatic generation. This is just version 0.1. ;-) Stefan Paetow Moonshot Industry & Research Liaison Coordinator t: +44 (0)1235 822 125 gpg: 0x3FCE5142 xmpp: stefanp@jabber.dev.ja.net skype: stefan.paetow.janet jisc.ac.uk Jisc is a registered charity (number 1149740) and a company limited by guarantee which is registered in England under Company No. 5747339, VAT No. GB 197 0632 86. Jisc’s registered office is: One Castlepark, Tower Hill, Bristol, BS2 0JA. T 0203 697 5800.