[firebird-support] Is it possible to suspend a generator?

2012-03-13 Thread grip_2ls
Hi I need to insert some data with fixed IDs. The table that I am inserting into already has data and a generator for the IDs. The new data is below the value of the generator and the IDs do not already exist. Can I suspend the generator while I insert these new rows and if so how? Thanks Nei

Re: [firebird-support] Is it possible to suspend a generator?

2012-03-13 Thread Martijn Tonies
Hello Neil, > I need to insert some data with fixed IDs. The table that I am inserting > into already has data and a generator for the IDs. The new data is below > the value of the generator and the IDs do not already exist. Can I suspend > the generator while I insert these new rows and if so

Re: [firebird-support] Is it possible to suspend a generator?

2012-03-13 Thread Doug Chamberlin
On 3/13/12 8:17 AM, grip_2ls wrote: > I need to insert some data with fixed IDs. The table that I am inserting into > already has data and a generator for the IDs. The new data is below the value > of the generator and the IDs do not already exist. Can I suspend the > generator while I insert th

[firebird-support] Re: Is it possible to suspend a generator?

2012-03-13 Thread grip_2ls
Hi Thank you both - you are correct that it is a trigger, so I can just make that inactive. Thanks Neil --- In firebird-support@yahoogroups.com, Doug Chamberlin wrote: > > On 3/13/12 8:17 AM, grip_2ls wrote: > > I need to insert some data with fixed IDs. The table that I am inserting > > in

Re: [firebird-support] Re: Is it possible to suspend a generator?

2012-03-13 Thread Kjell Rilbe
Den 2012-03-13 13:32 skrev grip_2ls såhär: > > Thank you both - you are correct that it is a trigger, so I can just > make that inactive. > If you are doing this while the application is running, make sure the application doesn't run havoc because of what you're doing with the trigger. If you p

[firebird-support] Database restore error

2012-03-13 Thread Rick Debay
We test restoring all our backups. Last night, this happened. We compared the DDL of our production system with a week of backups, and didn't find any changes in column definitions. We are starting another restore with verbose logging. Any ideas as to what could have happened or what we should

RE: [firebird-support] Precision in stored procedures

2012-03-13 Thread Rick Debay
> Does this help? Yes it does. I will sleep better now :) -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas Steinmaurer Sent: Wednesday, March 07, 2012 3:45 PM To: firebird-support@yahoogroups.com Subject: Re: [firebir

Re: [firebird-support] Database restore error

2012-03-13 Thread Dmitry Kuzmenko
Hello, Rick! Tuesday, March 13, 2012, 8:10:22 PM, you wrote: RD> We test restoring all our backups. Last night, this happened. We RD> compared the DDL of our production system with a week of backups, and RD> didn't find any changes in column definitions. We are starting another RD> restore wit

RE: [firebird-support] Database restore error

2012-03-13 Thread Rick Debay
> you forgot -v option. Without it you can't see where error happened What I posted was what we were greeted with in the logs this morning. The backup/restore that should complete around 3:30 PM EDT contains the verbose flag. -Original Message- From: firebird-support@yahoogroups.com [mail

Re[2]: [firebird-support] Database restore error

2012-03-13 Thread Dmitry Kuzmenko
Hello, Rick! Tuesday, March 13, 2012, 9:08:04 PM, you wrote: >> you forgot -v option. Without it you can't see where error happened RD> What I posted was what we were greeted with in the logs this morning. RD> The backup/restore that should complete around 3:30 PM EDT contains the RD> verbose fl