Am 29.03.2017 um 18:04 schrieb Dimitry Sibiryakov:
>Hello, All.
>
>Which Pascal compiler is supposed to be used with GPRE'd programs? Is
> there an example
> of a Pascal program with ESQL?
>
From the stone age:
http://firebird.cvs.sourceforge.net/viewvc/firebird/interbase/examples/
ht
On 06.11.2014 19:44, Dimitry Sibiryakov wrote:
> 06.11.2014 19:24, Mark Rotteveel wrote:
>> I don't really understand why you would want to disable replication for
>> a single transaction.
>
> There may be a number of reason. The main one is that this transaction is
> performed by
> replicator
o recreate the package, as I was not able to assign rights to it
afterwards.
If required, I can provide the fbk too.
Frank
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they ma
On 02.10.2014 20:49, Dmitry Yemanov wrote:
> 02.10.2014 20:18, Frank Schlottmann-Gödde wrote:
>>
>> I'm getting
>> gbak: ERROR:action cancelled by trigger (3) to preserve data integrity
>> gbak: ERROR:object has non-SQL security class defined
>> gbak:E
ideas?
Frank
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly faithful pets."
- J.K. Rowling
--
Meet PCI DSS 3.0 Complian
Am 02.07.2014 12:41, schrieb Adriano dos Santos Fernandes:
> On 02/07/2014 04:40, Frank Schlottmann-Gödde wrote:
>> Am 02.07.2014 04:21, schrieb Adriano dos Santos Fernandes:
>>> Frank,
>>>
>>> Please don't mess with obj.h for ISQL support.
>>>
&
Am 02.07.2014 04:50, schrieb Claudio Valderrama C.:
>
> I have my reservations about the extraction order, but since I didn't try, I
> didn't voice my concern yet. This was the old order:
> list_functions();
> list_generators();
> list_domains(default_char_
Am 02.07.2014 04:21, schrieb Adriano dos Santos Fernandes:
> Frank,
>
> Please don't mess with obj.h for ISQL support.
>
> I think you should do it different, for example, passing extra
> parameters instead of the new constants.
I will m
Project: Firebird Core
Issue Type: Bug
Components: GBAK
Affects Versions: 3.0 Alpha 2
Reporter: Frank Schlottmann-Goedde
The following isql script creates a database that can't be restored by gbak:
SET SQL DIALECT 3;
/* CREATE DATABASE 'localhost:C:
tribute using git?
The other requests can be handled with svn too.
frank
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly faithful pets.&
Am 05.05.2014 08:48, schrieb Molnár Attila:
>> I believe that there are UDFs available for this already, no?
> A very old and unsuppoted udf. In my case I do not expect to read back
> from file to DB just one way.
It's old but not unsupported :-)
And works as expected.
ftp://freeadhocudf.org/adh
On 03.09.2013 10:47, Alex Peshkoff wrote:
> On 09/03/13 11:43, Frank Schlottmann-Gödde wrote:
>
>> Hm, I had to run autoreconf etc. on it to build it on Ubuntu 8.04
>>
>
> Did you try with initial package or with one we have in the tree?
> Must say I've generated c
Am 10.09.2013 23:34, schrieb Ann Harrison:
> On Tue, Sep 10, 2013 at 5:23 PM, Vlad Khorsun
> mailto:hv...@users.sourceforge.net>> wrote:
>
>
> >
> > First, thanks for the details (BTW, is there a link for the spec)
>
> AFAIR, SQL standard is not free, so there is no link for free
Am 03.09.2013 10:47, schrieb Alex Peshkoff:
> On 09/03/13 11:43, Frank Schlottmann-Gödde wrote:
>
> To be precise I'm not sure why did that guy need automake at all :-)
> It's required only if one touch Makefile.am. For regular builds existing
> in the tree configure is
Am 03.09.2013 10:02, schrieb Alex Peshkoff:
> The main reason why do we include libedit at all is licensing
Yes we had a discussion on this topic with a debian maintainer back in
2002 when we had to replace calls to readline with editline.
> - built
> into all known to me distros libreadline (it
Am 03.09.2013 09:08, schrieb Alex Peshkoff:
> On 09/03/13 09:14, Frank Schlottmann-Gödde wrote:
>> On 02.09.2013 17:04, Alex Peshkoff wrote:
>>> On 09/02/13 16:06, marius adrian popa wrote:
>>>> libedit will be updated and patched for 2.5.x branch also ?
>>
Am 03.09.2013 09:13, schrieb Michal Kubecek:
> On Tue, Sep 03, 2013 at 07:14:45AM +0200, Frank Schlottmann-Gödde wrote:
>> On 02.09.2013 17:04, Alex Peshkoff wrote:
>>>
>>> I think that all distros, not debian only, support fresh editline
>>> library. An
could be fixed by either including editline to the autogen.sh
script or adding calls to autoreconf etc. to Makefile.in.extern.editline.
Frank
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healin
Am 05.08.2013 09:23, schrieb Alex Peshkoff:
> Does 'Del' key work?
Yes, only Ins, Pageup and Pagedown show '~' instead of doing sth.
useful, but this is the same as with the old editline version.
Frank
--
"Fascinating creatures, phoenixes, they can carry immensel
is finally useable as a drop-in replacement for the extern/editline stuff.
Just replace the contents of extern/editline with the archive above,
apply the attached patches, configure with --with-editline=yes and you
will get an isql with UTF8 enabled line editing.
Frank
--
"Fascinating c
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 1
Environment: all
Reporter: Frank Schlottmann-Goedde
Priority: Blocker
The following script demonstrates the issue
On 12/01/2012 02:49 PM, Vlad Khorsun wrote:
> I think, this is a bug.
I added it to the tracker.
kind regards
Frank
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly faithful pets."
-
: 2.5.2
Environment: all
Reporter: Frank Schlottmann-Goedde
with recursive
CTE_CNT1 as (select 0 as I
from RDB$DATABASE
union all select I + 1
from CTE_CNT1
where I < 9),
CTE_CNT2 as (select I, 0 as J
from CTE_CNT1
union all select J * 10 + c1.I, c
Hi Frank,
Am 30.11.2012 17:42, schrieb Frank Schlottmann-Gödde:
> On 29.11.2012 11:08, Frank Ingermann wrote:
>> Isn't it so that a CTE Select can only have one recursive member?
> I don't think so, because the construct we have problems with, already
> contains two
On 29.11.2012 11:08, Frank Ingermann wrote:
> Hi Frank,
>
> Am 29.11.2012 07:51, schrieb Frank:
>> On 11/20/2012 10:53 AM, Frank Schlottmann-Gödde wrote:
>>
>> No idea, anybody?
>>
> Isn't it so that a CTE Select can only have one recursive member?
I don&
Hi Frank,
Am 29.11.2012 07:51, schrieb Frank:
> On 11/20/2012 10:53 AM, Frank Schlottmann-Gödde wrote:
>
> No idea, anybody?
>
Isn't it so that a CTE Select can only have one recursive member?
(at least that's what i remember from Vlad's presentation back
in Bergamo, b
On 11/20/2012 10:53 AM, Frank Schlottmann-Gödde wrote:
> Hi,
> I asked this in the support list, but got no answer:
>
>
> I do not understand why
>
> set planonly;
> with recursive
> CTE_CNT1 as (select 0 as I
> from RDB$DATABASE
> union all
On 11/20/2012 11:03 AM, Dmitry Yemanov wrote:
> 20.11.2012 13:53, Frank Schlottmann-Gödde wrote:
>>
>> I asked this in the support list, but got no answer:
>
> First of all, what FB version are you talking about?
>
Sorry,
2.5.2.26510 and 3.0.0.30126
Frank
--
s with
PLAN (CTE_CNT2 RDB$DATABASE NATURAL, CTE_CNT2 CTE_CNT1 RDB$DATABASE
NATURAL, JOIN ())
Frank
-- "Fascinating creatures, phoenixes, they can carry immensely heavy
loads, their tears have healing powers and they make highly faithful
pets
ill vanish when
these issues are fixed, I didn't create an tracker entry for our
original problem.
hth
Frank
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly faithful pe
ebird Core
Issue Type: Bug
Affects Versions: 3.0 Initial
Environment: probably all (tested with Windows 7 and Ubuntu 12.04)
Reporter: Frank Schlottmann-Goedde
Using the following script in isql against the employee database demonstrates
the error
/*
Creatin
Environment: probably all (tested with Windows 7 and Ubuntu 12.04)
Reporter: Frank Schlottmann-Goedde
Using the following script in isql against the employee database demonstrates
the error
/*
subselect with reference to outer select
fails with:
Statement failed, SQLSTATE = 42S22
/CORE-3966
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0 Initial
Environment: probably all (tested with Windows 7 and Ubuntu 12.04)
Reporter: Frank Schlottmann-Goedde
Priority: Critical
Using the following script in isql against th
ebird Core
Issue Type: Bug
Affects Versions: 3.0 Initial
Environment: probably all (tested on Windows 7 and Ubuntu 12.04)
Reporter: Frank Schlottmann-Goedde
Priority: Blocker
Using the following script in isql against the employee database demonst
ebird Core
Issue Type: Bug
Affects Versions: 3.0 Initial
Environment: probably all platforms (tested on Windows 7.0 and Ubuntu
12.04)
Reporter: Frank Schlottmann-Goedde
Using the following script in isql against the employee database demonstrates
the error
/*
It is no
Issue Type: Improvement
Components: ISQL
Affects Versions: 3.0 Initial
Environment: probably all
Reporter: Frank Schlottmann-Goedde
Priority: Minor
Using the following script in isql against the employee database shows the
issue:
/*
isql doesn&
Am 24.10.2012 10:19, schrieb Mark Rotteveel:
> On Wed, 24 Oct 2012 10:05:10 +0200, Frank Schlottmann-Gödde
> wrote:
>> Hi,
>> while trying to get our admittedly not so trivial database running under
>> FB3.0 I ran into some more bugs/issues.
>>
>> I don'
Hi,
while trying to get our admittedly not so trivial database running under
FB3.0 I ran into some more bugs/issues.
I don't know whether to discuss them here first or directly create
issues in the tracker?
Frank
--
"Fascinating creatures, phoenixes, they can carry immensely h
from RDB$RELATION_FIELDS F2
> where F2.RDB$FIELD_NAME ='PHONE_EXT'
> and F2.RDB$RELATION_NAME=R1.RDB$RELATION_NAME
> );
Sure, but this query doesn't throw the error I wanted to demonstrate :-)
Frank
--
"Fascinating creatures, phoenixes,
On 23/10/12 11:24, Dmitry Yemanov wrote:
>
> It smells like a bug caused by the new restriction ;-)
> I will investigate that, thanks.
>
thank you
Frank
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and
On 23/10/12 11:21, Kjell Rilbe wrote:
> Den 2012-10-23 10:32 skrev Frank såhär:
>> select R1.RDB$RELATION_NAME
>> from RDB$RELATION_FIELDS F1
>> join RDB$RELATIONS R1 on F1.RDB$RELATION_NAME = R1.RDB$RELATION_NAME
>> where F1.RDB$FIELD_NAME ='EMP_N
LATION_NAME
-At line 8, column 32
in head.
I'm not sure whether this is a bug or a new restriction according to
some obscure standard.
Frank
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly faithf
On 16/07/12 10:05, Mark Rotteveel wrote:
> On Mon, 16 Jul 2012 01:01:31 +0200, Roman Rokytskyy
> wrote:
>> - should be integrated with Eclipse at least on the same level as CVS.
>
> The latest versions of Eclipse supports git and the Eclipse project itself
> has moved all their code to git, so I
On 27/06/12 11:45, Alex Peshkoff wrote:
> On 06/25/12 16:52, Frank wrote:
>> Any ideas are welcome.
>>
>
> Frank, is this error still reproduced?
No, it is gone, must have been a real rare race condition.
> If yes - can you provide me remote access to that box? (reviewi
tdown, isc_dpb_shut_attachment |
isc_dpb_shut_single);
dpb.insertInt(isc_dpb_shutdown_delay, 0);
Any ideas are welcome.
Frank
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly faithful pets."
than UTF8 and ISO8859_1.
Here is what i have so far:
You may ignore the SWITCH_NOHEADINGS part.
mit freundlichen Grüßen
Frank Schlottmann-Gödde
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they ma
n't know
> where it's coming from. Any help here would be greatly appreciated.
in /builds/install/arch-specific/darwin/Makefile.in are lots of
invocations of "sed -e", so the resulting Makefile should have them
also. I can't check it, as I don't have a Mac at han
On 19.01.2012 09:14, Claudio Valderrama C. wrote:
>> -Original Message-
>> From: Frank Schlottmann-Gödde [mailto:fr...@schlottmann-goedde.de]
>> Sent: Viernes, 09 de Diciembre de 2011 12:47
>>
>> I would like to see a switch added to qli to stop it fro
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/01/12 10:14, Frank Schlottmann-Gödde wrote:
> Thank you, Alex and Michal, I will try your suggestions this evening and
> report back.
- - $(EXE_LINK) $(EXE_LINK_OPTIONS) $^ -o $@ $(FIREBIRD_LIBRARY_LINK)
$(LINK_LIBS) $(LIBED
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/01/12 09:25, Michal Kubecek wrote:
> You can try this patch:
>
> (3.0)
> https://api.opensuse.org/public/source/home:mkubecek:firebird30/firebird/firebird-3.0.0-libs.patch?rev=ce5aa283de19c37aa77873e4f2fc1cc6
>
> (2.5)
> https://api.opensuse
Hi,
I'm trying to compile head with --with-editline=yes and get the
following linker error:
g++-pthread -Wl,-rpath,'$ORIGIN/../lib'
-Wl,-rpath,'$ORIGIN/../intl' -Wl,--version-script,empty.vers
/home/fsg/src/fbbuild/build_posix/firebird2/temp/Release/isql/ColList.o
/home/fsg/src/fbbuild/buil
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/01/12 08:13, Alex Peshkoff wrote:
> On 01/09/12 18:45, Frank Schlottmann-Gödde wrote:
>
>>> Anyway - I suppose that for FB 3.0 it will be much better to upgrade
>>> servers. Moreover, for the time of release of FB
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/01/12 12:30, Alex Peshkoff wrote:
>
> Installing library from source is certainly possible.
I had to change makefile a bit to get it installed:
I replaced GROUP=wheel with GROUP=root
and added -fPIC to CFLAGS.
fsg
-BEGIN PGP SIGNATUR
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/01/12 15:34, Alex Peshkoff wrote:
> On 01/09/12 18:30, Frank Schlottmann-Gödde wrote:
>
>> Oldest still active server has glibc 2.6.1
>
> Very interesting. We did not have reliable information, does it work
> with FB 2.5
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/01/12 12:30, Alex Peshkoff wrote:
> On 01/09/12 13:26, Frank Schlottmann-Gödde wrote:
>
>> E: Couldn't find package libtommath-dev
>
> Yes, libtommath is relatively new library, better say - it became enough
> pop
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/01/12 10:42, Philippe Makowski wrote:
> Frank Schlottmann-Gödde [2012-01-09 10:26] :
>> You could argue that this is too old to run Firebird 3.0
> yes like RHEL5 is too old too
> you can try to backport the package from Ubun
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/01/12 08:49, Alex Peshkoff wrote:
> On 01/09/12 11:27, Frank Schlottmann-Gödde wrote:
>> On 09/01/12 07:41, Alex Peshkoff wrote:
>>> On 01/06/12 20:18, Michal Kubecek wrote:
>>>> Hello,
>>>>
>
On 09/01/12 07:41, Alex Peshkoff wrote:
> On 01/06/12 20:18, Michal Kubecek wrote:
>> Hello,
>>
>> HEAD currently doesn't build on Linux if LibTomMath is not installed
...
> Builtin source is added only to make windows happy. On linux we should
> always use system library.
It is not available out
x27;D':
+ QLI_nod = true;
+ break;
+
+
case 'F': // fetch password
{
if (argv >= arg_end || **argv == '-')
Hi Adriano,
Am 04.12.2011 19:36, schrieb Adriano dos Santos Fernandes:
> On 30-11-2011 23:36, Adriano dos Santos Fernandes wrote:
>> On 16-11-2011 22:39, Frank Ingermann wrote:
>>> Hi all,
>>>
>>> i'm trying to combine the new Window functions in Fb3 w
a "good" coder,
you document the business logic in SPs and Triggers with at least some comments
(and sometimes withoutthose comments it's hard to tell what the code is really
doing ;-) ).You can reverse-engineer the SQL from BLR, but not those
comments(!).cheers,Frank
---
Nutze
Hi Claudio,
>> From: Frank Ingermann [mailto:fr...@fingerman.de]
>>
>> Still i think it's a no-go to just take the ability _away_ to
>> clear out those sources. It IS common practise.
(+1 for the COMMENTs!)
> The problem is that we lack equivalent commands for
Hi Helen e.a.,
Am 30.11.2011 19:32, schrieb Helen Borrie:
>>>On 11/30/11 02:42, Frank Ingermann wrote:
>>>> DROP SOURCE OF [||*]
>>>> or
>>>> CHANGE OWNER OF [|*] TO
>> I don't think bloat the language with non-standard syntax for
>
ese lines. ( Security/grants will have to be
carefully considered here, obviously! :-) )
Does the "standard" say anything about these things?
cheers,
Frank
--
All the data continuously generated in your IT i
Hi Adriano,
Am 21.11.2011 20:04, schrieb Adriano dos Santos Fernandes:
> On 21/11/2011 16:45, Frank Ingermann wrote:
>> So this would mean option b) is correct:
>>
>> b) [ ] window functions are not supposed to work in the "child select"
>> part o
st" - which is where it hits the hard-coded limit
for the maximum recursion depth i guess. The good news: it doesn't
crash the server, so you can try again :-)
cheers,
Frank
--
All the data continuously generated i
.. e) ?
(i'm VERY interested in the "(...)" part of option d) as well as
everything in option e) :-) )
cheers,
Frank
--
All the data continuously generated in your IT infrastructure
contains
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.2
Environment: Linux x86_64 (tested on Ubuntu 11.10)
Firebird 2.5.2 64bit
Reporter: Frank Schlottmann-Goedde
create a simple freepascal udf:
library test64;
uses
strings;
procedure str_same(instring
p after using a hex-editor to rename
rdb$admin to e.g rdbxadmin.
mit freundlichen Grüßen
Frank Schlottmann-Gödde
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly fa
Environment: any
Reporter: Frank Schlottmann-Goedde
Priority: Critical
The following statement that used to work in fb2.5 throws an error in 2.5.1:
Here are the results for both versions:
First FB 2.5.0:
SQL> show version;
ISQL Version: LI-P2.5.0.26091 Firebird 2.5
ation). When recovering from such an exception, a deadlock will
occur. Is there any reason why fbclient should not be built using the
asynchronous exception model (i.e. using the /EHa option)?
Thanks,
Frank
--
Benefiting
many databases)
I hope I can switch from our udf to built in uuids in the near future.
mit freundlichen Grüßen
Frank Schlottmann-Gödde
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly f
ll put that in a list for a
> possible pro/con discussion.
And they should better be distinct :-)
mit freundlichen Grüßen
Frank Schlottmann-Gödde
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly f
73 matches
Mail list logo
