From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | "Erik Jones" <erik(at)myemma(dot)com> |
Cc: | "Campbell, Lance" <lance(at)uiuc(dot)edu>, "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: work_mem and shared_buffers |
Date: | 2007-11-09 20:47:01 |
Message-ID: | dcc563d10711091247j206800ddtee35393b0fef324e@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Nov 9, 2007 2:38 PM, Erik Jones <erik(at)myemma(dot)com> wrote:
>
> >
> > I imagine in a few years, hardly anyone using postgresql will remember
> > the ancient art of having either apostrophes in a row inside your
> > plpgsql functions...
>
> Speaking of that devil, I started working with Postgres mere months
> after that particular evil went away but we still have a good bit of
> plpgsql with it in production. I've been meaning to convert it and
> clean it up for a while now. Would you, or anybody, happen to know
> of any scripts out there that I could grab to make a quick job, no
> brains required of it?
Man, I can't think of any. I'd assume you'd need to look for the
longest occurance of ' marks, and replace it with one field, say $1$
or something, then the next smaller set, with $2$ or something and so
on. I imagine one could write a script to do it. Luckily, we only
had one or two levels of ' marks in any of our stored procs, so it was
only a few minutes each time I edited one to switch it over.
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Smet | 2007-11-09 20:57:27 | Re: [HACKERS] Estimation problem with a LIKE clause containing a / |
Previous Message | Erik Jones | 2007-11-09 20:38:43 | Re: work_mem and shared_buffers |