Re: [Firebird-devel] Adding sysdb - no permission for INSERT access to TABLE PLG$VIEW_USERS

On 06/05/2015 03:38 PM, liviusliv...@poczta.onet.pl wrote: >>>You must provide user name for gsec: >>> gsec -user SYSDBA -add SYSDBA -pw masterkey -admin yes >>> Regards, >>> Vlad > > Hi, > > 1. > this is strange that i must specify sysdba to add sysdba Yes, strange at the first look but you s

[Firebird-devel] [FB-Tracker] Created: (CORE-4836) Grant update(c) on t to U01 with grant option: user U01 will not be able to "revoke update(c) on t from " if this 'U01' do some DML befo

Grant update(c) on t to U01 with grant option: user U01 will not be able to "revoke update(c) on t from " if this 'U01' do some DML before revoke -

[Firebird-devel] firebird 2.5.4 on osx 64 configure host

One issue is that bash firebird configure script detects host/target as i386-darwin on x86-64 osx so I had to use the 2.5.2 trick from libreoffice and force the build for darwin_x86_64 i*86-*-darwin*) MAKEFILE_PREFIX=darwin_x86_64 issue was libreoffice detects host to be darwin x86_64 and f

[Firebird-devel] firebird 2.5.4 on osx 64 configure host

> This was fixed in B2_5_Release sometime ago. Configure detects both 64bit and 32bit using x*64-*-darwin* | x*64_*-darwin*) MAKEFILE_PRIFIX=darwin_x86_64 and i*86-*-darwin* | i*86_*-darwin*) MAKEFILE_

[Firebird-devel] [FB-Tracker] Created: (CORE-4837) Unable to make embedded connection to 'security.db' if before that CREATE DATABASE or CONNECT was made using remote protocol

Unable to make embedded connection to 'security.db' if before that CREATE DATABASE or CONNECT was made using remote protocol Key: CORE-4837

[Firebird-devel] Regular Expression Library

Hi! When I created SIMILAR TO predicate, I research for libraries to do the real work and found no good alternative. PgSQL were using (AFAIR) Henry Spencer library, but its (PgSQL) SIMILAR TO were definitively non SQL standard. We needed a library to work with 1, 2 or 4 byte-length characters, a

Re: [Firebird-devel] Problem with MERGE

> -Original Message- > From: Dmitry Yemanov [mailto:firebi...@yandex.ru] > Sent: Martes, 09 de Junio de 2015 6:19 > > 09.06.2015 13:11, Dimitry Sibiryakov wrote: > > > > ISQL would better always report "Rows affected" as a sum of > all three components of > > info response: inserts+upda

Re: [Firebird-devel] Problem with MERGE

10.06.2015 22:28, Claudio Valderrama C. wrote: > With the old logic, the result is one. With the new logic, the result is two > becaise we get the direct and indirect effects. Is it really the case? I never saw trigger's actions to be shown in result of isc_info_sql_records. Was I just lucky?

Re: [Firebird-devel] Problem with MERGE

10.06.2015 23:28, Claudio Valderrama C. wrote: > > I would like to be able to know that I'm dealing with MERGE or any other > statement that can lead to an update and/or insert. Adding > inserts+updates+deletes is not a problem (indeed, it's simpler code), but > it's a departure of the traditional

Re: [Firebird-devel] Problem with MERGE

> -Original Message- > From: Dmitry Yemanov [mailto:firebi...@yandex.ru] > Sent: Miércoles, 10 de Junio de 2015 15:40 > > > > With the old logic, the result is one. With the new logic, > the result is two > > becaise we get the direct and indirect effects. > > I doubt the new logic would