Re: [Firebird-devel] GPRE and Pascal

2017-03-30 Thread Frank Schlottmann-Gödde
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/

Re: [Firebird-devel] SET TRANSACTION option to disable replication

2014-11-08 Thread Frank Schlottmann-Gödde
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 and I

Re: [Firebird-devel] Firebird 3.0 beta database recover problem: object has non-SQL security class defined

2014-10-27 Thread Frank Schlottmann-Gödde
Am 27.10.2014 um 10:45 schrieb Dmitry Yemanov: 27.10.2014 12:30, Robbert-Jan wrote: While restoring a database with FB 3.0 beta 1 (backed-up with FB3 alpha 2), I get this error: action cancelled by trigger (3) to preserve data integrity object has non-SQL security class defined Can you

Re: [Firebird-devel] error on restore

2014-10-06 Thread Frank Schlottmann-Gödde
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:Exiting before completion due to errors when trying

[Firebird-devel] error on restore

2014-10-02 Thread Frank Schlottmann-Gödde
Hi, I'm getting gbak: ERROR:action cancelled by trigger (3) to preserve data integrity gbak: ERROR:object has non-SQL security class defined gbak:Exiting before completion due to errors when trying to restore a backup created by version LI-T3.0.0.31199 with version LI-T3.0.0.31348 any ideas?

Re: [Firebird-devel] SF.net SVN: firebird:[59774] firebird/trunk/src

2014-07-02 Thread Frank Schlottmann-Gödde
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 move the stuff to isql.h

Re: [Firebird-devel] SF.net SVN: firebird:[59774] firebird/trunk/src

2014-07-02 Thread Frank Schlottmann-Gödde
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();

Re: [Firebird-devel] SF.net SVN: firebird:[59774] firebird/trunk/src

2014-07-02 Thread Frank Schlottmann-Gödde
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. I think you should do it different, for example, passing extra

Re: [Firebird-devel] Feature request discussion (Reply to Planning the post v3 development)

2014-05-05 Thread Frank Schlottmann-Gödde
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.

Re: [Firebird-devel] libedit update for 2.5.x

2013-09-14 Thread Frank Schlottmann-Gödde
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 configure myself (on fresh gentoo) cause

Re: [Firebird-devel] FK Constraints and GTTs

2013-09-11 Thread Frank Schlottmann-Gödde
Am 10.09.2013 23:34, schrieb Ann Harrison: On Tue, Sep 10, 2013 at 5:23 PM, Vlad Khorsun hv...@users.sourceforge.net 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

Re: [Firebird-devel] libedit update for 2.5.x

2013-09-03 Thread Frank Schlottmann-Gödde
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. And (provided they build --with-sustem-editline, in which

Re: [Firebird-devel] libedit update for 2.5.x

2013-09-03 Thread Frank Schlottmann-Gödde
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 ? I ask this because in debian libedit2 i s already

Re: [Firebird-devel] libedit update for 2.5.x

2013-09-03 Thread Frank Schlottmann-Gödde
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's

Re: [Firebird-devel] libedit update for 2.5.x

2013-09-03 Thread Frank Schlottmann-Gödde
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 OK. May be it's really

Re: [Firebird-devel] libedit update for 2.5.x

2013-09-02 Thread Frank Schlottmann-Gödde
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 ? I ask this because in debian libedit2 i s already updated and it would be nice if also in the 2.5.x branch would be done so I think that all

Re: [Firebird-devel] CORE-362

2013-08-05 Thread Frank Schlottmann-Gödde
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 immensely heavy loads, their tears

[Firebird-devel] CORE-362

2013-08-03 Thread Frank Schlottmann-Gödde
Hi, due to an upstream bugfix http://cvsweb.netbsd.org/bsdweb.cgi/src/lib/libedit/read.c.diff?r1=1.69r2=1.70hideattic=0sortby=date fixing the last problem I had (with pipes), the editline fork from http://www.thrysoee.dk/editline/libedit-20130712-3.1.tar.gz is finally useable as a drop-in

[Firebird-devel] CTE problem

2012-11-20 Thread Frank Schlottmann-Gödde
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 select I + 1 from CTE_CNT1 where I 9), CTE_CNT2 as (select I, 0 as J from CTE_CNT1 union all select

[Firebird-devel] Some more issues with FB3.0

2012-10-24 Thread Frank Schlottmann-Gödde
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 heavy loads, their

Re: [Firebird-devel] Some more issues with FB3.0

2012-10-24 Thread Frank Schlottmann-Gödde
Am 24.10.2012 10:19, schrieb Mark Rotteveel: On Wed, 24 Oct 2012 10:05:10 +0200, Frank Schlottmann-Gödde fr...@schlottmann-goedde.de 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't know whether to discuss

Re: [Firebird-devel] libeditline and POSIX build

2012-01-12 Thread Frank Schlottmann-Gödde
-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) $(LIBEDITLINE

Re: [Firebird-devel] libeditline and POSIX build

2012-01-11 Thread Frank Schlottmann-Gödde
-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)

Re: [Firebird-devel] LibTomMath and POSIX build

2012-01-10 Thread Frank Schlottmann-Gödde
-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 FB3 ubuntu's 8.04 LTS

[Firebird-devel] libeditline and POSIX build

2012-01-10 Thread Frank Schlottmann-Gödde
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

Re: [Firebird-devel] LibTomMath and POSIX build

2012-01-09 Thread Frank Schlottmann-Gödde
-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 popular and stable after year 2008

Re: [Firebird-devel] LibTomMath and POSIX build

2012-01-09 Thread Frank Schlottmann-Gödde
-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 or not. Yes it does, but we

Re: [Firebird-devel] LibTomMath and POSIX build

2012-01-09 Thread Frank Schlottmann-Gödde
-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

Re: [Firebird-devel] LibTomMath and POSIX build

2012-01-08 Thread Frank Schlottmann-Gödde
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 of the

[Firebird-devel] no database triggers switch for qli

2011-12-09 Thread Frank Schlottmann-Gödde
Schlottmann-Gödde -- Fascinating creatures, phoenixes, they can carry immensely heavy loads, their tears have healing powers and they make highly faithful pets. - J.K. Rowling -- Cloud Services Checklist: Pricing

Re: [Firebird-devel] Firebird backup fails to restore

2011-05-13 Thread Frank Schlottmann-Gödde
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 faithful pets. - J.K. Rowling