Re: [firebird-support] High Availability Firebird

2016-12-13 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi, Please take a look http://www.slideshare.net/ibsurgeon/failsafe-cluster-for-firebirdsql-and-something-more Regards, Alexey Kovyazin IBSurgeon Hi Everyone, First, I apologise if this isn't the correct group - please forgive me. I'm trying to find some contemporary (ie from in the last 24

Re: [firebird-support] [FB3] Inserting into a table with only an identity column

2016-12-13 Thread tvd...@ymail.com [firebird-support]
Missed that; dank je. :)

[firebird-support] [FB3] Inserting into a table with only an identity column

2016-12-13 Thread tvd...@ymail.com [firebird-support]
If I have a table like this: CREATE TABLE EXAMPLE ( E_ID BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY ); How do I add a record to it, getting an automatically assigned ID? For example, in PostgreSQL, I'd write: INSERT INTO EXAMPLE(E_ID) VALUES

Re: [firebird-support] Re: Data pages and data page slots

2016-12-13 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
Thank you very much Vlad, that is what I was thinking but always is very better to have the explanation of one expert. Greetings. Walter. On Tue, Dec 13, 2016 at 11:25 AM, hv...@users.sourceforge.net [firebird-support] wrote: > > > ---In

[firebird-support] Re: Data pages and data page slots

2016-12-13 Thread hv...@users.sourceforge.net [firebird-support]
---In firebird-support@yahoogroups.com, wrote : > When I run GSTAT with the switch -data it shows me numbers after "data > pages" and "data page slots". > > Usually these numbers are the same, but ... what happen when they are > different? Physical numbers

[firebird-support] simply CTE

2016-12-13 Thread 'Check_Mail' check_m...@satron.de [firebird-support]
Hello, at the moment I get all material of a product with a recoursion, but in some case, I get it manyfold and not grouped. (it gets all Material of the material in each level) How can I create a CTE (grouped)? create or alter procedure P_GETMATERIALTEST ( TEILENR varchar(16), ANZAHLT

Re: [firebird-support] Data pages and data page slots

2016-12-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.12.2016 8:59, 'Walter R. Ojeda Valiente' wrote: > Is there something wrong there? No. > Is possible (and useful) make these numbers equals? Yes: fill database with useful data. -- WBR, SD.