Re: [firebird-support] Firebird on mac

Hm...it's probably not a good idea to put your database into the "system" folder (/Library/...) Have you tried working in your own user directory ~? > Am 24.03.2015 um 21:51 schrieb Felipe Mathais : > > WW. OH MY GODNESS!!! > > GSEC is run now! > But, I creates a diretory “dados” using s

Re: [firebird-support] Firebird on mac

Hi Felipe, I had the same issue with my first installation of firebird on Mac. Looks to me that you haven't added your user to the firebird user group; firebird seems to be quite strict in terms of security / access rights for its respective files. How to add your user depends on your OS X vers

Re: [firebird-support] Re: Awaiting Garbage Collector

Hello Alexey Your presentation is an excellent work, as ever. I had wrote an article in my blog about it: https://firebird21.wordpress.com/2015/03/23/presentacion-sobre-transacciones-de-alexey-kovyazin/ You had explained very well everything and all can be easily understood. Thank you very much

[firebird-support] Reminder: Scheduled maintenance for tracker.firebirdsql.org and web.firebirdsql.org servers -- Monday April 6, 2015 @ 9a (GMT - 4)

All, Changes are required to the hosts for these systems, which necessitates the outage. The outage is scheduled to last 4 hours. Sean

[firebird-support] Re: How do I get my database back?

24.03.2015 18:42, Tim Ward wrote: > [#] Yes, well, there's then the question about how come you're allowed > to get a database into such an illegal state in the first place, isn't > there. I'd say this is what should be asked first. And it's no longer possible starting with FB3.0. Dmitry

[firebird-support] Re: How do I get my database back?

24.03.2015 19:58, Ann Harrison wrote: > > The theory is that the constraints are all there, just inactive. There's no (and never was) ability to deactivate/activate constraints. It's possible only for indices backing those constraints. But obviously, it does not apply to NOT NULL constraints.

[firebird-support] Firebird on mac

I installed firebird 2.5 on mac, and I can’t use commands gbak, gsec, or connect using isql. I have exported variable PATH. But to use gsec -user sysdba -password masterkey for exemple, I get this message: “cannot attach to password database unable to open database” What should I do? I don’t

Re: [firebird-support] How do I get my database back?

On Tue, Mar 24, 2015 at 11:42 AM, Tim Ward t...@telensa.com [firebird-support] wrote: > gbak: ERROR:validation error for column BOXNUMBER, value "*** null ***" > gbak: ERROR: warning -- record could not be restored > gbak:Exiting before completion due to errors > I'm glad you got most of your da

[firebird-support] How do I get my database back?

gbak: ERROR:validation error for column BOXNUMBER, value "*** null ***" gbak: ERROR: warning -- record could not be restored gbak:Exiting before completion due to errors So, at some point prior to the backup someone had added this NOT NULL column, and hadn't gone round setting the values in the c

Re: Re: [firebird-support] Extract week of the year (within year)

Thanks all,   i forgot about another locales like Sunday first day. I see that supporting official function in FB will be problematic   then i do this in this way SELECT   EXTRACT(YEAR FROM FLD_DATE), CASE      WHEN EXTRACT(yearday FROM FLD_DATE)<100 AND EXTRACT(WEEK FROM FLD_DATE)>50 THEN 0     

Re: [firebird-support] Extract week of the year (within year)

=?utf-8?B?U3ZlaW4gRXJsaW5nIFR5c3bDpnI=?= svein.erling.tysv...@kreftregisteret.no [firebird-support] skrev: > > >is possible to get week of the year "within year"? > > >I see that built in functions only support ISO-8601 (or i do not know > some parameter) > > Actually, Karol, “week within year” i

RE: [firebird-support] Extract week of the year (within year)

On Tue, 24 Mar 2015 09:23:54 +0100, "Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]" wrote: > Actually, Karol, “week within year” is not the week, Karol. 1 January > could be week 53 and 31 December could be week 1. If you want to consider 1 > January always as part

RE: [firebird-support] Extract week of the year (within year)

>is possible to get week of the year "within year"? >I see that built in functions only support ISO-8601 (or i do not know some >parameter) Actually, Karol, “week within year” is not the week, Karol. 1 January could be week 53 and 31 December could be week 1. If you want to consider 1 January a

[firebird-support] Extract week of the year (within year)

Hi,   is possible to get week of the year "within year"? I see that built in functions only support ISO-8601 (or i do not know some parameter)   SELECT '2014-12-31', EXTRACT(WEEK FROM CAST('2014-12-31' AS DATE)) FROM RDB$DATABASE result is "1" but i need weeks in year -in example "53"   you know