Re: [Firebird-devel] Y-classes trickery

2014-03-20 Thread Dimitry Sibiryakov
20.03.2014 9:57, Alex Peshkoff wrote: Saving 2 atomic ops per thread enter/exit is not very much, but if we can do it why not. Are you sure that acquiring mutex on every API call is two atomic ops?.. -- WBR, SD.

Re: [Firebird-devel] Y-classes trickery

2014-03-20 Thread Dimitry Sibiryakov
20.03.2014 11:44, Alex Peshkoff wrote: Acquiring mutex is anyway needed. Why? If next reference is not nullified on detach, there is nothing to protect. -- WBR, SD. -- Learn Graph Databases - Download FREE

Re: [Firebird-devel] Y-classes trickery

2014-03-20 Thread Alex Peshkoff
On 03/20/14 14:51, Dimitry Sibiryakov wrote: 20.03.2014 11:44, Alex Peshkoff wrote: Acquiring mutex is anyway needed. Why? If next reference is not nullified on detach, there is nothing to protect. I've already said here - this mutex protects not only next reference.

[Firebird-devel] x86-64 unicode/platform.h and arm eabi unicode/platform.h from debian are identical

2014-03-20 Thread marius adrian popa
I was Building Firebird Client for Android http://mapopa.blogspot.ro/2013/09/building-firebird-client-for-android.html and found that x86-64 unicode/platform.h and arm eabi unicode/platform.h from debian are identical The way i checked dpkg -S /usr/include/x86_64-linux-gnu/unicode/platform.h

[Firebird-devel] Sysdba not defined by default?

2014-03-20 Thread Claudio Valderrama C.
Hello, I have an empty x.fdb in FB3. I created some user caspian. I start firebird.exe with -ma flags (multi + application). Now I can connect through TCP with that user but not with sysdba: F:\fb3dev\fbbuild\firebird30\temp\Win32\Debug\firebirdisql localhost:x.fdb -user sysdba -pass masterkey

Re: [Firebird-devel] Gpre and DYN

2014-03-20 Thread Claudio Valderrama C.
-Original Message- From: Alex [mailto:peshk...@mail.ru] Sent: MiƩrcoles, 19 de Marzo de 2014 3:09 On 03/19/2014 10:40 AM, Claudio Valderrama C. wrote: Alex said: Main idea was to be able to generate programs for older versions. Then gpre should check the server version and

[Firebird-devel] RFC: stop fiddling with sys tables

2014-03-20 Thread Claudio Valderrama C.
This is my own view, but it comes from a conversation with Dmitry: - Rights on sys tables should be forbidden. If you want to grant/revoke specific actions, use DDL. No ACLs on sys tables. - If there are things that can't be accomplished with our regular methods, we create more DDL. We should

Re: [Firebird-devel] RFC: stop fiddling with sys tables

2014-03-20 Thread Leyne, Sean
- Creating user objects with RDB$ prefix should be forbidden (at least until we implement schemas). Why? RDB$System_Flag already exists in RDB$Relations, which identify true system defined objects, why is it necessary to prevent the use of the prefix by a user? I think you missed: -

Re: [Firebird-devel] RFC: stop fiddling with sys tables

2014-03-20 Thread Dimitry Sibiryakov
20.03.2014 23:05, Leyne, Sean wrote: I think you missed: - Can/should user create additional columns in System tables? (ie. Create_datetime, Change_datetime -- for a simple schema change tracking function) - Can/should user create their own triggers on System tables? (i.e. to detect

Re: [Firebird-devel] RFC: stop fiddling with sys tables

2014-03-20 Thread Leyne, Sean
20.03.2014 23:05, Leyne, Sean wrote: I think you missed: - Can/should user create additional columns in System tables? (ie. Create_datetime, Change_datetime -- for a simple schema change tracking function) - Can/should user create their own triggers on System tables? (i.e. to

Re: [Firebird-devel] RFC: stop fiddling with sys tables

2014-03-20 Thread Jim Starkey
User updateable system tables seemed like a good way to build a access language neutral database engine for Rdb/ELN and Interbase. The Rdb/VMS guys never warmed to the concept, and developed an MBLR (metadata BLR) mechanism. It wasn't a big hit, either, and I eventually created DYN for many

Re: [Firebird-devel] RFC: stop fiddling with sys tables

2014-03-20 Thread Claudio Valderrama C.
-Original Message- From: Leyne, Sean [mailto:s...@broadviewsoftware.com] Sent: Jueves, 20 de Marzo de 2014 18:46 That's what DDL triggers are for. They can write change log to a user table, no need to touch system ones. OK, but since DDL Triggers don't yet exist -- what

Re: [Firebird-devel] RFC: stop fiddling with sys tables

2014-03-20 Thread Carlos H. Cantu
LS OK, but since DDL Triggers don't yet exist -- what should be supported in the meantime? DDL triggers are already available at FB 3: http://tracker.firebirdsql.org/browse/CORE-2310 []s Carlos http://www.firebirdnews.org FireBase - http://www.FireBase.com.br

Re: [Firebird-devel] RFC: stop fiddling with sys tables

2014-03-20 Thread Adriano dos Santos Fernandes
On 20-03-2014 18:38, Claudio Valderrama C. wrote: - Using ATT_gbak_attachment is a security risk, but I don't know how to solve it. I think this should be replaced by a role, BACKUP_OPERATOR and of course, this role is checked against the active user, not a program saying I'm gbak. Anybody

Re: [Firebird-devel] Sysdba not defined by default?

2014-03-20 Thread Claudio Valderrama C.
-Original Message- From: Claudio Valderrama C. [mailto:cva...@usa.net] Sent: Jueves, 20 de Marzo de 2014 16:51 F:\fb3dev\fbbuild\firebird30\temp\Win32\Debug\firebirdisql localhost:x.fdb -user sysdba -pass masterkey Statement failed, SQLSTATE = 28000 Your user name and password

Re: [Firebird-devel] RFC: stop fiddling with sys tables

2014-03-20 Thread Claudio Valderrama C.
-Original Message- From: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com] Sent: Jueves, 20 de Marzo de 2014 21:34 On 20-03-2014 18:38, Claudio Valderrama C. wrote: - Using ATT_gbak_attachment is a security risk, but I don't know how to solve it. I think this should be

Re: [Firebird-devel] RFC: stop fiddling with sys tables

2014-03-20 Thread Dmitry Yemanov
21.03.2014 01:38, Claudio Valderrama C. wrote: - Linking user tables to sys tables (FK) should be forbidden (I didn't try, but if it works, it shouldn't). Sys tables don't have PK/UK constraints (only unique indices), so FKs cannot be created. - User code should not fiddle with sys