Re: Select with trigger

[Peter Brawley]

> I want create an after insert trigger which creates a table with at least 4 columns
> but only three are permanent column names, they don't change.

If you try to create a table in a Trigger, you'll get the error message "Explicit or implicit commit is not allowed in stored function or trigger."

There'd be something very fishy indeed about a database design that depends on Triggers defining tables.

> Do I create the table with the known columns names first,
> then do an alter for each value in the query result
> or is there a way of adding the new columns in the same alter query?

Why do you think there a need to add table columns?

Databases aren't like take-out orders. Except for temp utility tables, table structure should be the opposite of ad hoc, it should go through an exacting process of verified reconciliation with the database requirement.