Re: [Firebird-devel] no database triggers switch for qli

2012-01-19 Thread Claudio Valderrama C.
> -Original Message- > From: Frank Schlottmann-Gödde [mailto:fr...@schlottmann-goedde.de] > Sent: Viernes, 09 de Diciembre de 2011 12:47 > > I would like to see a switch added to qli to stop it from running > database triggers. > > The following patch seems to do the trick: Ok, but I ha

[Firebird-devel] TempCacheLimit

2012-01-19 Thread Thomas Steinmaurer
Hello, the comment on TempCacheLimit in firebird.conf states that the default value is 8MB for each connection. The default value for SS isn't mentioned although I guess it is 64MB as used in the example for TempCacheLimit? Is the default value for SS per database or per server instance? Tha

Re: [Firebird-devel] Granting access to DDL operator CREATE DATABASE

2012-01-19 Thread Alex Peshkoff
On 01/18/12 16:29, Dimitry Sibiryakov wrote: > 18.01.2012 13:18, Alex Peshkoff wrote: >> But I do not like an idea of making SQL >> command (GRANT CREATE DATABASE TO SomeUser) dependent upon >> authentication plugins behavior. >But you don't mind SQL command CREATE USER to be dependent on plug

Re: [Firebird-devel] TempCacheLimit

2012-01-19 Thread Dmitry Yemanov
19.01.2012 12:42, Thomas Steinmaurer wrote: > > the comment on TempCacheLimit in firebird.conf states that the default > value is 8MB for each connection. The default value for SS isn't > mentioned although I guess it is 64MB as used in the example for > TempCacheLimit? Is the default value for SS

Re: [Firebird-devel] Wrong rdb$field_sub_type for numeric computed column

2012-01-19 Thread Mark Rotteveel
On Wed, 18 Jan 2012 23:08:36 +0100, "Ivan Prenosil" wrote: >> I have a table: >> recreate table test ( >> base numeric(15,4), >> test1 computed by (base+base), >> test2 computed by (cast(base+base as numeric(15,4))), >> foo bigint, >> bar numeric(15,4) >> ); >> >> If I run the query: >> sele

Re: [Firebird-devel] TempCacheLimit

2012-01-19 Thread Thomas Steinmaurer
>> the comment on TempCacheLimit in firebird.conf states that the default >> value is 8MB for each connection. The default value for SS isn't >> mentioned although I guess it is 64MB as used in the example for >> TempCacheLimit? Is the default value for SS per database or per server >> instance? >

Re: [Firebird-devel] no database triggers switch for qli

2012-01-19 Thread Frank Schlottmann-Gödde
On 19.01.2012 09:14, Claudio Valderrama C. wrote: >> -Original Message- >> From: Frank Schlottmann-Gödde [mailto:fr...@schlottmann-goedde.de] >> Sent: Viernes, 09 de Diciembre de 2011 12:47 >> >> I would like to see a switch added to qli to stop it from running >> database triggers. >> >>