| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "Hackers" <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | "Rod Taylor" <rbt(at)rbt(dot)ca> |
| Subject: | bug in contrib/adddepend |
| Date: | 2003-02-21 03:08:59 |
| Message-ID: | 08fa01c2d956$95719920$6500a8c0@fhp.internal |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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_ConstraintTrigger_1105118" ON news_articles;
ALTER TABLE news_articles ADD CONSTRAINT "<unnamed>" FOREIGN
KEY (author)
REFERENCES news_authors(id) MATCH SIMPLE ON UPDATE NO
ACTION ON DELETE NO ACTION;
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?
Rod - you got any ideas?
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-02-21 03:23:13 | Re: A bad behavior under autocommit off mode |
| Previous Message | Christopher Kings-Lynne | 2003-02-21 02:51:13 | Re: contrib/adddepend |