RE: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2

2016-03-11 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
> Hello, > > since 3 days during production the modified date does not chenge, is there a > reason why? Its the right database. This is a Windows issue, it does not update file properties until a file is closed. Since, you haven't closed the database file... Sean

Re: [firebird-support] Re: FB3 and not null

2016-03-11 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
    W dniu 2016-03-11 14:32:14 użytkownik Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] napisał:   11.03.2016 13:39, liviuslivius wrote: > > I see that in FB3 this was changed and before apply not null to column - > all existed data are

[firebird-support] Re: FB3 and not null

2016-03-11 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
11.03.2016 13:39, liviuslivius wrote: > > I see that in FB3 this was changed and before apply not null to column - > all existed data are validated. Correct. > Is three some possibility to disable this behavior? Nope. > On my big table with 910 468 710 records this operation take 72 minutes. >

Re: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2

2016-03-11 Thread Lester Caine les...@lsces.co.uk [firebird-support]
On 11/03/16 13:06, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > As quoted in the documentation in my previous mail, Windows only guarantees > updates of the timestamps when the handle is closed. Which has been the case in windows for 20 years. It is only M$ who could 'fix'

Re: AW: Re: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2

2016-03-11 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2016-03-11 13:40, 'Checkmail' check_m...@satron.de [firebird-support] wrote: > Hi, > > my third ticked within three days. What should I do, windows ticket? > E-Mail an microsoft? ;) It is expected behavior. See

Re: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2

2016-03-11 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
11.03.2016 13:40, 'Checkmail' check_m...@satron.de [firebird-support] wrote: > What should I do, windows ticket? E-Mail an microsoft? ;) Yep. That was their decision to save your HDD by not writing modification time until the file is closed. -- WBR, SD.

AW: Re: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2

2016-03-11 Thread 'Checkmail' check_m...@satron.de [firebird-support]
Hi, my third ticked within three days. What should I do, windows ticket? E-Mail an microsoft? ;) Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Freitag, 11. März 2016 13:26 An: firebird-support@yahoogroups.com Betreff: Re: Re: [firebird-support]

Re: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2

2016-03-11 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
11.03.2016 12:59, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > i can confirm this - database modified datatime is frozen when first > connection has started. > i suppose that you should raport ticket into the firebird tracker. This ticket rather belongs to Windows

Re: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2

2016-03-11 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Hello,   since 3 days during production the modified date does not chenge, is there a reason why? Its the right database.   Thanks.     Hi,   i can confirm this - database modified datatime is frozen when first connection has started. i suppose that you should raport ticket into the firebird

[firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2

2016-03-11 Thread 'Checkmail' check_m...@satron.de [firebird-support]
Hello, since 3 days during production the modified date does not chenge, is there a reason why? Its the right database. Thanks.

[firebird-support] FB3 and not null

2016-03-11 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Hi,   in earlier versions of Firebird - when i try to change column nullable to not null this go very very fast but without check of all records contain value in such field. I see that in FB3 this was changed and before apply not null to column - all existed data are validated.   Is three some