rasqlinsert and SQL TRIGGERS

Carter Bullard carter at qosient.com
Thu Jun 27 17:39:21 EDT 2013


I've been working on rasqlinsert() to fix some problems, and have some fixes ready after this weekend.
If there are some post table creation  mysql statements you want to make, for each table,
we can just attach a file that has the statements in them, and I'll run them with each new table.
Or something like that could work?

Carter


On Jun 27, 2013, at 5:30 PM, Matt Brown <matthewbrown at gmail.com> wrote:

> Hello,
> 
> I'm interested in attaching TRIGGERs to the table(s) created by rasqlinsert.
> 
> I've spent some time hunting down various solutions to the problem of
> creating TRIGGERs upon table creation, including reading that you
> can't attach TRIGGERs to tables in the information_schema schema.
> 
> Carter/Dave/etc: Do you all have any idea on how something like this
> can be handled?  I began researching something along the lines of
> `CREATE TABLE n LIKE x`, but it doesn't appear that `LIKE` carries
> TRIGGERs from the template table.
> 
> 
> Any assistance is appreciated.
> 
> 
> Thanks,
> 
> Matt
> 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 6837 bytes
Desc: not available
URL: <https://pairlist1.pair.net/pipermail/argus/attachments/20130627/897fe497/attachment.bin>


More information about the argus mailing list