Re: [Firebird-devel] Direct System Table Update

2013-08-28 Thread Jim Starkey
Sorry about the long delay, but we were way down east in Maine. An essential flaw that Firebird inherited from Interbase is the way system tables are initialized at server startup. The current scheme makes it extremely difficult to make changes to the system tables without declaring a new ODS,

Re: [Firebird-devel] Fwd: Created: (CORE-4191) Define sequence name for "Identity Column Type"

2013-08-28 Thread Mark Rotteveel
On 27-8-2013 20:22, Adriano dos Santos Fernandes wrote: > The user issue is about managing the internal generator. > > You can do it now, but you need to discover its internal name. > > Why complicate things? > > Identity columns allows the use to put manually generated values. So the > ability to

Re: [Firebird-devel] Fwd: Created: (CORE-4191) Define sequence name for "Identity Column Type"

2013-08-28 Thread Dimitry Sibiryakov
28.08.2013 13:08, Adriano dos Santos Fernandes wrote: > It's clear a sequence. It even supports the parameters: Even if sequence and identity column has similar attributes, it doesn't mean that they are directly related. Author of CORE-4191 wants to set generator name for identity to manag

Re: [Firebird-devel] Fwd: Created: (CORE-4191) Define sequence name for "Identity Column Type"

2013-08-28 Thread Adriano dos Santos Fernandes
On 27/08/2013 18:15, Dimitry Sibiryakov wrote: > 27.08.2013 22:06, Adriano dos Santos Fernandes wrote: >> Why do a future version will go against the SQL standard? >Does standard explicitly mention that identity's internal sequence must be > user-manipulatible? Does it say that in must be the

[Firebird-devel] ICryptKeyCallback usage in ibase.h

2013-08-28 Thread Treeve Jelbert
gcc-4.81 gives warnings when compiling ibase.h from fb3 cc -c -I"/opt/firebird/include" -I"/usr/lib/perl5/site_perl/5.18.0/x86_64- linux/auto/DBI" -fno-strict-aliasing -pipe -fstack-protector - D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -march=native -mtune=native -m64 - pipe -ffast-math -funroll-

[Firebird-devel] [FB-Tracker] Created: (CORE-4194) Infinite ES EDS with AUTONOMOUS transaction leads to memory leak + 335544333: internal consistency check (cannot start cache writer thread)

2013-08-28 Thread Pavel Zotov (JIRA)
Infinite ES EDS with AUTONOMOUS transaction leads to memory leak + 335544333: internal consistency check (cannot start cache writer thread) ---

Re: [Firebird-devel] Fwd: Created: (CORE-4191) Define sequence name for "Identity Column Type"

2013-08-28 Thread Dimitry Sibiryakov
27.08.2013 23:47, Leyne, Sean wrote: > While I agree with your questions, I don't agree that Identity would be a > consideration for cluster/cloud architecture. > > Identity/Sequences are a poor fit for such usage modes, GUIDs/UUIDs are much > more appropriate, since the chances of same GUID bein