Thread

1. POSTGRES BUG - FIX IT PLEASE

   Sergey Mavrinsky <mavr@solvo.ru> — 2000-10-06T14:43:45Z

   I attach bug.template file with description of my problem.
   
   Please fix it asap.
   
   
   --
   Keep in touch.
   Sergey Mavrinsky.
   Solvo Ltd.
   
   
   

2. Re: POSTGRES BUG - FIX IT PLEASE

   Peter Eisentraut <peter_e@gmx.net> — 2000-10-10T19:40:00Z

   Sergey Mavrinsky writes:
   
   > create table t1
   > (
   >         f1 integer,
   >         f2 integer
   > );
   > 
   > create table t2
   > (
   >         f1 integer references t1(f1),
   >         f2 integer
   > );
   
   > begin transaction;
   > insert into t1(f1,f2) values(1,1);
   > delete from t1 where f1=1;
   
   > ERROR:  triggered data change violation on relation "t1"
   
   You cannot change data twice within a transaction if there's a RI
   constraint on the table.  This is per SQL, nothing we can do about it.
   
   -- 
   Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/