Thread: refint (& others?) on current snapshot

Snapshot of a few hours ago on 3.2 FreeBSD.  The trigger regression test
(and a few others) fail.  From looking at it, the trigger regression test
fails because refint fails.

If one simply tries to use the stuff in contrib/spi, the failure is pretty
easy to
see -- the example in contrib/spi/refint.example fails:
CREATE TRIGGER CT BEFORE INSERT OR UPDATE ON C FOR EACH ROW
EXECUTE PROCEDURE
check_primary_key ('REFC', 'A', 'ID');
CREATE

-- Now try

INSERT INTO A VALUES (10);
INSERT 18567 1
INSERT INTO A VALUES (20);
INSERT 18568 1
INSERT INTO A VALUES (30);
INSERT 18569 1
INSERT INTO A VALUES (40);
INSERT 18570 1
INSERT INTO A VALUES (50);
INSERT 18571 1

INSERT INTO B VALUES (1);       -- invalid reference
pqReadData() -- backend closed the channel unexpectedly.       This probably means the backend terminated abnormally
  before or while processing the request.
 
We have lost the connection to the backend, so further processing is
impossible.  Terminating.

I assume this is fixed in 6.5.


[Charset iso-8859-1 unsupported, filtering to ASCII...]
> Snapshot of a few hours ago on 3.2 FreeBSD.  The trigger regression test
> (and a few others) fail.  From looking at it, the trigger regression test
> fails because refint fails.
> 
> If one simply tries to use the stuff in contrib/spi, the failure is pretty
> easy to
> see -- the example in contrib/spi/refint.example fails:
> CREATE TRIGGER CT BEFORE INSERT OR UPDATE ON C FOR EACH ROW
> EXECUTE PROCEDURE
> check_primary_key ('REFC', 'A', 'ID');
> CREATE
> 
> -- Now try
> 
> INSERT INTO A VALUES (10);
> INSERT 18567 1
> INSERT INTO A VALUES (20);
> INSERT 18568 1
> INSERT INTO A VALUES (30);
> INSERT 18569 1
> INSERT INTO A VALUES (40);
> INSERT 18570 1
> INSERT INTO A VALUES (50);
> INSERT 18571 1
> 
> INSERT INTO B VALUES (1);       -- invalid reference
> pqReadData() -- backend closed the channel unexpectedly.
>         This probably means the backend terminated abnormally
>         before or while processing the request.
> We have lost the connection to the backend, so further processing is
> impossible.  Terminating.
> 
> 
> 
> 
> 


--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026