im going to act dumb, is it a bad idea to change struture etc with active connections then?

also

"it seems likely
that you are modifying the table structure with active connections. Those
active connections are not aware of the table change..."

Any ideas of a way to get them to pick up the changes without a Db engine restart

--- In firebird-support@yahoogroups.com, "Leyne, Sean" <Sean@...> wrote:
>
> Andrew,
>
> > Firebird v2.1.3 classic on Linux
> >
> > We have a table with a column on it, which when we run a simple sql to insert
> > a new row with data in that column it doesnt populate the column (simple
> > varchar(50) )
>
> Was the column added recently?
>
> Are you opening a new database connection when running the insert SQL?
>
> Are you sure that the insert is actually doing anything? Are you seeing the new row?
>
>
> > if i do a backup/restore to a new database it works again and i can update the
> > column, but as we are a 24/7 company id rather not take the DB down if
> > possible.
>
> Given that you are running 7x24 and the problem doesn't appear after a backup/restore (which is also effectively an engine restart), it seems likely that you are modifying the table structure with active connections. Those active connections are not aware of the table change...
>
>
> Sean
>