Re: [Firebird-devel] icu again

2013-01-28 Thread Alex Peshkoff
On 01/28/13 23:06, Philippe Makowski wrote: > For your information : > > https://bugzilla.redhat.com/show_bug.cgi?id=905069 > Taking into an account that they plan to "go back to what it was in F18 (drop --disable-renaming)" ( https://bugzilla.redhat.com/show_bug.cgi?id=856594#c26 ), I suggest to

Re: [Firebird-devel] "Covering" index?

2013-01-28 Thread Ann Harrison
On Mon, Jan 28, 2013 at 11:42 AM, Dimitry Sibiryakov wrote: > 28.01.2013 17:27, Thomas Steinmaurer wrote: > > How does the engine know when to garbage collect an index > > entry? > >When list of record references in it is empty. > > - Expanding again, when Firebird garbage collects a record v

Re: [Firebird-devel] gbak: restoring privileges

2013-01-28 Thread Dimitry Sibiryakov
28.01.2013 22:25, Helen Borrie wrote: > I think the jury is out on that theory. AFAIK, the 64K limit is on the size > of one SQL statement. A script is a lot of short SQL statements (on the > whole); although of course it can (and this one does) contain trigger and > procedure statements that

Re: [Firebird-devel] gbak: restoring privileges

2013-01-28 Thread Helen Borrie
>28.01.2013 19:48, Helen Borrie wrote: >> A related issue: This particular database has a very large amount of >> metadata and the extract script was rejected by isql -input as being too >> large for its buffer. Do we know what the limit on isql's buffer size is? At 07:58 a.m. 29/01/2013, Dim

[Firebird-devel] icu again

2013-01-28 Thread Philippe Makowski
For your information : https://bugzilla.redhat.com/show_bug.cgi?id=905069 -- Philippe Makowski http://www.ibphoenix.com Supporting users of Firebird -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CS

Re: [Firebird-devel] gbak: restoring privileges

2013-01-28 Thread Dimitry Sibiryakov
28.01.2013 19:48, Helen Borrie wrote: > A related issue: This particular database has a very large amount of > metadata and the extract script was rejected by isql -input as being too > large for its buffer. Do we know what the limit on isql's buffer size is? If nothing changed since I saw

Re: [Firebird-devel] gbak: restoring privileges

2013-01-28 Thread Helen Borrie
>>> gbak: ERROR:action cancelled by trigger (3) to preserve data integrity >>> gbak: ERROR:table/procedure has non-SQL security class defined >>> gbak:Exiting before completion due to errors >>> >>> What does the error signify? 28.01.2013 15:25, Alex Peshkoff wrote: >> Probably a bug. Can

Re: [Firebird-devel] "Covering" index?

2013-01-28 Thread Thomas Steinmaurer
> 28.01.2013 17:27, Thomas Steinmaurer wrote: >> How does the engine know when to garbage collect an index >> entry? > > When list of record references in it is empty. Thanks. Regards, Thomas -- Master Visual Studio,

Re: [Firebird-devel] "Covering" index?

2013-01-28 Thread Dimitry Sibiryakov
28.01.2013 17:27, Thomas Steinmaurer wrote: > How does the engine know when to garbage collect an index > entry? When list of record references in it is empty. -- WBR, SD. -- Master Visual Studio, SharePoint, SQL,

Re: [Firebird-devel] "Covering" index?

2013-01-28 Thread Thomas Steinmaurer
> On Sun, Jan 27, 2013 at 3:23 PM, Dimitry Sibiryakov > wrote: > > 27.01.2013 21:17, Thomas Steinmaurer wrote: > > Is Firebird able here to serve the result here out of the index > or does > > it need to lookup data by following the index key to the row

Re: [Firebird-devel] gbak: restoring privileges

2013-01-28 Thread Dmitry Yemanov
28.01.2013 15:25, Alex Peshkoff wrote: >> gbak: ERROR:action cancelled by trigger (3) to preserve data integrity >> gbak: ERROR:table/procedure has non-SQL security class defined >> gbak:Exiting before completion due to errors >> >> What does the error signify? > > Probably a bug. Can it be re

Re: [Firebird-devel] gbak: restoring privileges

2013-01-28 Thread Alex Peshkoff
On 01/28/13 13:12, Helen Borrie wrote: > Backup of an ODS 11.2 database was made on a v.2.5 server using the gbak.exe > from v.2.0. The database structure doesn't use anything that v.2.0 doesn't > support and has no permissions depending on the RDB$ADMIN role. The backup > completed without an

[Firebird-devel] gbak: restoring privileges

2013-01-28 Thread Helen Borrie
Backup of an ODS 11.2 database was made on a v.2.5 server using the gbak.exe from v.2.0. The database structure doesn't use anything that v.2.0 doesn't support and has no permissions depending on the RDB$ADMIN role. The backup completed without any errors. During the restore on the v.2.0.7 se