RE: [firebird-support] Re: Merge results of recursive CTE with results of non-recursive CTE

2011-09-01 Thread Svein Erling Tysvær
Does With Recursive lc as ( Select ID from BD_Locality where ID = :ID_Root Union all Select ID from BD_Locality, lc where Parent_ID = lc.id ), RPL (BizType_Description, Loc_Description) as ( select BizType_Description, Loc_Description from v_bd_biz_prim where BizType_ID = :BizType_ID and

Re: [firebird-support] Re: wierd gbak behavour

2011-09-01 Thread Nick Upson
On 31 August 2011 18:06, Milan Babuskov mil...@panonnet.net wrote: ** Nick Upson wrote: the commandline used is gbak -V -CREATE 110831130601.fbk -user sysdba -pass genesis /opt/unb/archive/tmp/110831130601.fdb User/pass have no effect unless you give localhost: in front of

Re: [firebird-support] Re: wierd gbak behavour

2011-09-01 Thread Nick Upson
looking at the logs for other processes, all of the last four occurrances happened at the same time as an isql session was run against the original database. I can't think why there is any need for this isql session and the gbak session creating the new database to interact via the lock manager

Re: [firebird-support] Re: wierd gbak behavour

2011-09-01 Thread Milan Babuskov
Nick Upson wrote: looking at the logs for other processes, all of the last four occurrances happened at the same time as an isql session was run against the original database. I can't think why there is any need for this isql session and the gbak session creating the new database to interact

Re: [firebird-support] Re: wierd gbak behavour

2011-09-01 Thread Nick Upson
On 1 September 2011 14:19, Milan Babuskov mil...@panonnet.net wrote: ** Nick Upson wrote: looking at the logs for other processes, all of the last four occurrances happened at the same time as an isql session was run against the original database. I can't think why there is any need

[firebird-support] Restoring database from backup on Firebird 2.1 Classic Linux

2011-09-01 Thread Roland Turcan
Hello firebird-support@yahoogroups.com! This is the end of restore: ... gbak:activating and creating deferred index FK_ADRESAR_ZAMESTNAVATEL gbak:activating and creating deferred index FK_SABLONY_MIESTO gbak:committing metadata gbak:finishing, closing, and going home gbak:

[firebird-support] mac os x: aliases.conf

2011-09-01 Thread Matthias Zitzen
Hello, short question: Where do I find the aliases.conf file under mac os x(Firebird 2.0.5)? spotlight can't find the file and searching in the typical folders wasn't successful. Thanks in advance! Matthias

Re: [firebird-support] mac os x: aliases.conf

2011-09-01 Thread Point Informática - Dep. de Desenvolvimento
I just have problem to install in my Mac, can you send info about how can I do this? Best Regards Fellipe H. Em 01/09/11 13:19, Matthias Zitzen escreveu: Hello, short question: Where do I find the aliases.conf file under mac os x(Firebird 2.0.5)? spotlight can't find the file and searching

Re: [firebird-support] Restoring database from backup on Firebird 2.1 Classic Linux

2011-09-01 Thread Roland Turcan
Hello all, I have tried to restore the database on Ubuntu 11.04 64bit with FB 2.1 Classic and it was restored fine. What the hell happens with 32 bit? TRoland; 01.09.2011 18:00:00 - Roland Turcan k...@rotursoft.sk Hello firebird-support@yahoogroups.com! This is the end of restore: ...