Re: [HACKERS] FOREIGN KEY and shift/reduce

Hiroshi Inoue wrote:

> Nice.
> I tried a little.
>
> [...]
> => begin;
> BEGIN
> => delete from ri1 where id=1;
> DELETE 1
>
> < session 2 >
> => insert into ri2 values (1);
> INSERT 92960 1
>
> < session 1 >
> => commit;
> END
> => select * from ri1;
> id
> --
> (0 rows)
> => select * from ri2;
> id
> --
> 1
> (1 row)
>
> Is this a temporary behavior ?

Fixed.

Session 2 waits now until session 1 ends transaction.

I'm thinking about another enhancement to the regression test
now. Something where at least two sessions can run queries
in a predefined order. Otherwise, something like the above
cannot be checked during regression.

I'm not sure how that can be done with a standard shell, and
that's a must. Maybe something using named pipes and so -
will play around a little.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#========================================= wieck(at)debis(dot)com (Jan Wieck) #