Re: [HACKERS] bug in contrib/adddepend

2003-03-06 Thread Christopher Kings-Lynne
> Was this resolved. Christopher, do you have a reproducible case? Oh sorry, I answered the wrong question! Yes, I resolved it by reinstalling my DBD perl stuff. I still have the problem of left over constraint triggers, but they do look like they're broken, so it's not an adddepend problem...

Re: [HACKERS] bug in contrib/adddepend

2003-03-06 Thread Christopher Kings-Lynne
> Was this resolved. Christopher, do you have a reproducible case? It wasn't resolved, in fact I'd forgotten about it :) I do have a reproducible case (our live server), however it seems like it's basically a case of an invalid set of triggers. I really need to manually remove some of the trigg

Re: [HACKERS] bug in contrib/adddepend

2003-03-06 Thread Rod Taylor
On Thu, 2003-03-06 at 09:58, Bruce Momjian wrote: > Was this resolved. Christopher, do you have a reproducible case? I've not been able to reproduce it, nor have I had a similar complaint. I think it's a system configuration issue or somekind. Otherwise there would have been many many more comp

Re: [HACKERS] bug in contrib/adddepend

2003-03-06 Thread Bruce Momjian
Was this resolved. Christopher, do you have a reproducible case? --- Rod Taylor wrote: -- Start of PGP signed section. > > I worked around it by checking to see if it equalled '' as > > well as ''. I also have hea

Re: [HACKERS] bug in contrib/adddepend

2003-02-23 Thread Rod Taylor
> I worked around it by checking to see if it equalled '' as > well as ''. I also have heaps of RI triggers left over after the > addepend run, so I'll investigate why adddepend doesn't pick them up... Took a quick look, and I don't see anything in DBD-Pg that would do this type of conve

Re: [HACKERS] bug in contrib/adddepend

2003-02-23 Thread Christopher Kings-Lynne
> > See how it's HTMLised the foreign key name? I cannot find how $keyname in > > the code is being html escaped. Perhaps it's some weird taint mode thing? > > Not to mention when it's , the code is setup to ignore the > constraint name entirely (line 267). I worked around it by checking to see

Re: [HACKERS] bug in contrib/adddepend

2003-02-22 Thread Rod Taylor
On Thu, 2003-02-20 at 22:08, Christopher Kings-Lynne wrote: > Hi, > > I just noticed a bug in adddepend: > > The below commands will upgrade the foreign key style. Shall I execute > them? > > DROP TRIGGER "RI_ConstraintTrigger_1105102" ON news_authors; > DROP TRIGGER "RI_Constra

[HACKERS] bug in contrib/adddepend

2003-02-20 Thread Christopher Kings-Lynne
Hi, I just noticed a bug in adddepend: The below commands will upgrade the foreign key style. Shall I execute them? DROP TRIGGER "RI_ConstraintTrigger_1105102" ON news_authors; DROP TRIGGER "RI_ConstraintTrigger_1105103" ON news_authors; DROP TRIGGER "RI_ConstraintTrigge