On 2022-05-07 15:02:09 +0200, Durumdara wrote: > We stored the username in a temporary table which was created by the client > app. > With this technique we can log these names in triggers too. > > Now we extend it with user id and later the comp name. > > Because we can update the client applications slowly, some client's tables have > these one or two extra fields, some not. > > So in the new trigger we can't load them all with: How do you get a new trigger on one table but not the new columns on the other table? Wouldn't you update both at the same time? hp -- _ | Peter J. Holzer | Story must make more sense than reality. |_|_) | | | | | hjp@xxxxxx | -- Charles Stross, "Creative writing __/ | http://www.hjp.at/ | challenge!"
Attachment:
signature.asc
Description: PGP signature