Great, Thanks!
On Friday, April 29, 2016 10:26 AM, "Gabor Boros gaborbo...@yahoo.com
[firebird-support]" wrote:
2016. 04. 28. 21:22 keltezéssel, Ann Harrison aharri...@ibphoenix.com
[firebird-support] írta:
> Okay... What's the requirement that keeps you from using generators?
I need
Hi Thomas,
> I don't see deadlocks with the following test case.
Thank you very much for the test case!
> No gaps, no deadlock messages, no pk/unique violation in the log table etc ...
Same for me. Got deadlock if try with NO RECORD VERSION.
> It is crucial that accessing the central generator
Found. Tried. Worked. Thanks
-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Freitag, 29. April 2016 18:24
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Changing non-nullable column to nullable in FB 3
29.0
29.04.2016 18:19, Ralf Jansen ralf.jan...@mailstore.com [firebird-support]
wrote:
> What would be the way to do it now?
Read Release Notes about changes in DDL.
--
WBR, SD.
++
Hi,
i followed the guideline here
http://www.firebirdsql.org/manual/nullguide-alter-pop-tables.html
to change an already populated column to nullable (constraint has no name).
The guideline involves updating a system table in such a case and in 3.0 they
are read-only now. What would be the way t
29.04.2016 17:57, Dmitry Yemanov wrote:
>
> Did you see the same issue on v2.5 or only on v3.0? Maybe it's a
> regression introduced in the new version. I'm checking the code now,
> will report back if anything useful is found.
I see a possible reason in the code, it needs testing. Can you send me
29.04.2016 12:38, Gabor Boros wrote:
>> This is true for two concurrent transactions but may fail for three or
>> more concurrent transactions.
>
> Your words shocked me. Firebird cannot handle more than two concurrent
> transactions? What is the purpose of WITH LOCK if see deadlock with and
> wit
Hi,
> 2016. 04. 28. 21:22 keltezéssel, Ann Harrison aharri...@ibphoenix.com
> [firebird-support] írta:
>> Okay... What's the requirement that keeps you from using generators?
>
> I need number generators which give back sequence numbers without
> skipping and repeating. But don't know how many
Hi,
Thanks everyone for your ideas on this - will try the data pump idea into a
new FB 3 database...
Cheers,
Dave
Hi!
We are trying to use Firebird 3.0 for our Delphi programs that use IBX
components (Delphi 2009, Delphi 2010 and Delphi XE). Local connection to the
Firebird 3.0 database is succesfull both from Flamerobin and from IBX. The
problem is connection to the remote server: both - Flamerobin and IB
29.04.2016 11:26, Gabor Boros gaborbo...@yahoo.com [firebird-support] wrote:
> The transaction do other work before grab the number and after grab the
> number. The whole thing is in a (one) stored procedure. (Works like a
> charm except deadlocks.)
You need transaction with explicit exclusive
2016. 04. 28. 17:18 keltezéssel, Dmitry Yemanov
dim...@users.sourceforge.net [firebird-support] írta:
> 28.04.2016 16:19, Gabor Boros wrote:
>
>> In the language reference for "isc_tpb_read_committed + isc_tpb_wait" I
>> see this: "Update conflict exceptions can never be raised by an explicit
>> l
2016. 04. 28. 21:22 keltezéssel, Ann Harrison aharri...@ibphoenix.com
[firebird-support] írta:
> Okay... What's the requirement that keeps you from using generators?
I need number generators which give back sequence numbers without
skipping and repeating. But don't know how many needed. The num
13 matches
Mail list logo