I have no clue what's going on here and will appreciate any comment.
My firebird installation behaves illogical:
Firebird 2.5.0
CPU E7400, 2.8 MHz
RAM 8 GB
Free disk space ca. 200 GB
OS Windows 7 professional 32 Bit
Table name VI_DETAIL
with primary key VI_DETAIL_RECORD
record created with FIB
I thought that DDL automatically committed - and I'm almost certain it was
before I upgraded to FB 2.x+
--- In firebird-support@yahoogroups.com, "plinehan" wrote:
>
>
>
> In firebird-support Thomas Steinmaurer wrote:
>
>
> > Do you isse a commit after creating the thable
> > and before actu
Thomas Steinmaurer wrote:
> Hi Paul,
Hi Thomas, thanks for the amazingly prompt reply 8-)
> > Is there a problem with DEFAULT in 2.5.1 or am I missing
> > something obvious?
> The latter. ;-)
Here's the reason for my confusion
http://tracker.firebirdsql.org/browse/CORE-665 - but I
> --- In firebird-support@yahoogroups.com, Thomas Steinmaurer wrote:
>>
>>> Tools: Delphi 2006, IB Objects (4.7+) and FB 2.1.3
>>>
From Delphi, I'm creating a table as part of a transaction. When I
attempt to open the table after it's created, I get a "Table unknown"
error. I hav
> In firebird-support Thomas Steinmaurer wrote:
>
>
>> Do you isse a commit after creating the thable
>> and before actually using the table?
>
> Isn't DDL automatically committed anyway?
In Oracle yes, but not in Firebird. You can automatically commit DDL
statements in e.g. scripts or isql, if
In firebird-support Thomas Steinmaurer wrote:
> Do you isse a commit after creating the thable
> and before actually using the table?
Isn't DDL automatically committed anyway?
Paul...
> Thomas Steinmaurer (^TS^)
Hi Paul,
> Puzzling one - running Ubuntu 10.10 - Maverick Meerkat. Using
> 2.5.1 embedded server. Run isql - can create databases and perform
> selects with no problems.
>
> However, when I try to run
>
> =
> CREATE TABLE MY_TABLE (
>TABLE_KEY INTEGER NOT NULL,
Hi all,
Puzzling one - running Ubuntu 10.10 - Maverick Meerkat. Using
2.5.1 embedded server. Run isql - can create databases and perform
selects with no problems.
However, when I try to run
=
CREATE TABLE MY_TABLE (
TABLE_KEY INTEGER NOT NULL,
TABLE_VALUE I
Hi Todd,
> --- In firebird-support@yahoogroups.com, Thomas Steinmaurer wrote:
>>
>>> --- In firebird-support@yahoogroups.com, Thomas Steinmaurer wrote:
> --- In firebird-support@yahoogroups.com, Doug
> Chamberlinwrote:
>>
>> On 2/29/12 2:50 PM, todderamaa wrote:
>>
Hello Dmitry,
> n> no one have an idea about what is a
>
> n> deadlock
> n> Error: 16
>
> n> ?
>
> n> the isolation of the transaction was: isc_tpb_read_committed +
> n> isc_tpb_no_rec_version + wait => normally no deadlock must appear ??
>
> Maybe you have 2 wait transactions that locks ea
Thanks Dmitry,
i will try to simulate this to see how 2 wait transactions that locks each
other ... thanks i will come back here with the result !
>
> Maybe you have 2 wait transactions that locks each other.
> Since you are using no_read_committed, it "locks" even
> on reading, so, any reading
Hello, nathanelrick!
Friday, March 2, 2012, 9:48:32 PM, you wrote:
n> no one have an idea about what is a
n> deadlock
n> Error: 16
n> ?
n> the isolation of the transaction was: isc_tpb_read_committed +
n> isc_tpb_no_rec_version + wait => normally no deadlock must appear ??
Maybe you have 2
Marsupilami79 schrieb am 23.02.2012 um 15:17 (+0100):
>
> I have a problem in understanding when to use the introducer syntax
> for character sets.
For literals. See here:
http://dev.mysql.com/doc/refman/5.0/en/charset-literal.html
> Helen Borrie states in the firebird books
What page number?
no one have an idea about what is a
deadlock
Error: 16
?
the isolation of the transaction was: isc_tpb_read_committed +
isc_tpb_no_rec_version + wait => normally no deadlock must appear ??
--- In firebird-support@yahoogroups.com, "nathanelrick"
wrote:
>
> hello,
>
> what is the most fast
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer wrote:
>
> > --- In firebird-support@yahoogroups.com, Thomas Steinmaurer wrote:
> >>
> >>> --- In firebird-support@yahoogroups.com, Doug
> >>> Chamberlin wrote:
>
> On 2/29/12 2:50 PM, todderamaa wrote:
> > Maybe with
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer wrote:
>
> > Tools: Delphi 2006, IB Objects (4.7+) and FB 2.1.3
> >
> >> From Delphi, I'm creating a table as part of a transaction. When I attempt
> >> to open the table after it's created, I get a "Table unknown" error. I
> >> have
> On Fri, 02 Mar 2012 09:03:02 +0100, Mark Rotteveel
> wrote:
>> On Tue, 28 Feb 2012 07:37:59 -, "syn.erpy"
> wrote:
>>> Hi,
>>>
>>> we ran into a little problem regarding blanks.
>>>
>>> Try the following code (FB 2.5.1):
>>>
>>>
>>> create exception blank 'blank';
>>>
>>> SET TERM ^ ;
>>>
>>
Hi Mark,
> On Fri, 02 Mar 2012 07:10:09 +0100, Thomas Steinmaurer
>> As expected. The equality operator removes trailing spaces before
>> evaluation. Use LIKE if you want to take trailing spaces into account.
>
> Comparison *adds* padding spaces to the shortest string to the length of
> the longes
Gugui [2012-03-01 21:36] :
> yep, i saw that,
> but i want to work with Firebird Classic version
>
and ?
what is the problem ?
Firebird Classic is available in EPEL repository
yum install firebird firebird-classic
or use the tar.gz
> It's not the connection, it's the transaction which is in the above
> mentioned mode. I don't understand why you resist on using no_rec_version.
but because if i use isc_tpb_read_committed + isc_tpb_rec_version then for sure
i will have deadlock ?
I try :
isc_tpb_read_committed
isc_tpb_rec_v
On Fri, 02 Mar 2012 09:03:02 +0100, Mark Rotteveel
wrote:
> On Tue, 28 Feb 2012 07:37:59 -, "syn.erpy"
wrote:
>> Hi,
>>
>> we ran into a little problem regarding blanks.
>>
>> Try the following code (FB 2.5.1):
>>
>>
>> create exception blank 'blank';
>>
>> SET TERM ^ ;
>>
>> create OR
On Fri, 02 Mar 2012 07:10:09 +0100, Thomas Steinmaurer
> As expected. The equality operator removes trailing spaces before
> evaluation. Use LIKE if you want to take trailing spaces into account.
Comparison *adds* padding spaces to the shortest string to the length of
the longest string to be com
On Tue, 28 Feb 2012 07:37:59 -, "syn.erpy" wrote:
> Hi,
>
> we ran into a little problem regarding blanks.
>
> Try the following code (FB 2.5.1):
>
>
> create exception blank 'blank';
>
> SET TERM ^ ;
>
> create OR alter procedure p_test
> as
> begin
>
> IF (' ' = '') THEN
> excep
23 matches
Mail list logo