Re: Bug in RI

Did you compile from sources or install from a binaries package?
I think it would be handy to get a notice from where I think it's
failing to open the relation to make sure it's getting the correct
parameter there. (I don't have source in front of me to give you
a patch - I'll send one tonight)

Stephan Szabo
sszabo(at)bigpanda(dot)com

On Fri, 22 Sep 2000, Jeroen van Vianen wrote:

> At 10:18 21-9-00 -0700, Stephan Szabo wrote:
> >Odd, it looks like it had trouble doing the heap_openr
> >on the relation, although I don't immediately see why...
> >
> >What does
> > select * from pg_trigger where
> > tgconstrname='fk_folders__parent'
> >give you?
>
> First it didn't give me anything (0 rows). After I recreated the constraint
> triggers:
>
> CREATE CONSTRAINT TRIGGER "fk_folders__parent" AFTER INSERT OR UPDATE ON
> "folders" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE
> PROCEDURE "RI_FKey_check_ins" ('fk_folders__parent', 'folders', 'folders',
> 'UNSPECIFIED', 'parent', 'nr');
>
> CREATE CONSTRAINT TRIGGER "fk_folders__parent" AFTER DELETE ON
> "folders" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE
> PROCEDURE "RI_FKey_noaction_del" ('fk_folders__parent', 'folders',
> 'folders', 'UNSPECIFIED', 'parent', 'nr');
>
> CREATE CONSTRAINT TRIGGER "fk_folders__parent" AFTER UPDATE ON
> "folders" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE
> PROCEDURE "RI_FKey_noaction_upd" ('fk_folders__parent', 'folders',
> 'folders', 'UNSPECIFIED', 'parent', 'nr');
>
> the above query returned three rows:
>
> jeroenv=> select * from pg_trigger where tgconstrname='fk_folders__parent' ;
> tgrelid | tgname | tgfoid | tgtype | tgenabled |
> tgisconstr
> aint | tgconstrname | tgconstrrelid | tgdeferrable | tginitdeferred |
> tgna
> rgs | tgattr | tgargs
>
> ---------+----------------------------+--------+--------+-----------+-----------
> -----+--------------------+---------------+--------------+----------------+-----
> ----+--------+------------------------------------------------------------------
> -----------
> 20152 | RI_ConstraintTrigger_21856 | 1644 | 21 | t | t
> | fk_folders__parent | 0 | f | f |
> 6 | |
> fk_folders__parent\000folders\000folders\000UNSPECIFIED\000parent
> \000nr\000
> 20152 | RI_ConstraintTrigger_21858 | 1654 | 9 | t | t
> | fk_folders__parent | 0 | f | f |
> 6 | |
> fk_folders__parent\000folders\000folders\000UNSPECIFIED\000parent
> \000nr\000
> 20152 | RI_ConstraintTrigger_21860 | 1655 | 17 | t | t
> | fk_folders__parent | 0 | f | f |
> 6 | |
> fk_folders__parent\000folders\000folders\000UNSPECIFIED\000parent
> \000nr\000
> (3 rows)
>
> But the same query (update folders set title='Sitemap' where nr=43) still
> crashes the backend at exactly the same spot.