Hanne Moa, > Oh, and here's an update for README.sql.txt: > > When using postgres instead of mysql and you are sufficiently > paranoid, don't just remove "UNSIGNED" throughout the table > definitions but add "CHECK (<name_of_col> >= 0)" to the end of al the > unsigned types, to assure that no negative numbers can be stored in 'em. > So: id int UNSIGNED NOT NULL -> id int NOT NULL CHECK (id >= 0)
Thanks. I have just split the README.sql documentation file into three, as the number of differences in details between MySQL and the rest made the monolythic approach difficult to read: README.sql general SQL considerations and some examples README.sql-mysql MySQL-specific notes and schema README.sql-pg PostgreSQL-specific notes and schema (also SQLite) (also on the web page). The README.sql-pg now includes your suggestion about added CHECK. Further SQL-related documentation updates are welcome. Mark ------------------------------------------------------------------------- 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 _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
