Hi
there are
SET DECFLOAT BIND double precision;
SET TIME ZONE BIND
Is there a way to read current settings?
Is there a way to restore it then?
eg.
var_previous = GET DECFLOAT BIND;
SET DECFLOAT BIND double precision;
/* calculate something */
/* and now restore previous settings */
On 9-9-2019 12:35, liviuslivius wrote:
Hi
there are
SET DECFLOAT BIND double precision;
SET TIME ZONE BIND
Is there a way to read current settings?
Is there a way to restore it then?
eg.
var_previous = GET DECFLOAT BIND;
SET DECFLOAT BIND double precision;
/* calculate something */
/* and now res
Behavior of Oracle 11 + Postgres 9.6.
*Common DDL*:
create table master (id number primary key);
create table detail (id number primary key, master number);
alter table detail add foreign key (master) references master(id) on delete
cascade;
*Oracle (2 sqlplus windows)*:
tx1:
set transaction isol
Title: Re: [Firebird-devel] Inserts and FKs
Thank you!
[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br
Behavior of Oracle 11 + Postgres 9.6.
Common DDL:
create table master (id number primary key);
create table detail (id number primary key, master number);
alt
>>I'm not aware of an option to query the current configuration.Will be good to
>>have it. Consider situation when in some stored proc you need different
>>behvior. You do not know to what walue you should restore settings, as you do
>>not have a way to read it at start of proc.Regards,Karol Bie
07.09.2019 19:35, Ann Harrison wrote:
...
It's also an old bug, probably dating to the implementation of foreign keys in
InterBase.
The obvious implementation - validate the foreign key in the context of the client transaction - fails miserably in snapshot mode
when the parent record is deleted
On 9-9-2019 14:37, liviuslivius wrote:
>>I'm not aware of an option to query the current configuration.
Will be good to have it. Consider situation when in some stored proc you
need different behvior. You do not know to what walue you should restore
settings, as you do not have a way to read
Maybe this sample will be better. Some sql tool which need run itself some
internall queries but user need different settings for he/she queries by this
tool.P.S. I also think about introducing some new SET command for sql plan
format retrived in MON$Statements i need to know if i should impleme
> On Sep 9, 2019, at 9:45 AM, Vlad Khorsun wrote:
>
> 07.09.2019 19:35, Ann Harrison wrote:
> ...
>> It's also an old bug, probably dating to the implementation of foreign keys
>> in
>> InterBase.
>> ...it's certainly legitimate.
>
> So, to fix this we need to repeat validation of master re
