Re: [firebird-support] Text search ...

2019-03-12 Thread Andrew Lowe a...@wht.com.au [firebird-support]
On 13/03/19 06:44, Lester Caine les...@lsces.co.uk [firebird-support] wrote: > I've got a few of sites where I've got a growing number of pdf files > which it would be nice to actually index the content. First problem is > obviously the different qualities of pdf, and I've had finereader >

[firebird-support] Text search ...

2019-03-12 Thread Lester Caine les...@lsces.co.uk [firebird-support]
I've got a few of sites where I've got a growing number of pdf files which it would be nice to actually index the content. First problem is obviously the different qualities of pdf, and I've had finereader deployed in some cases to provide OCRed copies of the original, with the usual variable

Re: [firebird-support] Firebird vs. PostgreSQL

2019-03-12 Thread Michal Kurczabinski michk...@gmail.com [firebird-support]
2019-03-12 16:56 GMT+01:00, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] > > FILTER has been implemented in Firebird 4. See "FILTER Clause for > Aggregate Functions" in the Firebird 4 beta 1 release notes, or > http://tracker.firebirdsql.org/browse/CORE-5768 Great! > Note though that

Re: [firebird-support] Firebird vs. PostgreSQL

2019-03-12 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-03-12 13:13, Michal Kurczabinski michk...@gmail.com [firebird-support] wrote: > I forgot about very useful feature lile FILTER on window functions > select some_col, count(other_col) over() FILTER ( where other_col > > soime_val) Maybe in FB 4.0 it might be implemented FILTER has been

Re: [firebird-support] keeping the connection

2019-03-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.03.2019 16:45, wang...@yahoo.com [firebird-support] wrote: > any idea why it got disconnected CISCO router in-between dropped idle TCP connection after configured timeout. -- WBR, SD.

[firebird-support] keeping the connection

2019-03-12 Thread wang...@yahoo.com [firebird-support]
Hi, installing a linux firebird 1.5 classic in a new pc, notice that the client in windows 7, it got disconnected after a while, but check server: 00:00:00 /opt/firebird/bin/fb_lock_mgr firebird 477 389 0 10:45 ?00:00:00 fb_inet_server firebird 478 389 0 10:47 ?

Re: AW: Re[2]: [firebird-support] Link system tables to trigger

2019-03-12 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Hi,you can do this by:Select * from mon$attachments a where a.mon$attachment_id=CURRENT_CONNECTIONRegards,Karol Bieniaszewski null

Re: [firebird-support] Firebird vs. PostgreSQL

2019-03-12 Thread Michal Kurczabinski michk...@gmail.com [firebird-support]
I forgot about very useful feature lile FILTER on window functions select some_col, count(other_col) over() FILTER ( where other_col > soime_val) Maybe in FB 4.0 it might be implemented 2018-11-10 9:47 GMT+01:00, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] : > On 9-11-2018 22:51,

AW: Re[2]: [firebird-support] Link system tables to trigger

2019-03-12 Thread 'Check_Mail' check_m...@satron.de [firebird-support]
Hello, I thought similar, would call a stored procedure in my application and set the current user. But there was a little bit hope, that I can get it by using monitor tables, the attachment-table includes all informations and perhaps there is a reference to the statements or

Re[2]: [firebird-support] Link system tables to trigger

2019-03-12 Thread 'Marcin Bury' marcin.b...@studio-delfi.pl [firebird-support]
Olaf If you use same firebird user for all application users, I assume that you have some list of users within your database. Then you can set a variable for connection named i.e. my_current_user, fill it from the application and then use it in i.e triggers in the same manner that you would

Re: [firebird-support] Link system tables to trigger

2019-03-12 Thread Svein Erling Tysvær setys...@gmail.com [firebird-support]
O, I see, Olaf, you want to get the Windows user (or similar) and not the Firebird user (since all use the same Firebird user through ODBC). I have no clue whether that is possible to do in a trigger or not, but there's hopefully someone else on this list that knows the answer. Sorry, Set Den

AW: [firebird-support] Link system tables to trigger

2019-03-12 Thread 'Check_Mail' check_m...@satron.de [firebird-support]
Hello Set, all users connecting over odbc with the same user, so I cannot separate the user, which changed the record. It is possible to get it over the transactions-table? Von: firebird-support@yahoogroups.com Gesendet: Dienstag, 12. März 2019 09:52 An:

Re: [firebird-support] Link system tables to trigger

2019-03-12 Thread Svein Erling Tysvær setys...@gmail.com [firebird-support]
Isn't current_user ( https://firebirdsql.org/refdocs/langrefupd21-current_user.html) sufficient? Den tir. 12. mar. 2019 kl. 09:20 skrev 'Check_Mail' check_m...@satron.de [firebird-support] : > > > Hello, > > I would like to log some changes in tables, in germany we must save this > for dsgvo

[firebird-support] Link system tables to trigger

2019-03-12 Thread 'Check_Mail' check_m...@satron.de [firebird-support]
Hello, I would like to log some changes in tables, in germany we must save this for dsgvo (customer data). Now, I can do this with trigger, but can I link this changing with the system tables, that I could get the user? The mon$attachment shows me all active attachments with the user and the