Hi Alex, > Hmmm, 1 works fine in the MySQL case. But I guess if the DB wants > boolean (which is probably the SQL-correct case), we should rather > try something along the lines of 1=1. This works fine with MySQL, > could you please confirm that it works with PostgreSQL?
The following commands work fine in PostgreSQL: delete from secret where '1'; delete from secret where 'true'; delete from secret where 1=1; Does not work the command: delete * from secret where 1; > One more thing I noticed is that I am unsure whether the secret should > be deleted in the case of an openxpkiadm command - do we want users > to only run those while the server is not running, or has the code I > checked in an unwanted impact on a running server (namely deleting a possibly > still valid secret)? As for me, I prefer to stop the server before performing any administration with openxpkiadm. Best regards, Julia. ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ OpenXPKI-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openxpki-devel
