On Thu, 2011-01-20 at 13:33 -0800, Matthew Hall wrote:
On Thu, Jan 20, 2011 at 12:26:10PM -0700, Patrick H. wrote:
The big problem with this solution is that if the table check failed, then inserting it will also fail. The only case this would solve is if the user doesnt have select perms, but does have insert perms.
-Patrick
Indeed it could be a problem but so is leaving it enabled in many cases. Personally I find the auto-creation mostly useless and try to avoid it.
Because it won't take care of cases like special auto-incrementing ID columns, storage engine, tablespace, and other special stuff.
auto-incrementing IDs should certainly be possible, although storage engine and tablespace ain't. can you paste a complete CREATE TABLE command that should be possible with automatic creation? I'm not that much into various SQL implementations to see where things should go. Thanks.
So I would generally recommend making a proper table, and backing up its schema, and storing this with a backup of the syslog-ng configuration.
-- Bazsi