HI,
first of all wrong group this is not support list.
But you doing somethink what is supported by execute statement, and you do mot
need to modify external table intf. Execute statement in Fb2.5 can run query
against external database
Regards,
Karol Bieniaszewski
- Reply message -
Od
Hi,
I suppose that isolating computer and some ports is work for firewall and
router not for FB. You say locslhost, someone can say localnetwork, other som
mask, others mayby some groups of masks...
If you need to block port go to firewall and block incomming traffic to port
3050.
Regards,
Ka
Rotteveel"
Do: "For discussion among Firebird Developers"
Temat: [Firebird-devel] Odp: Firebird should listen on localhost only (secure
by default)
Data: pt., mar 15, 2013 08:32
On Thu, 14 Mar 2013 20:38:39 +0100, "liviusliv...@poczta.onet.pl"
wrote:
> Hi,
>
&g
Hi,
in my opinion this should by done by the keyword may be "hidden"
E.g.
Create table test(
Id integer,
Interfld varchar(10) hidden,
But this must be stored into system table and ods will then chang?
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Roman Simakov"
Do: "For di
Hi,
I think about this once again an what problem do you see with
a) select * from table b) insert into table values (...)
In point a - users see service fields and what problem? Wrong design and they
see it
In point b i see also no problem. Add after insert trigger and clear this
copied fiel
Hi,
Interesting :) then i see FB work in the same way as PGSQL if this is good and
SQL conformant then all is ok.
Thanks Dmitry i have not PGSQL installed anywhere only, IB, FB, MSSQL, ORACLE
and Ingress. Only two of them have window function implemented
Regards,
Karol Bieniaszewski
- Rep
Hi,
You have right :)
I always change all statements as exists statement becouse it is more readable
but i ommit existence of this very old feature :)
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Mark Rotteveel"
Do: "For discussion among Firebird Developers"
Temat: [Firebird-d
Hi,
This is only theory about guids. I remember my real situation 10 servers from
the same part no. System with 1000 new rec per sec and every day we got e.g 20
records with the same guid on different mashines. We change design to prefix
keys in all servers unique.
Regards,
Karol Bieniaszewski
Hi,
I need to modify UID and GID fields of user record in FB3.0. How can i do this
now? I try to connect to security db but i get permission denied. Alter user
command not operate on this fields.
Please help,
Regards,
Karol Bieniaszewski
---
16:49
Karol,
Please explain why you need to do this.
I’d like to understand the usage which would require such a feature/function.
Sean
From: liviusliv...@poczta.onet.pl [mailto:liviusliv...@poczta.onet.pl]
Sent: Thursday, October 31, 2013 11:22 AM
To: For discussion among Firebird Developers
Hi,
This will be very good but as i understand it correctly this is still not
backward compatibile
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Alex Peshkoff"
Do:
Temat: [Firebird-devel] Compatibility FB3.0 boolean and Interbase
Data: czw., lis 14, 2013 08:45
On 11/13/13 17
May be in FB4.0 :)
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Mark Rotteveel"
Do: "For discussion among Firebird Developers"
Temat: [Firebird-devel] Subquery more then 1 field
Data: sob., lis 16, 2013 15:47
On 16-11-2013 12:52, liviuslivius wrote:
> Hi,
> many times i need t
Hi,
I always think about CTE as recursive query, thanks for hint
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Leyne, Sean"
Do: "For discussion among Firebird Developers"
Temat: [Firebird-devel] Subquery more then 1 field
Data: sob., lis 16, 2013 22:10
> many times i need to
Hi,
Will be good to have some configurable option for data type result for count(*).
In FB3 result rype is bigint in previous it was integer.
All projects which use integer in designer faill becouse of that.
Regards,
Karol Bieniaszewski
bird Developers"
Temat: [Firebird-devel] Compatibiliti fb3 and previous
Data: wt., gru 3, 2013 12:24
On Tue, 03 Dec 2013 12:10:30 +0100, "liviusliv...@poczta.onet.pl"
wrote:
> Hi,
>
> Will be good to have some configurable option for data type result for
> count(*).
>
>>I'd suggest to let the legacy PLAN resting in piece. It's already misses many
>>optimizer features and will outdate more and more with years.
Hi, Dmitry
Why plan can not by extended for hint purposes? This is natural place for FB
users to tell optimizer the better way of query execution. Thi
2014 22:11
14.02.2014 21:38, liviusliv...@poczta.onet.pl wrote:
> i need to know what is difference in meaning of collate between this three
> queries
Changing of collation is a kind of cast. Not recoverable. First and second
query are ok
because are grouped either by original value or b
Thank you both Dmitry
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Dmitry Yemanov"
Do: "For discussion among Firebird Developers"
Temat: [Firebird-devel] Odp: Fw: [firebird-support] Difference in "collation"
meaning
Data: sob., lut 15, 2014 10:58
Hi,
Take into account that user can rollback or commit oryginal transaction before
we copy all data to clone. Is this a problem or is simple to clone transaction
in atomic way?
Regards,
Karol Bieniaszewski
- Reply message -
Od: "James Starkey"
Do: "For discussion among Firebird Develo
Hi Sean,
you misunderstud my context. I do not talk about result of cloning but about
implementation of clone process by FB developers. When i talk about copying
data i talk about transaction data like flags, tip ... not database data like
records...
Regards,
Karol Bieniaszewski
- Reply m
Hi,
If i can say my proposition. Then my favourite is transaction id as int64. Many
times i must spend weeks to to overcome this limit in projects. Ok, then this
projects are "better and faster" but cost is also bigger and bigger...
When i think about web develooment i also have problem with th
Hi,
If we talking about synchronous replication then what problem with extending
shadow files feature to support it?
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Jim Starkey"
Do:
Temat: [Firebird-devel] Replication
Data: śr., kwi 30, 2014 00:46
On 4/29/2014 8:38 AM, Dimitry S
Hi,
What problem do you have with monitoring FB by nagios. We collect stats from FB
for nagios without problem
Regards,
Karol Bieniaszewski
- Reply message -
Od: "marius adrian popa"
Do: "For discussion among Firebird Developers"
Temat: [Firebird-devel] Re Planning the post v3 devel
Hi,
Try execute block this will be "one" statement if this is your point about
"one"
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Jiří Činčura"
Do: "For discussion among Firebird Developers"
Temat: [Firebird-devel] Adding/removing NOT NULL from column in one DDL
Data: czw., l
Hi,
I will try tommorow
But if you have Win7pro install xpmode ;)
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Vlad Khorsun"
Do:
Temat: [Firebird-devel] Snapshot 3.0.0.31439 Not listen on any port?
Data: śr., lis 19, 2014 20:25
19.11.2014 16:08, Michal Kubecek wrote:
> Could
13:06
On 12/22/14 01:19, liviusliv...@poczta.onet.pl wrote:
> -Oryginalna wiadomość-
> From: Alex Peshkoff
> Sent: Thursday, December 18, 2014 4:48 PM
> To: firebird-devel@lists.sourceforge.net
> Subject: Re: [Firebird-devel] FB3 initializing security database with legacy
>
czw., sty 15, 2015 09:17
12.01.2015 23:22, liviusliv...@poczta.onet.pl wrote:
>
> is somewhere some list of changes in this or can someone say something
> in this matter
> http://www.firebirdsql.org/en/firebird-technical-specifications/
> I am really interest in max records in table – i
Hi,
Is some plan for extend this?
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Dmitry Yemanov"
Do: "For discussion among Firebird Developers"
Temat: [Firebird-devel] 255 contexts limit
Data: niedz., lut 1, 2015 08:35
01.02.2015 02:08, liviusliv...@
wrote:
>
> For my own personal edification, what are you doing the requires more than
> 256 contexts?
>
> Jim Starkey
>
>
>> On Feb 1, 2015, at 11:58 AM, "liviusliv...@poczta.onet.pl"
>> wrote:
>>
>> Hi,
>>
>> Is som
Hi,
This is simple
Store your user, password and role in context variable and use it in execute
statement
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Geoff Worboys"
Do:
Temat: [Firebird-devel] execute statement on external role
Data: czw., lut 5, 2015 13:36
Hi,
Firebird v2.
Hi,
It is usefull for testing purposes. Consider monitoring what actually is in
some table from other connection or software before some long task has finished.
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Mark Rotteveel"
Do: "For discussion among Firebird Developers"
Temat:
., mar 7, 2015 00:54
liviusliv...@poczta.onet.pl wrote:
> Hi Adriano,
> thanks i found this
> i change also
> PChar = type System.Pointer;
and you write, in a later post:
> i try to run your example - i change code to Delphi
With recent (2009+) versions of Delphi "string" i
Thanks you Dmitry
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Dmitry Yemanov"
Do: "For discussion among Firebird Developers"
Temat: [Firebird-devel] Explained plan "Access By ID"
Data: pon., mar 9, 2015 12:21
09.03.2015 14:13, liviuslivius wrote:
>
> what is "Access By ID" in
33 matches
Mail list logo
