Forum OpenACS Q&A: Re: PG 7.2->7.3 upgrade gotcha?

Collapse
19: Re: PG 7.2->7.3 upgrade gotcha? (response to 1)
Posted by Jun Yamog on 08/22/03 03:19 PM
Oh yeah my perl is rusty, please comment if there are any problems.
Collapse
21: Re: PG 7.2->7.3 upgrade gotcha? (response to 19)
Posted by Dave Bauer on 08/28/03 09:05 PM
I found a little glitch running this on the openacs.org database. It likely will never show up on any other data.

On line 39

the code reads

    if ($_ =~ /CREATE FUNCTION "(.*)"/) {

and it will capture the functions inside of data such as forum postings.

I changed it to

    if ($_ =~ /^CREATE FUNCTION "(.*)"/) {

to only find CREATE FUNCTION at the beginning of a line and it seems to work.